public static function deleteItem($updatePackage) { $connect = databaseController::connectToDatabase(); $db = mysqli_real_escape_string($connect, $updatePackage['db']); $id = mysqli_real_escape_string($connect, $updatePackage['id']); $idType = mysqli_real_escape_string($connect, $updatePackage['idType']); $sqlStatement = "DELETE FROM " . $db . " WHERE " . $idType . "= " . $id; mysqli_query($connect, $sqlStatement); echo 'deleted'; }
public static function updateItem($updatePackage) { $connect = databaseController::connectToDatabase(); $type = mysqli_real_escape_string($connect, $updatePackage['type']); $db = mysqli_real_escape_string($connect, $updatePackage['db']); $text = mysqli_real_escape_string($connect, $updatePackage['text']); $id = mysqli_real_escape_string($connect, $updatePackage['id']); $idType = mysqli_real_escape_string($connect, $updatePackage['idType']); $sqlStatement = "UPDATE " . $db . " SET " . $type . "='" . $text . "' WHERE " . $idType . "=" . $id; mysqli_query($connect, $sqlStatement); }
public static function itemCreate($createPackage) { $connect = databaseController::connectToDatabase(); $restaurantAssociation = $createPackage['associatedRestaurantName']; $groupAssociation = $createPackage['associatedGroupName']; $categoryAssociation = $createPackage['associatedCategoryName']; $name = mysqli_real_escape_string($connect, $createPackage['menuItemName']); $description = mysqli_real_escape_string($connect, $createPackage['menuItemDescription']); $price = mysqli_real_escape_string($connect, $createPackage['pricingOption']); $sqlStatement = "INSERT INTO `ivars235_joomla`.`menuitem` (`iid`, `restaurantassociation`, `groupassociation`, `categoryassociation`, `iname`, `idescription`, `iprice`) VALUES ('','" . $restaurantAssociation . "','" . $groupAssociation . "','" . $categoryAssociation . "','" . $name . "','" . $description . "','" . $price . "')"; mysqli_query($connect, $sqlStatement); }
public static function userVerify($usertest) { $username = $usertest["username"]; $apikey = $usertest["apikey"]; $connect = databaseController::connectToDatabase(); $sqlStatement = "SELECT * from ivars235_joomla.menu_users WHERE username='******' AND apikey='" . $apikey . "'"; $arr = array(); $result = mysqli_query($connect, $sqlStatement); while ($row = mysqli_fetch_assoc($result)) { $arr[] = $row; } if (count($arr) != 1) { return false; } else { session_start(); $_SESSION["loggedin"] = "loggedin"; echo "clear"; } }
public static function getItemListByCategoryId($categoryID) { $connect = databaseController::connectToDatabase(); $sql = "SELECT * from ivars235_joomla.menuitem WHERE categoryassociation =" . $categoryID . " ORDER BY ivars235_joomla.menuitem.item_order ASC "; $arr = array(); $result = mysqli_query($connect, $sql); while ($row = mysqli_fetch_assoc($result)) { $arr[] = $row; } return $arr; }