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;
}
