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. */