php/mysql 购物车程序
<?
if(!$session && !$scid) {
$session = md5(uniqid(rand()));
setcookie("scid", "$session", time() + 14400);
} /* last number is expiration time in seconds, 14400 sec = 4 hrs */
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);
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;
$count++;
}
$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;
}
}
?>
/*
this part contains a description of how to create the tables on your mysql server.
# mysql dump 6.0
#
# host: localhost database: kmartshopper
#--------------------------------------------------------
# server version 3.22.25
#
# table structure for table '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)
);
#
# table structure for table '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)
);
*/
example
<?
include("shoppingcart.php");
$cart = new cart;
$mysql_link = mysql_connect("localhost", "wwwrun", "");
$mysql_select_db("kmartshopper", $mysql_link) /* heh, use whatever database name you put the 2 tables under in place of kmartshopper */
?>
/* call functions like $cart->add_item and such, see the code. */
