Menu

STARTERS

‘.’

‘;
//initial query
$query = “Select * FROM starters”;

//execute query
try {
$stmt = $db->prepare($query);
$result = $stmt->execute($query_params);
}
catch (PDOException $ex) {
$response[“success”] = 0;
$response[“message”] = “Database Error!”;
die(json_encode($response));
}

// Finally, we can retrieve all of the found rows into an array using fetchAll
$rows = $stmt->fetchAll();

if ($rows){
foreach ($rows as $row) {
echo ‘

‘.$row[“item_name”].’

‘.’

‘.$row[“item_price”].’

‘;

}
}

// SOUPS

echo ‘

SOUPS

‘.’

‘;
//initial query
$query = “Select * FROM soups”;

//execute query
try {
$stmt = $db->prepare($query);
$result = $stmt->execute($query_params);
}
catch (PDOException $ex) {
$response[“success”] = 0;
$response[“message”] = “Database Error!”;
die(json_encode($response));
}

// Finally, we can retrieve all of the found rows into an array using fetchAll
$rows = $stmt->fetchAll();

if ($rows){
foreach ($rows as $row) {
echo ‘

‘.$row[“item_name”].’

‘.’

‘.$row[“item_price”].’

‘;

}
}

// HEALTHY LIGHT NEW DISHES

echo ‘

HEALTHY LIGHT NEW DISHES

‘.’

‘;
//initial query
$query = “Select * FROM healthyLightNewDishes”;

//execute query
try {
$stmt = $db->prepare($query);
$result = $stmt->execute($query_params);
}
catch (PDOException $ex) {
$response[“success”] = 0;
$response[“message”] = “Database Error!”;
die(json_encode($response));
}

// Finally, we can retrieve all of the found rows into an array using fetchAll
$rows = $stmt->fetchAll();

if ($rows){
foreach ($rows as $row) {
echo ‘

‘.$row[“item_name”].’

‘.’

‘.$row[“item_price”].’

‘;

}
}

// EXOTIC FRESH SEAFOOD

echo ‘

EXOTIC FRESH SEAFOOD

‘.’

‘;
//initial query
$query = “Select * FROM exoticFreshSeafood”;

//execute query
try {
$stmt = $db->prepare($query);
$result = $stmt->execute($query_params);
}
catch (PDOException $ex) {
$response[“success”] = 0;
$response[“message”] = “Database Error!”;
die(json_encode($response));
}

// Finally, we can retrieve all of the found rows into an array using fetchAll
$rows = $stmt->fetchAll();

if ($rows){
foreach ($rows as $row) {
echo ‘

‘.$row[“item_name”].’

‘.’

‘.$row[“item_price”].’

‘;

}
}

// FRUITY LIGHT DISHES

echo ‘

FRUITY & LIGHT DISHES

‘.’

‘;
//initial query
$query = “Select * FROM fruityLightDishes”;

//execute query
try {
$stmt = $db->prepare($query);
$result = $stmt->execute($query_params);
}
catch (PDOException $ex) {
$response[“success”] = 0;
$response[“message”] = “Database Error!”;
die(json_encode($response));
}

// Finally, we can retrieve all of the found rows into an array using fetchAll
$rows = $stmt->fetchAll();

if ($rows){
foreach ($rows as $row) {
echo ‘

‘.$row[“item_name”].’

‘.’

‘.$row[“item_price”].’

‘;

}
}

// FRESH ROAST DUCK

echo ‘

FRESH ROAST DUCK

‘.’

‘;
//initial query
$query = “Select * FROM freshRoastDuck”;

//execute query
try {
$stmt = $db->prepare($query);
$result = $stmt->execute($query_params);
}
catch (PDOException $ex) {
$response[“success”] = 0;
$response[“message”] = “Database Error!”;
die(json_encode($response));
}

// Finally, we can retrieve all of the found rows into an array using fetchAll
$rows = $stmt->fetchAll();

if ($rows){
foreach ($rows as $row) {
echo ‘

‘.$row[“item_name”].’

‘.’

‘.$row[“item_price”].’

‘;

}
}

// CHINESE DISHES

echo ‘

ALL TIME FAVOURITE CHINESE DISHES

‘.’

‘;
//initial query
$query = “Select * FROM chineseDishes”;

//execute query
try {
$stmt = $db->prepare($query);
$result = $stmt->execute($query_params);
}
catch (PDOException $ex) {
$response[“success”] = 0;
$response[“message”] = “Database Error!”;
die(json_encode($response));
}

// Finally, we can retrieve all of the found rows into an array using fetchAll
$rows = $stmt->fetchAll();

if ($rows){
foreach ($rows as $row) {
echo ‘

‘.$row[“item_name”].’

‘.’

‘.$row[“item_price”].’

‘;

}
}

// FRIED RICE & CHOWMEIN

echo ‘

FRIEND RICE & CHOWMEIN

‘.’

‘;
//initial query
$query = “Select * FROM friedRiceChowmein”;

//execute query
try {
$stmt = $db->prepare($query);
$result = $stmt->execute($query_params);
}
catch (PDOException $ex) {
$response[“success”] = 0;
$response[“message”] = “Database Error!”;
die(json_encode($response));
}

// Finally, we can retrieve all of the found rows into an array using fetchAll
$rows = $stmt->fetchAll();

if ($rows){
foreach ($rows as $row) {
echo ‘

‘.$row[“item_name”].’

‘.’

‘.$row[“item_price”].’

‘;

}
}

// SIDE ORDERS

echo ‘

SIDE ORDERS

‘.’

‘;
//initial query
$query = “Select * FROM sideOrders”;

//execute query
try {
$stmt = $db->prepare($query);
$result = $stmt->execute($query_params);
}
catch (PDOException $ex) {
$response[“success”] = 0;
$response[“message”] = “Database Error!”;
die(json_encode($response));
}

// Finally, we can retrieve all of the found rows into an array using fetchAll
$rows = $stmt->fetchAll();

if ($rows){
foreach ($rows as $row) {
echo ‘

‘.$row[“item_name”].’

‘.’

‘.$row[“item_price”].’

‘;

}
}

// EXTRA VALUE MEALS WITH UNLIMITED CHOICES

echo ‘

EXTRA VALUE MEALS WITH UNLIMITED CHOICES

‘.’

‘;
//initial query
$query = “Select * FROM extraValueMeals”;

//execute query
try {
$stmt = $db->prepare($query);
$result = $stmt->execute($query_params);
}
catch (PDOException $ex) {
$response[“success”] = 0;
$response[“message”] = “Database Error!”;
die(json_encode($response));
}

// Finally, we can retrieve all of the found rows into an array using fetchAll
$rows = $stmt->fetchAll();

if ($rows){
foreach ($rows as $row) {
echo ‘

‘.$row[“item_name”].’

‘.’

‘.$row[“item_price”].’

‘;

}
}

// ADD NEW CATEGORY HERE BY COPY PASTING ANY OF THE ABOVE CATEGORY CODE AND REPLACING NAMES OF TABLES

?>