getConnection();
// Get order details
$query = "SELECT o.*, sc.name as shipping_company_name
FROM orders o
LEFT JOIN shipping_companies sc ON o.shipping_company_id = sc.id
WHERE o.id = ?";
$stmt = $db->prepare($query);
$stmt->execute([$order_id]);
$order = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$order) {
die('الطلب غير موجود');
}
// Get order items
$query = "SELECT oi.*, p.name as product_name
FROM order_items oi
JOIN products p ON oi.product_id = p.id
WHERE oi.order_id = ?";
$stmt = $db->prepare($query);
$stmt->execute([$order_id]);
$items = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
بوليصة شحن - طلب #<?php echo $order_id; ?>