php简单购物车实例,php购物车实例

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;

}