prepare(" SELECT c.menu_item_id, c.quantity, mi.name, mi.price, mi.image_url, r.name as restaurant_name, r.id as restaurant_id FROM cart c JOIN menu_items mi ON c.menu_item_id = mi.id JOIN restaurants r ON c.restaurant_id = r.id WHERE c.user_id = ? "); $stmt->execute([$user_id]); $cart_items = $stmt->fetchAll(PDO::FETCH_ASSOC); } else { $stmt = db()->prepare(" SELECT c.menu_item_id, c.quantity, mi.name, mi.price, mi.image_url, r.name as restaurant_name, r.id as restaurant_id FROM cart c JOIN menu_items mi ON c.menu_item_id = mi.id JOIN restaurants r ON c.restaurant_id = r.id WHERE c.session_id = ? "); $stmt->execute([$session_id]); $cart_items = $stmt->fetchAll(PDO::FETCH_ASSOC); } if ($cart_items) { foreach ($cart_items as $item) { $total_quantity += $item['quantity']; $subtotal += $item['price'] * $item['quantity']; } $total_bill = $subtotal; // For now, total is same as subtotal. Can add taxes/fees later. } ?>

Your Shopping Cart

Your cart is empty.

Looks like you haven't added anything to your cart yet.

Continue Shopping
<?php echo htmlspecialchars($item['name']); ?>
From:
$

Order Summary

Total Items:
Subtotal: $
Total Bill: $
Proceed to Checkout Continue Shopping