$message = ""; $food_or_drink; $f_o_d == 0 ? $food_or_drink = "FOOD" : ($food_or_drink = "DRINK"); /* echo "item: " . $item_name . "\n" . "price: " . $price . "\n" . "quantity: " . $quantity . "\n" . "stock_count: " . $stock_count . "\n" . "age_check: " . $age_check . "\n" . "food or drink: " . $food_or_drink . "\n";*/ $validName = !empty($item_name); $validPrice = is_numeric($price) && $price > 0; $validQuantity = is_numeric($quantity) && $quantity >= 0; if ($validName && $validPrice && $validQuantity) { $insertedItem = insertItem($item_name, $price, $quantity, $stock_count, $age_check, $food_or_drink, $con); if ($insertedItem[0]) { $newItemID = getItemID($item_name, $con); foreach ($_POST['pages'] as $check) { insertItemPagePosition($newItemID, $check, $con); } } // isInserted $message .= "Successfully Added To Database!"; } else { $message .= "NOT VALID\n name " . $validName . "\n price " . $validPrice . "\n quantity " . $validQuantity . "\n"; } } // if post $array = selectPages($con); mysqli_close($con); ?> <!DOCTYPE html>
$item->id = $row["ID"]; $array[] = $item; } } else { printf("no results!"); } mysqli_free_result($result); return $array; } $con = mysqli_connect("dbhost.cs.man.ac.uk", "mbbx9mg3", "Fincherz+2013") or die("Error " . mysqli_error($link)); mysqli_select_db($con, "mbbx9mg3"); if (isset($_POST["submit_button"])) { $itemsList = $_POST['items']; $message = ""; foreach ($_POST['items'] as $check) { $newItemID = getItemID($check, $con); removeItem($newItemID, $con); } $message = "Removed Successfully!"; } // isInserted $array = selectItems($con); mysqli_close($con); ?> <!DOCTYPE html> <!-- To change this license header, choose License Headers in Project Properties. To change this template file, choose Tools | Templates and open the template in the editor. --> <html>
} else { printf("no results!"); } mysqli_free_result($result); return $array; } $con = mysqli_connect("dbhost.cs.man.ac.uk", "mbbx9mg3", "Fincherz+2013") or die("Error " . mysqli_error($link)); mysqli_select_db($con, "mbbx9mg3"); $validNewAmount = false; if (isset($_POST["submit_button"])) { $itemSelected = $_POST['item']; $newAmount = $_POST['newAmount']; $message = ""; $validNewAmount = is_numeric($newAmount) && $newAmount >= 0; if ($validNewAmount) { $id = getItemID($itemSelected, $con); updateStock($id, $newAmount, $con); $message = "Stock updated successfully!"; } else { $message = "Please check your input again!\n is int: " . is_int($newAmount) . ", >= 0 : " . ($newAmount >= 0) . ""; } } // isInserted $array = selectItems($con); mysqli_close($con); ?> <!DOCTYPE html> <!-- To change this license header, choose License Headers in Project Properties. To change this template file, choose Tools | Templates and open the template in the editor.