function fetchTray() { require 'connect.php'; $orderId = $_SESSION['orderId']; $fetchOrderedDishes = " select * from dishOrders where orderId='" . $orderId . "';"; // echo 'Orderid : ' . $orderId . '<br />'; // echo 'fetch : ' . $fetchOrderedDishes; $result = mysqli_query($connection, $fetchOrderedDishes); $totalPrice = 0; if ($result->num_rows > 0) { echo "<form method='post'>"; while ($dish = mysqli_fetch_array($result)) { $totalPrice += printTrayItem($dish); } echo "<input id='saveChanges' type='submit' value='Save Changes'>"; echo "<input type='hidden' name='secondTime' value='true'>"; echo "</form>"; echo "<label id='totalPrice'>Total Price : ₹" . $totalPrice . "</label>"; echo "<input type='button' onclick='location.href=\"confirmOrder.php\";'\n\t\t\tvalue='Confirm Order' id='confirmOrder'/>"; } else { echo '<center id="emptyTray"><br />Sorry, there are no dishes in your tray currently</center>'; } }
// 2 very slightly different Rupee symbols // ₹ // ₹ echo '<br />_____________________________________________________________' . '__________________________________________________________________' . '_______<br />'; return $dishPrice; } require 'connect.php'; $orderId = $_SESSION['orderId']; $fetchOrderedDishes = " select * from dishOrders where orderId='" . $orderId . "';"; // echo 'Orderid : ' . $orderId . '<br />'; // echo 'fetch : ' . $fetchOrderedDishes; $result = mysqli_query($connection, $fetchOrderedDishes); $totalPrice = 0; if ($result->num_rows > 0) { echo "<form action='confirmOrder.php' method='post'>"; while ($dish = mysqli_fetch_array($result)) { $totalPrice += printTrayItem($dish); } echo "<input id='confirmOrder2' type='submit' value='Confirm Order'>"; echo "</form>"; echo '<label id="totalPrice2">Total Price : ₹' . $totalPrice . '</label>'; } ?> <!DOCTYPE> <html> <head> <link rel="stylesheet" href="trayStyles.css" type="text/css"> </head>