prepare("UPDATE orders SET status = ? WHERE id = ?"); $stmt->execute([$new_status, $order_id]); $message = "Order status updated successfully."; } } // Fetch all orders with user names $orders = $pdo->query("SELECT o.*, u.full_name, u.email FROM orders o JOIN users u ON o.user_id = u.id ORDER BY o.id DESC")->fetchAll(); // Cache order items for easy lookup $order_ids = array_column($orders, 'id'); $items_by_order = []; if (!empty($order_ids)) { $in_clause = implode(',', array_fill(0, count($order_ids), '?')); $stmt_items = $pdo->prepare(" SELECT oi.*, p.name FROM order_items oi JOIN products p ON oi.product_id = p.id WHERE oi.order_id IN ($in_clause) "); $stmt_items->execute($order_ids); $items = $stmt_items->fetchAll(); foreach ($items as $item) { $items_by_order[$item['order_id']][] = $item; } } ?>

Manage Customer Orders

All Orders List

No customer orders placed yet.

Order ID	Customer Info	Items Ordered	Net Total	Shipping Address	Status Control
#ORD-		- (x)	฿ 0): ?> Disc: -฿ Earn: + pts