这里又提供一款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 .$row_inventory->id. ; echo .$row_inventory->product. ; echo .$row_inventory->price. ; echo .$row_inventory->quantity. ; echo .$row_inventory->description. ; echo product.'>
; } echo
; echo
购物车中产品的数量∶.$cart->quant_items($table, $session); echo
清空购物车; //shoppingcart.php代码 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 ;
教程地址：
欢迎转载！但请带上文章地址^^