php购物车实现代码
关于购物车,这个是在电子商务方面使用的比较多,用户选择好自己的商品需要保存起来,最后去收银台,这很像我们实际生活的超市,所以我现来写一个简单的php购物车实例代码,比较详细只要一步步,处理好就OK了.
购物车会用到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 ( '主板HdhCmsTest111cn.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 "查询失败<br>" ; exit ; } echo "以下产品可供订购∶" ; echo "<table border=0>" ; echo "<tr><td bgcolor=#aaccff>产品编号</td><td bgcolor=#aaccff>产品名称</td><td bgcolor=#aaccff>单价</td>" ; echo "<td bgcolor=#aaccff>剩余数量</td><td bgcolor=#aaccff>产品描述</td><td bgcolor=#aaccff>放入购物车</td></tr>" ; while ( $row_inventory = mysql_fetch_object( $invresult )) { echo "<tr><td bgcolor=#aaccff>" . $row_inventory ->id. "</td>" ; echo "<td bgcolor=#aaccff>" . $row_inventory ->product. "</td>" ; echo "<td bgcolor=#aaccff>" . $row_inventory ->price. "</td>" ; echo "<td bgcolor=#aaccff>" . $row_inventory ->quantity. "</td>" ; echo "<td bgcolor=#aaccff>" . $row_inventory ->description. "</td>" ; echo "<td bgcolor=#aaccff><a href='additem.php?product=" . $row_inventory ->product. "'><img border='0' src='cart.gif' width='81' height='17'></a></td></tr>" ; //开源代码phpfensi测试数据 } echo "</table>" ; echo "<br>购物车中产品的数量∶" . $cart ->quant_items( $table , $session ); echo "<br><br><a href='clearcart.php'><img border='0' src='car.gif'></a>清空购物车" ;additem.php代码,增加商品代码:
include ( "shoppingcart.php" ); $cart = new cart; $table = "shopping" ; echo "你的购物清单∶<br>" ; $cart ->add_item( $table , $session , $product , '1' ); $cart ->display_contents( $table , $session ); echo "<br>你的购物总金额∶" . $cart ->cart_total( $table , $session ); echo "<br><form action='main.php'>" ; echo "<input type=submit value='继续购物'>" ; echo "</form>" ; //clearcart.php删除商品，清除购物车代码 include ( "shoppingcart.php" ); $cart = new cart; $table = "shopping" ; $cart ->clear_cart( $table , $session ); echo "购物车中产品的数量∶" . $cart ->num_items( $table , $session ); echo "<form action='main.php'>" ; echo "<input type=submit value='继续购物'>" ; echo "</form>" ;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 "连接数据库失败<br>" ; exit ; } $mysql_select =mysql_select_db( "shopper" , $mysql_link ); if (!( $mysql_select )) { echo "打开数据库失败<br>" ; 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 "<table border=0>" ; echo "<tr><td bgcolor=#aaccff>产品编号</td><td bgcolor=#aaccff>产品名称</td><td bgcolor=#aaccff>单价</td>" ; echo "<td bgcolor=#aaccff>购买数量</td><td bgcolor=#aaccff>单项小计</td><td bgcolor=#aaccff>产品描述</td></tr>" ; 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 "<tr><td bgcolor=#aaccff>" . $row_inventory ->id. "</td>" ; echo "<td bgcolor=#aaccff>" . $row_inventory ->product. "</td>" ; echo "<td bgcolor=#aaccff>" . $row_inventory ->price. "</td>" ; echo "<td bgcolor=#aaccff>" . $row ->quantity. "</td>" ; echo "<td bgcolor=#aaccff>" . $contents [ "total" ][ $count ]. "</td>" ; echo "<td bgcolor=#aaccff>" . $row_inventory ->description. "</td></tr>" ; $count ++; } echo "</table>" ; $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 ; } }查看更多关于php购物车实现代码 - php高级应用的详细内容...
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://www.haodehen.cn/did30193