prepare("SELECT p.*, c.name as category_name FROM products p LEFT JOIN categories c ON p.category_id = c.id WHERE p.id = ?"); $stmt->execute([$id]); $product = $stmt->fetch(); if (!$product) { header('Location: index.php'); exit; } $message = ''; $error = ''; // Handle add-to-cart action if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add_to_cart'])) { if (!isLoggedIn()) { header('Location: login.php'); exit; } $qty = intval($_POST['quantity']); if ($qty < 1) $qty = 1; if ($qty > $product['stock']) { $error = "Sorry, only {$product['stock']} items available in stock."; } else { $user_id = $_SESSION['user_id']; // Check if item is already in the cart $stmt_check = $pdo->prepare("SELECT id, quantity FROM cart WHERE user_id = ? AND product_id = ?"); $stmt_check->execute([$user_id, $product['id']]); $existing_cart = $stmt_check->fetch(); if ($existing_cart) { $new_qty = $existing_cart['quantity'] + $qty; if ($new_qty > $product['stock']) { $error = "Cannot add more. Total quantity in cart exceeds available stock."; } else { $stmt_update = $pdo->prepare("UPDATE cart SET quantity = ? WHERE id = ?"); $stmt_update->execute([$new_qty, $existing_cart['id']]); $message = "Cart updated successfully!"; } } else { $stmt_insert = $pdo->prepare("INSERT INTO cart (user_id, product_id, quantity) VALUES (?, ?, ?)"); $stmt_insert->execute([$user_id, $product['id'], $qty]); $message = "Added to cart successfully!"; } // Refresh cart count session info or simply rely on database query in header } } ?>

← Back to Shop

<?php echo htmlspecialchars($product['name']); ?>

฿

Availability: 0): ?> items in stock Out of Stock

0): ?>

✨ Earn Rewards: You will earn approximately points from purchasing this item!