PHP/MySQL 购物车,源代码如下：
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/* call functions like $cart->add_item and such, see the code. */