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);
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; }
/* 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. */
