PHP shopping cart example (1/5)_PHP tutorial

PHP Shopping Cart Example Here is another PHP shopping cart example code. This is a development example suitable for those who want to develop a shopping mall or shopping system. It tells you how to add products to shopping and delete them, and the database design of the shopping cart. Example.

php tutorial shopping cart example
Here is another php shopping cart example code. This is a development example suitable for those who want to develop a shopping mall or shopping system. It tells you how to add products to shopping and delete them. , database tutorial design example with shopping cart.
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 drive','5','1','80g','5600','1 ');
insert into inventory values ​​('cpu','12','2','p4-2.4g','6600','1');
insert into inventory values ​​('dvd- rom','7','3','12x','2000','1');
insert into inventory values ​​('motherboard','3','4','asus','5000 ','2');
insert into inventory values ​​('display card','6','5','64m','4500','1');
insert into inventory values ​​(' Burner','4','6','52w','3000','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)
);

shopper 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 drive','5','1','80g','5600' ,'1');
insert into inventory values ​​('cpu','12','2','p4-2.4g','6600','1');
insert into inventory values ​​( 'dvd-rom','7','3','12x','2000','1');
insert into inventory values ​​('motherboard','3','4','asus' ,'5000','2');
insert into inventory values ​​('display card','6','5','64m','4500','1');
insert into inventory values ​​('Burner','4','6','52w','3000','1');
*/

1 2 3 4 5