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