php購物車實現代碼(1/2)

些購物車會用到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 "查詢失敗<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>";     }     echo "</table>";     echo "<br>購物車中產品的數量∶".$cart->quant_items($table, $session);     echo "<br><br><a href='clearcart.php'><img border='0' src='car.gif'></a>清空購物車";

 

首頁 1 2 末頁