$qty) { // Fetch product details $stmt = $pdo->prepare(" SELECT v.id as vid, v.name as v_name, v.price, p.name as p_name, p.thumbnail_url FROM product_variants v JOIN products p ON v.product_id = p.id WHERE v.id = ? "); $stmt->execute([$variant_id]); $item = $stmt->fetch(PDO::FETCH_ASSOC); if ($item) { // Valid Item Found $item['qty'] = $qty; $item['line_total'] = $item['price'] * $qty; $subtotal += $item['line_total']; $cart_details[] = $item; $valid_ids[$variant_id] = $qty; // Keep this ID } } } // 2. UPDATE SESSION (Remove Ghost Items) // If the DB had fewer items than the session, update the session to match reality if (count($valid_ids) !== count($cart_items)) { $_SESSION['cart'] = $valid_ids; // Optional: Refresh to update the header badge immediately // header("Location: cart.php"); } // 3. COUPON LOGIC $discount = 0; if (isset($_SESSION['coupon'])) { if ($_SESSION['coupon']['type'] == 'fixed') { $discount = $_SESSION['coupon']['value']; } else { $discount = ($subtotal * $_SESSION['coupon']['value']) / 100; } } // 4. FINAL TOTAL $final_total = max(0, $subtotal - $discount); ?>

Your Cart is Empty

Looks like you haven't added any tools yet.

Browse Shop

Your Shopping Cart

Product	Price	Quantity	Total

Have a Coupon?

Coupon Applied Successfully!

Subtotal:

0): ?>

Discount: - [Remove]

Checkout