Database Systems

E-Commerce Storefront
  • Type of project: Web design/Database Design
  • Project date: February 2022 – May 2022

  • My Role
    • Solo Lead Programmer

  • Languages & Software
HTML PHP CSS cPanel SQL

Details - Project Prompt

Create a fictional E-Commerce store backed by a SQL database hosted on cPanel.

Required Features:

  • The website must have a secure login feature and store login details in the database.
  • The stores catalog must have 30 products with 5 types of descriptive fields. All products must be stored in the database.
  • There must be two types of users: Customers and Employees

Each user will have unique views.

Website Features

  • Security
    • SQL Injection Protection
    • Hashed Passwords
    • Unable to view webpages without logging in
  • Customer & Employee Accounts
  • General search across all products
  • Database is accurately updated after a purchase
  • Receipts are recorded after placing an order

Customer Features

  • Have a catalog to view store inventory
  • Be able to pick items from the catalog and place them into a cart
  • Be able to place an order
  • See order history

Employee Features

  • Be able to insert a new product into the database
  • Delete a record in the database from a webpage
  • Modify a record in the database from a webpage
  • Create other employee accounts