File Contents: /home/u885320773/domains/sugatu.in/process/updateCartQuantity.php

<?php
session_start();
include 'admin/config.php'; // Include your database connection file

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Get the product ID and new quantity from the POST data
    $productId = $_POST['productId'];
    $newQuantity = $_POST['newQuantity'];

// Sanitize and validate input if needed

// Update the quantity in the cart table
    $sessionId = session_id();

$updateQuery = "UPDATE cart SET pquantity = ? WHERE session_id = ? AND product_id = ?";
    $updateStatement = $conn->prepare($updateQuery);
    $updateStatement->bind_param("iss", $newQuantity, $sessionId, $productId);

if ($updateStatement->execute()) {
        // Successfully updated the quantity in the database
        echo json_encode(['status' => 'success', 'message' => 'Quantity updated successfully']);
    } else {
        // Failed to update the quantity
        echo json_encode(['status' => 'error', 'message' => 'Error updating quantity']);
    }

$updateStatement->close();
    $conn->close();
} else {
    // Invalid request method
    echo json_encode(['status' => 'error', 'message' => 'Invalid request method']);
}
?>

⬅ Back to Directory