php程序应用实例,PHP教程.应用实例1_php
发布时间：2022-10-20 11:10:37 所属栏目：PHP教程 来源：
导读： php/mysql 购物车程序
if(!$session && !$scid) {
$session = md5(uniqid(rand()));
SetCookie("scid", "$session", time() + 14400);
} /* last number is expiration time in
if(!$session && !$scid) {
$session = md5(uniqid(rand()));
SetCookie("scid", "$session", time() + 14400);
} /* last number is expiration time in
|
php/mysql 购物车程序 if(!$session && !$scid) { $session = md5(uniqid(rand())); SetCookie("scid", "$session", time() + 14400); } /* last number is expiration time in seconds, 14400 sec = 4 hrs */ 教程.应用实例1_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' "; php网站架设实例教程_php实例教程_php基础教程 实例 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)) { php基础教程 实例_php网站架设实例教程_php实例教程 $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. */ （编辑：天瑞地安资讯网_保定站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐