nhcar
/
addcart.php

<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>

        <?php
        // put your code here
        echo "添加购物车的处理过程";
        $userId=$_COOKIE['nhuid'];
        $cpid=$_POST['cpid'];
        $cnum=$_POST['cnum'];
        //echo "<br>$userId $cpid $cnum";
        //1、连接数据库
        $link= mysqli_connect("localhost","root","");
        mysqli_select_db($link, "nhcar");
        mysqli_set_charset($link,"utf8");
        //2、操作数据表
        $sql1 ="SELECT * FROM cart WHERE cuid=$userId AND cpid=$cpid;";
        $result1=  mysqli_query($link, $sql1);
        $row1=  mysqli_fetch_assoc($result1);
        $result=false;//默认插入或更新失败
        if ($row1){
        //如果查询购物车有已购买的商品，那么就更新商品数量
            $sql2="UPDATE cart SET cnum=cnum+$cnum WHERE cuid=$userId AND cpid=$cpid;";
            echo "<br>$sql2<br>";
            $result=  mysqli_query($link, $sql2);
        }else{
            $sql="INSERT INTO cart(cuid,cpid,cnum) VALUE ($userId,$cpid,$cnum);";
            echo "<br>$sql2<br>";

            $result=  mysqli_query($link, $sql);

        }
        //3、处理结果数据
        if ($result) {
            echo "<script>alert('添加购物车成功！');location.href='cart.php'</script>";
        }  else {
            echo "<script>alert('添加购物车失败！');location.href='productlist.php'</script>";

        }
        ?>
    </body>
</html>