$res = $db->qwv($sql, $values); $count = count($res); 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]);
print $ingredient['isAllergenic'] ? "Allergy Warning" : ""; } */ } } } //print total print "<br />Total: ".$total; //status $dstat = $d->stat(); echo "<br />STATUS: ".$dstat."<br/><br/>"; $tot_categories = $d->q("SELECT * FROM categories"); foreach($tot_categories as $tot_category) { print "Category-id: ".$tot_category['categoryid']."<br/>"; print "Category-name: ".$tot_category['name']."<br/>"; print "Category-number: ".$tot_category['number']."<br/>------------------------------------><br/>"; } echo "__USERS__<br />"; echo "_userid__fname__lname<br />"; $sql = "SELECT * FROM users"; $users = $d->q($sql);
$item_category_number = $_POST['item_category_number']; //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(); }