課程內容
LAMP Stack —- 基礎篇
LAMP Stack 是最傳統建置網站的堆疊方法,亦是初學編程者的起步,雖然網站的建置方法發展到今天已極多元化,但HTML、 CSS 和JavaScript ,還是學習編程不可跳過的部份。 本章會集中建構一個完整的學習框架,讓我們可依此進一步探討。
0/84
LAMP Stack —- Libraries 與 Frameworks
0/64
LAMP Stack —- Embedded with NUXT2
0/115
財DEE的趣味編程 —- LAMP Stack
關於課程
drop database if exists shop;
create database shop default character set utf8 collate utf8_general_ci;

create table product (
    id int auto_increment primary key,
    name varchar(200) not null,
    price int not null
);

create table customer (
    id int auto_increment primary key,
    name varchar(100) not null,
    address varchar(200) not null,
    login varchar(100) not null unique,
    password varchar(100) not null
);

create table purchase (
    id int not null primary key,
    customer_id int not null,
    foreign key(customer_id) references customer(id)
);

create table purchase_detail (
    purchase_id int not null,
    product_id int not null,
    count int not null,
    primary key(purchase_id, product_id),
    foreign key(purchase_id) references purchase(id),
    foreign key(product_id) references product(id)
);

create table favorite (
    customer_id int not null,
    product_id int not null,
    primary key(customer_id, product_id),
    foreign key(customer_id) references customer(id),
    foreign key(product_id) references product(id)
);

insert into product values(null, ‘松果’, 700);
insert into product values(null, ‘核桃’, 270);
insert into product values(null, ‘葵花子’, 210);
insert into product values(null, ‘杏仁’, 220);
insert into product values(null, ‘腰果’, 250);
insert into product values(null, ‘巨人玉米’, 180);
insert into product values(null, ‘開心果’, 310);
insert into product values(null, ‘夏威夷豆’, 600);
insert into product values(null, ‘南瓜子’, 180);
insert into product values(null, ‘花生’, 150);
insert into product values(null, ‘枸杞’, 400);

insert into customer values(null, ‘熊木 和夫’, ‘東京都新宿區西新宿2-8-1’, ‘kumaki’, ‘BearTree1’);
insert into customer values(null, ‘鳥居 健二’, ‘神奈川縣橫濱市中區日本大通1’, ‘torii’, ‘BirdStay2’);
insert into customer values(null, ‘鷺沼 美子’, ‘大阪府大阪市中央區大手前2’, ‘saginuma’, ‘EgretPond3’);
insert into customer values(null, ‘鷲尾 史郎’, ‘愛知縣名古屋市中區三之丸3-1-2’, ‘washio’, ‘EagleTail4’);
insert into customer values(null, ‘牛島 大悟’, ‘埼玉縣埼玉市浦和區高砂3-15-1’, ‘ushijima’, ‘CowIsland5’);
insert into customer values(null, ‘相馬 助六’, ‘千葉縣地足中央區市場町1-1’, ‘souma’, ‘PhaseHorse6’);
insert into customer values(null, ‘猿飛 菜菜子’, ‘兵庫縣神戶市中央區下山手通5-10-1’, ‘sarutobi’, ‘MonkeyFly7’);
insert into customer values(null, ‘犬山 陣八’, ‘北海道札幌市中央區北3西6’, ‘inuyama’, ‘DogMountain8’);
insert into customer values(null, ‘豬口 一休’, ‘福岡縣福岡市博多區東公園7-7’, ‘inokuchi’, ‘BoarMouse9’);