'; if (!isset($_SESSION['user_id'])) { header("Location: login.php"); exit(); } if (!isset($_GET['id'])) { header("Location: profile.php"); exit(); } $order_id = $_GET['id']; $user_id = $_SESSION['user_id']; // Fetch order details $p_order = $db->prepare("SELECT o.*, r.name as restaurant_name FROM orders o JOIN restaurants r ON o.restaurant_id = r.id WHERE o.id = ? AND o.user_id = ?"); $p_order->execute([$order_id, $user_id]); $order = $p_order->fetch(PDO::FETCH_ASSOC); if (!$order) { echo "

Order not found or you do not have permission to view it.

"; include 'footer.php'; exit(); } // Fetch order items $p_items = $db->prepare("SELECT oi.*, mi.name as item_name FROM order_items oi JOIN menu_items mi ON oi.menu_item_id = mi.id WHERE oi.order_id = ?"); $p_items->execute([$order_id]); $items = $p_items->fetchAll(PDO::FETCH_ASSOC); // Fetch assigned driver $p_driver = $db->prepare("SELECT d.full_name FROM drivers d JOIN driver_assignments da ON d.id = da.driver_id WHERE da.order_id = ?"); $p_driver->execute([$order_id]); $driver = $p_driver->fetch(PDO::FETCH_ASSOC); ?>

Order Details #

Summary

Restaurant:

Order Date:

Total: $

Status:

Driver:

Items

(x) $

Back to My Orders