php购物车实例这里又提供一款php购物车实例代码，这是一款适合种位要开发商城或购物系统参考的开发实例了，告诉你如果增加商品到购物并删除，与购物车的数据库设计实例。

php教程购物车实例
这里又提供一款php购物车实例代码，这是一款适合种位要开发商城或购物系统参考的开发实例了，告诉你如果增加商品到购物并删除，与购物车的php教程设计实例。
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 (硬盘,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 (主板,3,4,asus,5000,2);
insert into inventory values (显示卡,6,5,64m,4500,1);
insert into inventory values (刻录机,4,6,52w,3000,1);

shoping表

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表

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 (硬盘,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 (主板,3,4,asus,5000,2);
insert into inventory values (显示卡,6,5,64m,4500,1);
insert into inventory values (刻录机,4,6,52w,3000,1);
*/

标签：none