Gadget Store Management System in PHP MySQL

This Gadget Store Management System was developed using PHP/MySQL, Bootstrap, JavaScript.  It aims to help the retailer to manage the sales inventory of his gadget store business. This System contains an admin side where Admin can manage sales, products, categories, and gadget orders. The Admin plays an important role in the management of the system. All the main functions are performed from the Admin side.

The Admin has full control of the system. All the functions are to be performed from Admin panel. Here, the admin can manage gadget store orders easily. The system displays available gadgets and accessories that which name, photo, category, price appears on the frontend.

Add New Category. The category contains a CRUD (Create, Read, Update, Delete) function which allows the user to add, update, view and delete gadget store categories.  To add a category is simple.  The user should only provide a name for it.

In the “gadgetstoredb” database it appears like this:

Add, Update, Delete and View Products. The admin can also manage product items by categories. In the Products section, the user can also perform tasks like CRUD, which allows the user to add, update, delete and view product items.

Add New Product. In order to add product items, the user has to provide product name, select category, price and upload a photo.

In the “gadgetstoredb” database it is recorded like this:

Add Quantity and Customer’s Name. The user has to enter the quantity and customer’s name.

Sales Record. The gadget orders are listed in the SALES section. Here in the sales section, the admin can view the sales of gadget orders showing the order date, the customer’s name, and total amount.

In the “gadgetstoredb” database it appears like this:

Features:

1. Manage Gadget Categories
2. Manage Products
3. Gadget Product Orders
4. Sales Management

How to Run

To run this system you must have installed virtual server i.e XAMPP on your PC or laptop (for Windows).

After Starting Apache and MySQL in XAMPP, follow these 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 “gadgetstoredb” and then click on the import tab
7th Step: Click on browse file and select “gadgetstoredb.sql” file which is inside the “DATABASE” folder
8th Step: Click on Go.

After Creating Database,

9th Step: Open a browser and go to URL “http://localhost/gadgetsdb/”

Note: This project uses online Bootstrap so internet connection is needed for it to work

Download For Free. Gadget Store Management System in PHP with source code is free to download, Use for educational purposes only!