if( $count != 0 || $count != 1 ) { //you managed to name two different categories. You are teh suckorz. } else { $catid = -1; if( $count == 0 ) { $sql = "INSERT INTO categories (name, number) VALUES (?, ?)"; $values = array($row[6], $row[7]); $db->qwv($sql, $values); if( $db->stat() ) { $catid = $db->last(); } else { $catid = -1; } } elseif( $count == 1 ) { $catid = $res[0]['categoryid']; } $sql = "INSERT INTO items (categoryid, name, description, image, price, prepTime, hasCookLevels) VALUES (?,?,?,?,?,?,?)"; $values = array($catid, $row[0], $row[1], $row[2], $row[3], $row[4], $row[5]); $db->qwv($sql, $values); if( $db->stat() )
/** * Execute function, permet d'executer une requete * * * @author Curtis Pelissier <*****@*****.**> * * @param array $array les parametres * @return int */ public static function _execute($array = array()) { if (empty($array) || count($array) == 0) { self::$last = self::$prep->execute(); } else { self::$last = self::$prep->execute($array); } if (self::$last === false) { self::$error = self::$prep->errorInfo(); } self::$last = self::$prep->fetchAll(); return self::$last; }
//split ingredients into ind ingredients $item_ingredient = explode(",", $item_ingredients); //same for chars $item_characteristic = explode(",", $item_characteristics); //if category does not exist, add it //find the category. If it doesn't exist, create it. $sql = "SELECT * FROM categories WHERE LCASE(name)=? OR LCASE(number)=?"; $values = array(strtolower($item_category_name), strtolower($item_category_number)); $res = $db->qwv($sql, $values); $count = count($res); if( !($count != 0 || $count != 1 )) { echo "you managed to name two different categories. You are teh suckorz. ".$count."<br />"; } else { $catid = -1; if( $count == 0 ) { $sql = "INSERT INTO categories (name, number) VALUES (?, ?)"; $values = array($item_category_name, $item_category_number); $db->qwv($sql, $values); if( $db->stat() ) { $catid = $db->last(); } else {