Overview: ======== Simple E-Commerce System: a web interface that implements a simple and secure e-commerce system using PHP and MySQL. Author: ====== Carmine Benedetto Website: http://www.carminebenedetto.net Email: carmine.benedetto[at]gmail.com Used Tools: ========== - Apache/2.2.22 (Ubuntu) - MySQL client version: 5.5.24 - PHP extension: mysqli - phpMyAdmin version: 3.4.10.1deb1 Application Structure: ===================== index.php --------- First page of the application. This page shows the store window with products, price and store availability. The user can Log In if he's already registered or Sign Up if he's not. Doing the Log In, the user will be redirected to the Store page. If a User Session is open, all the requests for the Index page will be redirected to the Store page. Dependencies: index.php -> Log In -> store.php index.php -> Sign Up -> register.html register.html ------------- User Registration From. Dependencies: register.html -> Register -> registration.php registration.php ---------------- This module gets the user paramters from the Registration Form, performs the appropriate checks and writes the user data in the database (user table). Dependencies: registration.php -> index.php store.php --------- In this page the user can choose the products he wants to buy. A lateral bar indicates the log status and the cart status. Dependencies: store.php -> Add Items to the Cart -> addcart.php store.php -> Show the Cart -> showcart.php addcart.php ----------- This module gets the cart parameters from the Add To Cart Form, performs the appropriate checks and write the cart data in the database (cart table). At the end of all the operation, the module redirects the user to the Store page. Dependencies: addcart.php -> store.php showcart.php ----------- This page shows the Cart with products, quantity and total amount of chosen products. The user can pay for the chosen products (putting the credit card parameters), empty the cart or go back to the store. Dependencies: showcart.php -> Checkout -> pay.php showcart.php -> Empty Cart -> emptycart.php showcart.php -> store.php emptycart.php ------------- This module deletes from the database the data from the cart table for the currently logged on user. At the end of all the operations, the module redirects the user to the Store page. Dependencies: emptycart.php -> store.php pay.php ------- This module gets the credit card parameters from the Payment Form, checks if the chosen products are still available on the store and than simulates a payment transation. The payment transation is performed using a random function. In case of successful transation, the module empties the cart. Dependencies: pay.php -> store.php LOGOUT ------ It's possible do the Log Out from different pages using the lateral bar. The Log Out operation redirects the user to the Index page. Pages: store.php showcart.pgp pay.php Database Tables: =============== - products - ------------------------------ | id | item | prize | number | ------------------------------ - id: product id; - item: product name; - prize: product price; - number: product availability. - users - -------------------------------------------------------------------- | name | surname | country | address | email | username | password | -------------------------------------------------------------------- - cart - ---------------------------- | sid | id_item | quantity | ---------------------------- - sid: $_SESSION['username'] (super global variable); - id_item : product id; - quantity: item quantity to buy. - sessions - ------------------------- | sid | sdata | sexpire | ------------------------- - sid: session id; - sdata: session data corresponding with $_SESSION['username']; - sexpire: session expiration time. NOTE ABOUT THE CART AND THE SESSION MANAGEMENT: ============================================== Adding items to the cart the database table product is not modified so the product availability remains unchanged until the successful payment. In the Session Garbage Collector, a cart connected to a session is deleted if the session expires or if it is destroyed. ATOMIC OPERATIONS / LOCKS: ========================= New User Registration File: registration.php Locked tables: users(WRITE) Add items to the cart File: addcart.php Locked tables: cart(WRITE) Empty the cart File: addcart.php Locked tables: cart(WRITE) Payment File: pay.php Locked tables: products(WRITE), cart(WRITE) Session Garbage Collector File: class_session.php Locked tables: cart(WRITE), sessions(WRITE)