public static function getByCharacteristic($string) { global $db; $sql = "SELECT * FROM characteristics WHERE LOWER(characteristic)=?"; $values = array(strtolower($string)); $chars = $db->qwv($sql, $values); return Characteristic::wrap($chars); }
public static function getByItem($id) { global $db; //get characteristics linked to item $characteristicsSQL = "SELECT * FROM items_have_characteristics WHERE itemid=?"; $values = array($id); $charList = $db->qwv($characteristicsSQL, $values); //get characteristic info for each characteristic linked to the item $characteristicSQL = "SELECT * FROM characteristics WHERE characteristicid=?"; $characteristics = array(); $db->prep($characteristicSQL); foreach($charList as $charID) { $values = array($charID['characteristicid']); $char = $db->qwv(null, $values); array_push($characteristics, $char[0]); } return Characteristic::wrap($characteristics); }