prepare("DELETE FROM cart WHERE id = ? AND user_id = ?"); $stmt->execute([$cart_id, $user_id]); $message = "Item removed from cart."; } // Fetch all cart items $stmt = $pdo->prepare("SELECT c.id as cart_id, c.quantity, p.* FROM cart c JOIN products p ON c.product_id = p.id WHERE c.user_id = ?"); $stmt->execute([$user_id]); $cart_items = $stmt->fetchAll(); $subtotal = 0; foreach ($cart_items as $item) { $subtotal += $item['price'] * $item['quantity']; } // Discount via points: Admin/User points setting. Let's load user's actual points. $stmt_user = $pdo->prepare("SELECT points FROM users WHERE id = ?"); $stmt_user->execute([$user_id]); $userData = $stmt_user->fetch(); $user_points = $userData['points'] ?? 0; $_SESSION['user_points'] = $user_points; // Refresh session points ?>

Shopping Cart 🛒

🛍️

Your cart is empty

Let's find some gorgeous outfits for you.

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

฿

Qty: | Subtotal: ฿

Order Summary

Subtotal ฿
Shipping Fee FREE
✨ Your loyalty points: pts
Estimated Total ฿
Proceed to Checkout