php - 未添加到数据库中的数据基本上是添加到购物车系统

Question

当我单击添加到购物车按钮时，会获取产品 ID，但是当我单击将数据存储到数据库中时，数据不会存储在数据库中。

Ajax 页面是main.js，PHP 页面是action.php。

<button pid='$pro_id' id='product' class='btn btn-danger'>Add to cart</button> 

$("body").delegate("#product","click",function(event){
    event.preventDefault();
    var p_id=$(this).attr('pid');
    $.ajex({
        url     : "action.php",
        method  : "POST",
        data    : {addToCart:1,proId:pid},
        success :function(data){
            alert(data);
        }
    })
})

if(isset($_POST["addToCart"])){
    $p_id=$_POST["proId"];
    $user_id=$_SESSION["uid"];
    $sql = "SELECT * FROM cart WHERE p_id = '$p_id' AND user_id = '$user_id'";
    $run_query = mysqli_query($db->_link,$sql);
    $count = mysqli_num_rows($run_query);
        if($count > 0)
        {
            echo " product already added ";
        }
        else {
            $sql =  "SELECT * FROM products WHERE product_id='$p_id'";
            $run_query = mysqli_query($db->_link,$sql);
            $row = mysqli_fetch_array($run_query);
                $id=$row["product_id"];
                $pro_name=$row["product_title"];
                $pro_image=$row["product_image"];
                $pro_price=$row["product_price"];
                $sql= "INSERT INTO cart(p_id, user_id, product_title,
                 product_image, qty, price, total_amt) 
                VALUES ('$p_id','$user_id','$pro_name','$pro_image','1','$pro_price','$pro_price')";
                if(mysqli_query($db->_link,$sql)){
                    echo " product added.. ";
            }
        }
    }

标签： phphtmlajax