/** * Adds a new item to the database, returns 0 on failure */ public static function create($name, $type_id, $owner_id) { global $db; //TODO Check that owner_id, and item_type_id exist in database before insert. $variables = 'name, owner_id, item_type_id, has_photo'; $values = "'{$name}', {$owner_id}, {$type_id}, FALSE"; $query = Item::insert_items_db($variables, $values); $result = $db->query($query); if ($db->affected_rows > 0) { return $db->insert_id; } return 0; }