Let’s Create Our Own
eCommerce Site
PV219, spring 2022
What Are You Going To Learn
• Template Design — Design a home page, products page, product page,
shopping cart page, and place order page with HTML5, CSS3 (SCSS) and
JavaScript, and learn how to implement the PHP templating system with
HTML
• GET and POST Requests — Create accessible HTML forms and data request
handling with PHP
• Prepared SQL Queries — How to prepare SQL queries to prevent SQL
injection
• Basic Validation — Validating form data that is sent to the server (client and
server validations)
• Session Management — Initialize sessions and store shopping cart products
Contents
• Getting Started
• Requirements (Local Web Server / Dev stack)
• File Structure & Setup
• Creating the Database and setting-up Tables
• Designing the Shopping Cart System with CSS
• Creating the Functions File
• Creating the Index File
• Connect to SQL Database
• Basic Routing
Mar 29
Apr 5
Contents
• Creating the Home Page
• Get 4 Products from Database
• Create Home Template
• Creating the Products Page
• Get Products from Database with Pagination
• Get the Total Number of Products
• Create Products Template
• Creating the Product Page
• Get Product from Database with GET Request
• Create Product Template
Apr 26
Apr 12
Contents
• Creating the Shopping Cart Page
• Adding a Product to Cart
• Removing a Product from Cart
• Updating Product Quantities
• Handling the Place Order
• Get Products in Cart and Select from Database
• Create Shopping Cart Template
• Creating the Place Order Page
• Create Place Order Template
May 17
May 10