Online Shop is a web-based application intended to provide automated solutions and services to the customer. This project is written in PHP and MySQL. Consider a Business organization that has all of its business through INTERNET i.e., WEBSITES. The Business Organization has its offices in a few states and normally use the courier facility to deliver the product. If possible home delivery is also possible.
This Business Organization mainly has two sectors first one is sale which sale the product to the customer and second is service which is provided to the customer.
The technologies used in this project are:
- HTML: Page layout and design
- CSS: Design
- JS: Frontend
- PHP: Backend
- Bootstrap
- Java Script
Supported Operating Systems:
You can run this project in the following operating systems:
- Windows:
- MAC:
- Linux:
How To Run??
To run this project you must have installed a virtual server i.e XAMPP on your PC. Online Shop System in PHP with source code is free to download, Use for educational purposes only!
After Starting Apache and MySQL in XAMPP, follow the following steps
1st Step: Extract file
2nd Step: Copy the main project folder
3rd Step: Paste in xampp/htdocs/
Now Connecting Database
4th Step: Open a browser and go to URL “http://localhost/phpmyadmin/”
5th Step: Then, click on the databases tab
6th Step: Create a database naming “queries” and then click on the import tab
7th Step: Click on browse file and select “shop_user.sql” file which is inside the “queries” folder
8th Step: Click on go.
After Creating Database,
9th Step: Open a browser and go to URL “http://localhost/DBMS-ecommerce-master/”
sql file incomplete
CREATE TABLE subcategory ( subcat_id INT, cat_id INT, subcat_name VARCHAR(255) ); INSERT INTO subcategory (subcat_id, cat_id, subcat_name) VALUES (5, 1, ‘Laptops’), (6, 1, ‘Desktops’), (7, 1, ‘Audio Devices’), (8, 2, ‘Blocks and Building Toys’), (9, 2, ‘Bath Toys’), (10, 2, ‘Board Games’); UPDATE subcategory SET subcat_name = ‘Audio devices’ WHERE subcat_id = 7; CREATE TABLE product ( product_id INT, product_name VARCHAR(255), description TEXT, base_price DECIMAL(10, 2), cat_id INT, subcat_id INT ); INSERT INTO product (product_id, product_name, description, base_price, cat_id, subcat_id) VALUES (2, ‘Casio G-SHOCK’, ‘Waterproof watch made by Casio’, 13100.00, 1, 3), (3, ‘Nitro Car’, ‘Remote controlled car made by… Read more »
sql file incomplete
not found shop_user.sql
there are not the “queries” folder
ไม่มี sql
i would like to see more of online shopping projects so that i can choose