Example #1
0
 /**
  * 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;
 }