Chuanzhi podcast Han Shunping php video tutorial notes zend. framework. 15th lecture. comprehensive application-shopping cart 1

Chuanzhi podcast Han Shunping php video tutorial notes experience zend. framework. lecture 2. integrated application-shopping cart 1zend. framework. lecture 2. comprehensive application-shopping cart 1 my shopping cart function module, requirement analysis. A. log on to System B & nbsp; browse the product. page c adds the product to the shopping cart and performs the curd operation on the shopping cart. D Chuanzhi podcast Han Shunping php video tutorial notes experience zend. framework. 15th lecture. comprehensive application-shopping cart 1
Zend. framework. 15th lecture. comprehensive application-shopping cart 1
My shopping cart function module, requirement analysis.
A. log on to System B to browse the product. page c adds the product to the shopping cart and performs the curd operation on the shopping cart. D. place an order. e. send an email to the recipient and use phpmail.
Interface
Design Database
-- Create table users (id int primary key, name varchar (64) not null default '', pwd char (32) not null default'', email varchar (128) not null default '', tel varchar (32) not null default'', grade tinyint unsigned not null default 1

)
Insert into users values (100, 'Andy Lau ', md5 (123456), 'aligoods @ qq . Com ', '000000', 1); insert into users values (1394343432, 'Zhang Xueyou', md5 (101), '2017 @ q Q.com ', '000000', 1 );


Md5 verification. the storage character is 32 characters. Fixed length, so char
-- Commodity table (commodity category table-Level 1, Level 2, and Level 3)
Create table book (id int primary key auto_increment, name varchar (64) not null default '', author varchar (64) not null default'', publishHouse varchar (128) not null default '', price float not null default 0, nums int not null default 10

) -- Shopping cart table
Create table mycart (id int primary key auto_increment, userid int, bookid int, nums int unsigned, carDate int unsigned, foreign key (userid) references users (id), foreign key (bookid) references book (id)

)
-- Order table (usually two tables, one is the master table and the other is the order details table)

Use a frame chart to design our website and related files and call relationships.