Php shopping cart implementation code (1/2)

Some shopping cart will use PHP files
Main. php display product
Additem. php add items to the shopping cart
Cearcart. php delete the item in the shopping cart
Shoppingcart. php operation class
 
User database tutorials include:

The code is as follows:

Copy code

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) ); Insert into inventory values ('Hard disk ', '5', '1', '80 GB', '123', '1 '); Insert into inventory values ('CPU ', '12', '2', 'p4-2.4g', '123', '1 '); Insert into inventory values ('DVD-rom ', '7', '3', '12x', '123', '1 '); Insert into inventory values ('motherboard www.111cn.net ', '3', '4', 'ASUS', '123', '2 '); Insert into inventory values ('dashboard ', '6', '5', '64m', '123', '1 '); Insert into inventory values ('recorders ', '4', '6', '52w', '123', '1 ');   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) ); Shopper   Create database shopper; Use shopper; 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) ); 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) ); Insert into inventory values ('Hard disk ', '5', '1', '80 GB', '123', '1 '); Insert into inventory values ('CPU ', '12', '2', 'p4-2.4g', '123', '1 '); Insert into inventory values ('DVD-rom ', '7', '3', '12x', '123', '1 '); Insert into inventory values ('motherboard 111cn.net ', '3', '4', 'ASUS', '123', '2 '); Insert into inventory values ('dashboard ', '6', '5', '64m', '123', '1 '); Insert into inventory values ('recorders ', '4', '6', '52w', '123', '1 ');

*/

// Main. php displays all items in the shopping cart

The code is as follows:

Copy code

Include ("shoppingcart. php "); $ Cart = new cart; $ Table = "shopping "; /* Query and display information in all inventory Tables */ $ Query = "select * from inventory "; $ Invresult = mysql tutorial _ query ($ query ); If (! ($ Invresult )){ Echo "query failed <br> "; Exit;     } Echo "the following products are available for subscription "; Echo "<table border = 0> "; Echo "<tr> <td bgcolor = # aaccff> Product No. </td> <td bgcolor = # aaccff> Product name </td> <td bgcolor = # aaccff> unit price </td> "; Echo "<td bgcolor = # aaccff> remaining quantity </td> <td bgcolor = # aaccff> Product description </td> <td bgcolor = # aaccff> in the shopping cart </td> </tr> "; While ($ row_inventory = mysql_fetch_object ($ invresult )){ Echo "<tr> <td bgcolor = # aaccff>". $ row_inventory-> id. "</td> "; Echo "<td bgcolor = # aaccff>". $ row_inventory-> product. "</td> "; Echo "<td bgcolor = # aaccff>". $ row_inventory-> price. "</td> "; Echo "<td bgcolor = # aaccff>". $ row_inventory-> quantity. "</td> "; Echo "<td bgcolor = # aaccff>". $ row_inventory-> description. "</td> "; Echo "<td bgcolor = # aaccff> <a href = 'additem. php? Product = ". $ row_inventory-> product. "'> </a> </td> </tr> ";     } Echo "</table> "; Echo "<br> quantity of products in the shopping cart:". $ cart-> quant_items ($ table, $ session ); Echo "<br> <a href = 'clearcart. Php'> </a> clear the shopping cart ";

 

Homepage 1 2 Last page