decrypt_password($_GET['data']);
$data = explode("&", $data_decrypted);
$_SESSION['restorant_id'] = explode("=", $data[0])[1];
$_SESSION['table_id'] = explode("=", $data[1])[1];
$resto_res = $db->query("restorants", "SELECT * FROM restorants WHERE record_id = {$_SESSION['restorant_id']} LIMIT 1");
$restorant_data = $resto_res->fetch_assoc();
// check if there is a open order for this table:
$table_history_check_res = $db->query("temp_table_orders", "SELECT * FROM temp_table_orders WHERE table_id = {$_SESSION['table_id']} AND restorant_id = {$_SESSION['restorant_id']} LIMIT 1");
if ($table_history_check_res->num_rows > 0) {
$table_data = $table_history_check_res->fetch_assoc();
$_SESSION['temp_table_orders_id'] = $table_data['record_id'];
} else {
$_SESSION['temp_table_orders_id'] = $db->query("temp_table_orders", "INSERT INTO temp_table_orders (table_id, restorant_id) VALUES ({$_SESSION['table_id']}, {$_SESSION['restorant_id']})");
}
?>
WELCOME TO
PLEASE SELECT ONE OF THE OPTIONS
query("item_categories", "SELECT * FROM item_categories WHERE restorant_id = {$_SESSION['restorant_id']} ORDER BY name ASC");
while ($category = $item_categories_res->fetch_assoc()) {
echo "";
}
?>