Your online toilet paper supplier!
We get to create an online discount store by utilizing what we learned in class. Nevermind those pesky new-ish technology like Boostrap or literally any Javascript library. I mean... who needs those!
. ├── 404.html ├── index.php ├── manifest.json ├── auth │ ├── reset.php │ ├── signin.php │ └── signup.php ├── calls │ ├── add_to_cart.php │ ├── complete_order.php │ ├── login.php │ ├── logout.php │ └── register.php ├── docs │ ├── erd_1.pdf │ ├── erd_2.pdf │ └── team_hua_dd.pdf ├── main │ ├── checkout.php │ ├── create.php │ └── profile.php ├── media │ ├── cart.png │ ├── favicon.png │ ├── hua_logo.png │ └── search.png ├── style │ └── custom.css └── utility └── util.php
Users | ||||||
---|---|---|---|---|---|---|
# | Name | Type | Attributes | Null | Default | Extra |
1 | id |
int |
false |
none |
auto increment | |
2 | username |
varchar(50) |
false |
none |
||
3 | password |
varchar(255) |
false |
none |
||
4 | email |
varchar(100) |
false |
none |
||
5 | varchar(100) |
false |
empty string | |||
6 | created_on |
timestamp |
false |
|||
7 | address_1 |
varchar(100) |
false |
none |
||
8 | address_2 |
varchar(100) |
false |
none |
||
9 | zip |
varchar(100) |
false |
none |
||
10 | city |
varchar(100) |
false |
none |
||
11 | state |
varchar(100) |
false |
none |
||
12 | card_name |
varchar(100) |
false |
none |
||
13 | card_number |
varchar(100) |
false |
none |
||
14 | card_exp |
date |
false |
none |
||
Products | ||||||
Name | Type | Attributes | Null | Default | Extra | |
id |
int |
false |
none |
auto increment | ||
name |
varchar(100) |
false |
none |
|||
description |
text |
false |
none |
|||
price |
float |
false |
none |
|||
stock |
int |
false |
none |
|||
updated_on |
timestamp |
triggers on update | false |
none |
||
created_on |
timestamp |
false |
none |