Php shopping cart instance (1/5) _ PHP Tutorial

Source: Internet
Author: User
Php shopping cart instance (15 ). The php shopping cart instance provides a php shopping cart instance code, which is a development instance suitable for the development of the mall or shopping system reference, it tells you that if you add a commodity to the shopping php shopping cart instance, here we provide a php shopping cart instance code, which is a development instance suitable for the development of the mall or shopping system reference, it tells you to design an instance with the database of the shopping cart if you add the item to the shopping and delete it.

Php Tutorial shopping cart instance
Here we provide a php shopping cart instance code, which is a development instance suitable for the development of the mall or shopping system reference. it tells you that if you add products to the shopping mall and delete them, and shopping cart database tutorial design instance.
Inventory table

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 ('mainboard ', '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 ');

Shoping table

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)
);

Shoper table

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 ('mainboard ', '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 ');
*/

1 2 3 4 5

...

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.