Server : ApacheSystem : Linux sh00666.bluehost.com 5.14.0-687.26.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jul 14 16:32:02 EDT 2026 x86_64 User : ndkhermy ( 1200) PHP Version : 8.5.12 Disable Function : NONE Directory : /home1/ndkhermy/www/website_6ca89795/ |
Upload File : |
<?php
session_start();
include('dbcon.php');
if (!isset($_SESSION['session_id'])) {
$_SESSION['session_id'] = session_create_id(); // Unique session ID for guest users
}
if (isset($_POST['add_to_cart'])) {
$product_id = intval($_POST['product_id']);
$quantity = intval($_POST['quantity']);
$user_id = isset($_SESSION['id']) ? intval($_SESSION['id']) : 0; // Check if user is logged in
$session_id = $_SESSION['session_id'];
// If user is not logged in, use session_id for guest cart
if ($user_id > 0) {
$stmt = $conn->prepare("SELECT * FROM cart_items WHERE user_id = ? AND product_id = ?");
$stmt->bind_param("ii", $user_id, $product_id);
} else {
$stmt = $conn->prepare("SELECT * FROM cart_items WHERE session_id = ? AND product_id = ?");
$stmt->bind_param("si", $session_id, $product_id);
}
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows > 0) {
// If product already exists, update quantity
if ($user_id > 0) {
$stmt = $conn->prepare("UPDATE cart_items SET quantity = quantity + ? WHERE user_id = ? AND product_id = ?");
$stmt->bind_param("iii", $quantity, $user_id, $product_id);
} else {
$stmt = $conn->prepare("UPDATE cart_items SET quantity = quantity + ? WHERE session_id = ? AND product_id = ?");
$stmt->bind_param("isi", $quantity, $session_id, $product_id);
}
} else {
// Insert new product to cart
if ($user_id > 0) {
$stmt = $conn->prepare("INSERT INTO cart_items (user_id, product_id, quantity) VALUES (?, ?, ?)");
$stmt->bind_param("iii", $user_id, $product_id, $quantity);
} else {
$stmt = $conn->prepare("INSERT INTO cart_items (session_id, product_id, quantity) VALUES (?, ?, ?)");
$stmt->bind_param("ssi", $session_id, $product_id, $quantity);
}
}
if ($stmt->execute()) {
echo "<script>alert('Product added to cart successfully.'); window.location.href = 'destinations.php';</script>";
} else {
echo "<script>alert('Error adding product to cart. Please try again.');</script>";
}
$stmt->close();
$conn->close();
}
?>