prepare("SELECT id, title, image_path, price, sale_price FROM paintings WHERE id IN ($id_placeholders)"); $stmt->bind_param($types, ...$painting_ids); $stmt->execute(); $result = $stmt->get_result(); while ($row = $result->fetch_assoc()) { $painting_id = $row['id']; $quantity = $cart_items[$painting_id]['quantity']; // Use sale price if available, otherwise regular price $price = (isset($row['sale_price']) && $row['sale_price'] > 0) ? $row['sale_price'] : $row['price']; $cart_details[$painting_id] = [ 'title' => $row['title'], 'image_path' => $row['image_path'], 'price' => $price, 'quantity' => $quantity, 'total' => $price * $quantity ]; $subtotal += $cart_details[$painting_id]['total']; } $stmt->close(); } ?>

Your Shopping Cart

Your cart is empty.

Looks like you haven't added any paintings to your cart yet.

Browse Paintings
    $item): ?>
  • <?php echo htmlspecialchars($item['title']); ?>

    ₹

Order summary

Subtotal
₹
Proceed to Checkout