PHP/MySQL 購物車程序

if(!$session && !$scid) {
$session = md5(uniqid(rand()));
SetCookie("scid", "$session", time() 14400);
} /* 最后一個數(shù)字是以秒為單位的過期時間，14400 秒 = 4 小時 */

class Cart {
function check_item($table, $session, $product) {
$查詢=“SELECT * FROM $table WHERE session='$session' AND Product='$product'”;
$結(jié)果 = mysql_query($query);

if(!$result) {
return 0;
}

$numRows = mysql_num_rows($result);

if($numRows == 0) {
return 0;
} else {
$row = mysql_fetch_object($result);
返回 $row->數(shù)量；
}
}

function add_item($table, $session, $product, $quantity) {
$qty = $this->check_item($table, $session, $product ）；
if($qty == 0) {
$query = "INSERT INTO $table (會話、產(chǎn)品、數(shù)量) VALUES ";
$query .= "('$session', '$product', '$quantity') ";
mysql_query($query);
} else {
$數(shù)量 = $數(shù)量；
$query = "更新$table SET數(shù)量='$quantity' WHERE session='$session' AND ";
$query .= "product='$product' ";
mysql_query($query);
}
}

function delete_item($table, $session, $product) {
$query = "從 $table 刪除，其中 session='$session' AND 產(chǎn)品='$產(chǎn)品' ”;
mysql_query($query);
}

function modify_quantity($table, $session, $product, $quantity) {
$query = "更新 $table SET 數(shù)量='$quantity' WHERE session='$session' ”;
$query .= "AND Product='$product' ";
mysql_query($query);
}

function clear_cart($table, $session) {
$query = "從 $table WHERE session='$session' 中刪除";
mysql_query($query);
}

function cart_total($table, $session) {
$query = "SELECT * FROM $table WHERE session='$session' ";
$結(jié)果 = mysql_query($query);
if(mysql_num_rows($result) > 0) {
while($row = mysql_fetch_object($result)) {
$query = "從庫存中選擇價格，其中產(chǎn)品='$row->產(chǎn)品' ”;
$invResult = mysql_query($query);
$row_price = mysql_fetch_object($invResult);
$total = ($row_price->價格 * $row->數(shù)量);
}
}
返回 $total；
}

function display_contents($table, $session) {
$count = 0;
$query = "SELECT * FROM $table WHERE session='$session' ORDER BY id ";
$結(jié)果 = 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["數(shù)量"][$count] = $row->數(shù)量；
$contents["total"][$count] = ($row_inventory->價格 * $row->數(shù)量);
$contents["description"][$count] = $row_inventory->description;
$count ;
}
$total = $this->cart_total($table, $session);
$contents["final"] = $total;
返回$內(nèi)容；
}

function num_items($table, $session) {
$query = "SELECT * FROM $table WHERE session='$session' ";
$結(jié)果 = mysql_query($query);
$num_rows = mysql_num_rows($result);
返回 $num_rows;
}

function quant_items($table, $session) {
$quant = 0;
$query = "SELECT * FROM $table WHERE session='$session' ";
$結(jié)果 = mysql_query($query);
while($row = mysql_fetch_object($result)) {
$quant = $row->quantity;
}
返回 $quant;
}
}
?>

/*
這部分包含如何在 mysql 服務(wù)器上創(chuàng)建表的描述。

# MySQL 轉(zhuǎn)儲 6.0
#
# 主機：localhost 數(shù)據(jù)庫：kmartShopper
#------------------------ ----------------------------------
# 服務(wù)器版本 3.22.25

#
# 表“庫存”的表結(jié)構(gòu)
#
創(chuàng)建表 inventory (
產(chǎn)品 tinytext NOT NULL,
數(shù)量 tinytext NOT NULL,
id int(4) DEFAULT '0' NOT NULL auto_increment,
描述tinytext NOT NULL,
價格 float(10,2) DEFAULT '0.00' NOT NULL,
類別 char(1) DEFAULT ' NOT NULL,
KEY id (id) ,
PRIMARY KEY (id),
KEY 價格 (price)
);

#
# 表 'shopping' 的表結(jié)構(gòu)
#
CREATE TABLE shopping (
sessiontinytext NOT NULL,
產(chǎn)品tinytext NOT NULL,
數(shù)量tinytext NOT NULL,
卡tinytext NOT NULL,
id int(4) DEFAULT '0' NOT NULL auto_increment,
KEY id (id),
PRIMARY KEY (id)
);
*/

示例

include("shoppingcart.php");
$cart = 新購物車；
$mysql_link = mysql_connect("localhost", "wwwrun", "");
$mysql_select_db("kmartShopper", $mysql_link) /* 嘿，使用您將 2 個表放在下面的任何數(shù)據(jù)庫名稱來代替 kmartShopper */
?>
/* 調(diào)用 $cart-> 等函數(shù)add_item之類的，看代碼。 */