php购物车实例

这里又提供一款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 ('主板','3','4','asus','5000','2'); 
insert into inventory values ('显示卡','6','5','64m','4500','1'); 
insert into inventory values ('刻录机','4','6','52w','3000','1'); 
shoping表
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)  
); 
shoper表
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 ('主板','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购物页面,代码如下:

/*mysql --user=root --password=your_password */

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 ""; } echo "

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

"; echo "
购物车中产品的数量∶".$cart->quant_items($table, $session); 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; } $count++; } echo ""; $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; } } //增加到购物车 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 "

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

"; echo ""; echo "

";

教程地址：

欢迎转载！但请带上文章地址^^