FoodMart/addToCartProcess.php at main · FHMNx/FoodMart · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
<?php

include "connection.php";
session_start();

if(isset($_SESSION["u"])){

    if(isset($_GET["id"])){

        $user_email = $_SESSION["u"]["email"];
        $pid = $_GET["id"];
        $qty = $_GET["qty"];

        $cart_rs = Database::search("SELECT * FROM `cart` WHERE `cart_users_email` = '".$user_email."' AND `cart_product_id` = '".$pid."' ");
        $cart_num = $cart_rs->num_rows;

        if($cart_num == 1){

            $cart_data = $cart_rs->fetch_assoc();

            $current_qty = $cart_data["cart_qty"];
            $new_qty = (int)$current_qty + 1;

            if($qty >= $new_qty){

                Database::iud("UPDATE `cart` SET `cart_qty` = '".$new_qty."' WHERE `cart_users_email` = '".$user_email."'  AND  `cart_product_id` = '".$pid."' ");
                echo("Cart Updated");

            }else{

                echo("Invalid Quantity");

            }


        }else{

            Database::iud("INSERT INTO `cart` (`cart_qty` , `cart_product_id` , `cart_users_email`) VALUES ('1' , '".$pid."' , '".$user_email."')");
            echo("Product added to the cart");
        }

    }else{
        echo("something went wrong");
    }

}else{
    echo("Please login to your account");
}

?>