/toko_sepatu_endeavor

This is a simple website to learn how to use database on a website. This is my first project using bootstrap, CSS, HTML, and PHP.

Primary LanguageJavaScript

Endeavor Shoes Store

  • Project Language : Indonesian
  • This is a simple website built by HTML, PHP, and MySql
  • This project is made for fulfill the Database Subject in Informatics Major at Institut Teknologi Indonesia

Introduction

Endeavor is a store for selling shoes product in Indonesia. It has the main page, login page, admin page, and cart page.
The development of this project is not completed yet. It contains the login process, product input, product checkout, but it doesn't has any verification system to check the payment.

ERD

There are 7 tables used in this simple website, user, user_bio, user_kode, data_pesan, stok, stok_desc, and stok_ukuran.

  • user

    • This table consist of username, code, and password. This table is linked to user_bio table.

  • user_bio

    • This table consist of full data of a person including the username, real name, email, address, city, zipcode, and also phone number. This table linked to user table.

  • user_kode

    • This table consist of only name and code.

  • data_pesan

    • This table consist of order id as the primary key, username, date, name, address, city, zipcode, product id, the number of item, size, and total price. This table linked to user table (to get the username and user biodata) and stock table (to get the information of the product)

  • stok

    • This table consist of product id, brand, type of prodyct, price, and image. It linked to stok_desc table and stok_ukuran table.

  • stok_desc

    • This table consist of product id, long description of the product, and short description of the product. Long description used to describe the product as complete as possible while short description used to get user attention to buy the product. This table linked to stok table.

  • stok_ukuran

    • This table consist of product id, size, and the number of product. Every product id have different size and different stock for every size. This table linked to stok table.


PAGES FOR USER

The Endeavor Shoes Store Website Screenshoot :

No. Pictures Description
1 homepage This is the homepage of the website. User can see the products and the price at the first time they enter the site. We chose brown and red for the color to fit the logo color.

At the top-right of the site we can see the login/register button. User that already put some shoes to the cart can login and processing their purchase.
2 product When new user click the product that they want to buy, they will come to product page. The product page will show the picture, name, description, price, shoes size option, how many product they want to buy, and an "buy it now" button.

When new user goes to this page, the word "Hello username" will not show up.
3 product If the user isn't login yet, they will go to login page. If they have an account, they can login by write their username and password. If they don't have any account, they have to click on 'register' button. The register page will show up.
4 product This is the register page. User have to fill all the field to make an account. After the account is made, login page will show up. New user have to login with their new account.
5 product After user login, the homepage will show their username at the top-center. Now they can put shoes into their cart and do the transaction.
6 product User have to select the product they want to buy, fill the product page, and add it to cart. This is the Cart Page. In this page, user will see all of the product that they want to buy.
7 product This is the buying form. After collecting all the product that they want to buy, they will have to do the product transaction. This is a very simple website, user only can checkout one product at a time. For future development, user can buy a lot of product at a time.
8 product This is the confirm page. It means that the transaction now is processed by the admin. In future development, I hope this page also give the information about what should user do to completing their transaction.

PAGES FOR ADMIN

No. Pictures Description
1 product This is the first page that will appear when admin login to the website. This is the admin product page.

at the left side, there is a navigator to ther order page and size stock page.
2 product This is the product edit page. In this page, admin can see all the product in the website. Admin can also edit the description, price, or anything about the product.
3 product This is the order page. In this page, admin can see the order and make the order as soon as possible.

In the future development, I hope this page could also see which product is paid, so the seller can process only the paid one and make an automatic delete if order is unpaid for several days.
4 product This is the product stock page. In this page, admin can see the stock for every size in every product.
5 product This is the edit stock page. Admin can update the product stock in this page. Everytime concument buy a product, the stock will be decrease. If the stock is zero, the size option will be unavailable. If all the size in a product is empty, the product will be dissapear from the homepage.