php购物车实现代码

购物车会用到php文件:

main.php 显示商品

additem.php把商品加入购物车

cearcart.php删除购物车中的商品

shoppingcart.php 操作类

用户的数据库代码如下:

inventory 
  create table inventory (  
    product tinytext not null,  
    quantity tinytext not null,  
    id int(4) default '0' not null auto_increment,  
    description tinytext not null,  
    price float(10,2) default '0.00' not null,  
    category char(1) default '' not null,  
    key id (id),  
    primary key (id),  
    key price (price)  
); 
insert into inventory values ('硬盘','5','1','80g','5600','1'); 
insert into inventory values ('cpu','12','2','p4-2.4g','6600','1'); 
insert into inventory values ('dvd-rom','7','3','12x','2000','1'); 
insert into inventory values ('主板www.111cn.net','3','4','asus','5000','2'); 
insert into inventory values ('显示卡','6','5','64m','4500','1'); 
insert into inventory values ('刻录机','4','6','52w','3000','1'); 
shopping 
create table shopping (  
session tinytext not null,  
product tinytext not null,  
quantity tinytext not null,  
card tinytext not null,  
id int(4) default '0' not null auto_increment,  
key id (id),  
primary key (id)  
);  
shopper 
create database shopper; 
use shopper; 
create table shopping (  
session tinytext not null,  
product tinytext not null,  
quantity tinytext not null,  
card tinytext not null,  
id int(4) default '0' not null auto_increment,  
key id (id),  
primary key (id)  
);  
create table inventory (  
product tinytext not null,  
quantity tinytext not null,  
id int(4) default '0' not null auto_increment,  
description tinytext not null,  
price float(10,2) default '0.00' not null,  
category char(1) default '' not null,  
key id (id),  
primary key (id),  
key price (price)  
); 
insert into inventory values ('硬盘','5','1','80g','5600','1'); 
insert into inventory values ('cpu','12','2','p4-2.4g','6600','1'); 
insert into inventory values ('dvd-rom','7','3','12x','2000','1'); 
insert into inventory values ('主板111cn.net','3','4','asus','5000','2'); 
insert into inventory values ('显示卡','6','5','64m','4500','1'); 
insert into inventory values ('刻录机','4','6','52w','3000','1');

main.php 显示购物车所有商品,代码如下:

include("shoppingcart.php");  
$cart = new cart; 
$table="shopping"; 
/* 查询并显示所有存货表中的信息 */ 
$query = "select * from inventory"; 
$invresult = mysql教程_query($query);  
if (!($invresult)) {  
   echo "查询失败
"; 
   exit; 
}  
echo "以下产品可供订购∶"; 
echo ""; 
echo ""; 
echo ""; 
while($row_inventory = mysql_fetch_object($invresult)) { 
echo "";  
echo "";  
echo "";  
echo "";  
echo ""; 
echo ""; //开源代码phprm.com 
} 
echo "
产品编号
产品名称
单价
剩余数量
产品描述
放入购物车
".$row_inventory->id."
".$row_inventory->product."
".$row_inventory->price."
".$row_inventory->quantity."
".$row_inventory->description."
product."'>
"; 
echo "
购物车中产品的数量∶".$cart->quant_items($table, $session); 
echo "

清空购物车"; 
additem.php代码,增加商品代码:
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 "
"; 
echo ""; 
echo "
"; 
//clearcart.php删除商品，清除购物车代码 
include("shoppingcart.php"); 
$cart = new cart; 
$table="shopping"; 
$cart->clear_cart($table, $session); 
echo "购物车中产品的数量∶".$cart->num_items($table, $session); 
echo "
"; 
echo ""; 
echo "
"; 
shoppingcart.php类,代码如下:
"; 
   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 ""; 
        echo ""; 
        echo ""; 
        while($row = mysql_fetch_object($result)) {  
            $query = "select * from inventory where product='$row->product' ";  
            $result_inv = mysql_query($query);  
            $row_inventory = mysql_fetch_object($result_inv);  
            $contents["product"][$count] = $row_inventory->product;  
            $contents["price"][$count] = $row_inventory->price;  
            $contents["quantity"][$count] = $row->quantity;  
            $contents["total"][$count] = ($row_inventory->price * $row->quantity);  
            $contents["description"][$count] = $row_inventory->description; 
           
            echo "";  
            echo "";  
            echo "";  
            echo "";  
            echo "";  
            echo ""; 
            $count++;  
        }  
echo "
产品编号
产品名称
单价
购买数量
单项小计
产品描述
".$row_inventory->id."
".$row_inventory->product."
".$row_inventory->price."
".$row->quantity."
".$contents["total"][$count]."
".$row_inventory->description."
"; 
        $total = $this->cart_total($table, $session);  
        $contents["final"] = $total;  
        return $contents;  
    }  
      
    function num_items($table, $session) {  
        $query = "select * from $table where session='$session' ";  
        $result = mysql_query($query);  
        $num_rows = mysql_num_rows($result);  
        return $num_rows;  
    }  
      
    function quant_items($table, $session) {  
        $quant = 0;  
        $query = "select * from $table where session='$session' ";  
        $result = mysql_query($query);  
        while($row = mysql_fetch_object($result)) {  
            $quant += $row->quantity;  
        }  
        return $quant;  
    }
}

文章链接：

随便收藏，请保留本文地址！