一聚教程网:一个值得你收藏的教程网站

最新下载

热门教程

php购物车实例

时间:2010-08-16 编辑:简简单单 来源:一聚教程网

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

清空购物车";
 
 
 //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 "连接数据库失败
";
       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;
        }
    }

 

 
//增加到购物车

 

 代码如下 复制代码

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

热门栏目