php购物车实现代码

include("shoppingcart.php");
$cart = new cart;
$table="shopping";

/* 查询并显示所有存货表中的信息 */
    $query = "select * from inventory";
    $invresult = mysql教程_query($query);
    if (!($invresult)) {
       echo "查询失败
";
       exit;
    }
    echo "以下产品可供订购∶";
    echo "

产品编号	产品名称	单价	剩余数量	产品描述	放入购物车
".$row_inventory->id."	".$row_inventory->product."	".$row_inventory->price."	".$row_inventory->quantity."	".$row_inventory->description."

include("shoppingcart.php");
$cart = new cart;
$table="shopping";
echo "你的购物清单∶
";
$cart->add_item($table,$session,$product,'1');
$cart->display_contents($table, $session);
echo "
你的购物总金额∶".$cart->cart_total($table, $session);
echo "

//clearcart.php删除商品，清除购物车代码

include("shoppingcart.php");
$cart = new cart;
$table="shopping";
$cart->clear_cart($table, $session);
echo "购物车中产品的数量∶".$cart->num_items($table, $session);
echo "

// shoppingcart.php类
 
if (!$session && !$s) {
        $s = md5(uniqid(rand()));
        setcookie("session", "$s", time() + 14400);
    }

/* 检查是否有 seesion, 如果没有产生一个 md5 的唯一 id, 并利用 cookie 存入 $s 中。
并且设置其存在时间为 14400 sec 也就是 4 小时 */

    $mysql_link = mysql_connect("127.0.0.1", "root", "test");
    if (!($mysql_link)) {
       echo "连接数据库失败
";
       exit;
    }
    $mysql_select=mysql_select_db("shopper", $mysql_link);
    if (!($mysql_select)) {
       echo "打开数据库失败
";
       exit;
    } 

/* 购物车 class */
   
    class cart {
        function check_item($table, $session, $product) {
            $query = "select * from $table where session='$session' and product='$product' ";
            $result = mysql_query($query);
            
            if(!$result) {
                return 0;
            }
            $numrows = mysql_num_rows($result);
            if($numrows == 0) {
                return 0;
            } else {
                $row = mysql_fetch_object($result);
                return $row->quantity;
            }
        }

        function add_item($table, $session, $product, $quantity) {
            $qty = $this->check_item($table, $session, $product);
            if($qty == 0) {
                $query = "insert into $table (session, product, quantity) values ";
                $query .= "('$session', '$product', '$quantity') ";
                mysql_query($query);
            } else {
                $quantity += $qty;
                $query = "update $table set quantity='$quantity' where session='$session' and ";
                $query .= "product='$product' ";
                mysql_query($query);
            }
        }
        
        function delete_item($table, $session, $product) {
            $query = "delete from $table where session='$session' and product='$product' ";
            mysql_query($query);
        }
        
        function modify_quantity($table, $session, $product, $quantity) {
            $query = "update $table set quantity='$quantity' where session='$session' ";
            $query .= "and product='$product' ";
            mysql_query($query);
        }
        
        function clear_cart($table, $session) {
            $query = "delete from $table where session='$session' ";
            mysql_query($query);
        }
        
        function cart_total($table, $session) {
            $query = "select * from $table where session='$session' ";
            $result = mysql_query($query);
            if(mysql_num_rows($result) > 0) {
                while($row = mysql_fetch_object($result)) {
                    $query = "select price from inventory where product='$row->product' ";
                    $invresult = mysql_query($query);
                    $row_price = mysql_fetch_object($invresult);
                    $total += ($row_price->price * $row->quantity);
                }
            }
            return $total;
        }
        
        function display_contents($table, $session) {
            $count = 0;
            $query = "select * from $table where session='$session' order by id ";
            $result = mysql_query($query);
            echo "

                $count++;
            }
    echo "