$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();
}
