prepare("SELECT * FROM orders WHERE user_id = ? ORDER BY id DESC"); $stmt->execute([$user_id]); $orders = $stmt->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, p.image_url 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; } } ?>

My Orders 📦

🌸
🛍️

No orders yet

You haven't ordered any lovely outfits yet.

Shop Now
Order ID

#ORD-

Date Placed
<?php echo htmlspecialchars($item['name']); ?>
Qty: × ฿
฿
Shipping Address:
0): ?>
Points Discount: -฿
Net Amount paid: ฿
✨ Earned + pts