0){ $message[] = 'product already added to cart!'; }else{ mysqli_query($conn, "INSERT INTO `cart`(user_id, name, price, image, quantity) VALUES('$user_id', '$product_name', '$product_price', '$product_image', '$product_quantity')") or die('query failed'); $message[] = 'product added to cart!'; } }; if(isset($_POST['update_cart'])){ $update_quantity = $_POST['cart_quantity']; $update_id = $_POST['cart_id']; mysqli_query($conn, "UPDATE `cart` SET quantity = '$update_quantity' WHERE id = '$update_id'") or die('query failed'); $message[] = 'cart quantity updated successfully!'; } if(isset($_GET['remove'])){ $remove_id = $_GET['remove']; mysqli_query($conn, "DELETE FROM `cart` WHERE id = '$remove_id'") or die('query failed'); header('location:index.php'); } if(isset($_GET['delete_all'])){ mysqli_query($conn, "DELETE FROM `cart` WHERE user_id = '$user_id'") or die('query failed'); header('location:index.php'); } ?>
| image | name | price | quantity | total price | action | 0){ while($fetch_cart = mysqli_fetch_assoc($cart_query)){ ?>
|---|---|---|---|---|---|
| $/- | $/- | remove | no item added | '; } ?>||
| grand total : | $/- | delete all | |||