Jewelry Shop Management System Using PHP and MySQL

A “Jewelry Shop Management Project in PHP” is a web-based application., The main goal of this project was to create a shopping cart, which allows customers to shop and purchase Jewelry products online. Moreover, the project is also designed in such a way it lets managers manage the products information. Customers can orders products, and they will be contacted to further process the orders.

In today’s busy world, people don’t have time for their personal needs. And the technology fasts that anyone can do by sitting in a room. If someone buys a new thing, he can buy it online with the help of the Internet.

Project Requirements
Project Name Jewelery Shop Management System Project in PHP
Language Used PHP5.6, PHP7.x
Database MySQL 5.x
User Interface Design HTML, AJAX,JQUERY,JAVASCRIPT
Web Browser Mozilla, Google Chrome, IE8, OPERA
Software XAMPP / Wamp / Mamp/ Lamp (anyone)
Last Updated 10 March 2024
JSMS Project Modules

The application is implemented in PHP and consists of two main components:

Admin Modules

This module provides administrator-related functionalities. The administrator manages the entire application and maintains the profiles of users and information on products.

Dashboard: In these sections, the admin can briefly view the total registered users, total products, status of orders, inquiry, and review.

Categories: In this section, the admin can manage categories of products (add/update/delete).

Sub-Categories: In this section, the admin can manage subcategories of products (add/update/delete).

Products: In this section, admin can manage the products (add/update/delete.

Pages: In this section, admin can manage the about us and contact us pages.

Orders: In this section, admin can view the jewelry order details and they have also the right to change order status according to current status.

Reviews: In this section, admin can view the reviews of products that are given by buyers and they have the right to approved the review or not.

Inquiry: In this section, admin can view the inquiry which is sent by users.

Reports: In this section admin can view order details, order counts, and sales reports according to dates.

Search Order: In this section, admin can search particular order with the help of the order number.

Reg Users: In this section, the admin can view registered users.

Subscriber: In this section, admin views subscriber mails.

Admin can also update his profile, change the password and recover the password.

User Module

1.Home: It is the welcome page for users who can view products.

2. Category: In this section, users can view products according to category.

3.Products: In this section, users can view the jewelry and order that jewelry after registering.

4.About Us: In this section, user can view about us of a jewelry shop.

5.Contact Us: In this section, user can view the contact us of a jewelry shop.

6.Cart: In this section, the user can add the jewelry which he/she want to order.

7.Wishlist: In this section, the user can add mobile to the wishlist.

8. My Profile: In this section, the user can view and change his/her profile.

9. My orders: In this section, users can view order history after login.

10. Setting: In this section, user can change his/her account password.

11. The user has also a facility to download his/her invoice and cancel orders if he/she wants to cancel.

Brief Information about the Homepage

On this page guest users (users who are not registered) can view the jewelry. Guest users can also sign up and the registered users can sign in. User can also track their order without login.

Project Output Screens

Home Page

JSMS Home Page

User Order Details

JSMS Order Details

Admin Dashboard

JSMS Admin Dashboard

Add Product

JSMS Add Product

How to run the Jewelry Management Project using PHP and MySQL

1. Download the project zip file

2. Extract the file and copy jsms folder

3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/Html)

4.Open PHPMyAdmin (http://localhost/phpmyadmin)

5. Create a database with the name jsmsdb

6. Import jsmsdb.sql file(given inside the zip package in SQL file folder)

7. Run the script http://localhost/jsms

Admin Credential
Username: admin
Password: Test@123

Credential for User panel :
Username: johdoe@gmail.com
Password: Test@123
Or Register a new user.