Jewelry Shop Management System Using PHP and MySQL
Jewelry Shop Management System in PHP Introduction
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 Name||Jewelery Shop Management System Project in PHP|
|Language Used||PHP5.6, PHP7.x|
|Web Browser||Mozilla, Google Chrome, IE8, OPERA|
|Software||XAMPP / Wamp / Mamp/ Lamp (anyone)|
|Last Updated||24 April 2023|
JSMS Project Modules
The application is implemented in PHP and consists of two main components:
- Admin and
- User side
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.
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
User Order Details
How to run the Jewelry Management Project using PHP and MySQL
1. Download the project zip file
2. Extract the file and copy
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.sql file(given inside the zip package in SQL file folder)
7. Run the script
Credential for User panel :
Or Register a new user.