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);
}
