Vehicle Service Management System Using PHP and MySQL
Project Name : Vehicle Service Management System (VSMS)
Language Used : PHP
Database : MySQL
Web Browser : Mozilla, Google Chrome, IE8, OPERA
Software : XAMPP / Wamp / Mamp/ Lamp (anyone)
Vehicle Service Management System
In this project, we use PHP and Mysql database. It has two module 1.User Module 2.Admin Module.
2.Enquiry: In this section, user can fill the enquiry form and check his query is respond or not(which is done by admin).
3.Service Request: In this section, user can fill the service form, check his/her service status and what amount is taken for service and also print his/her amount slip(which is done by admin). User can also update his/ her profile, change the password and recover the password.
- Dashboard: In this section, admin can see all detail in brief like the total registered user, Total Enquiry, Total Mechanics and Total Services.
- Enquiry Search: In this section, admin can search enquiry with the help of customer phone number, email id or contact number.
- Service Search: In this section, admin can search for services with help of customer phone number, email id or contact number.
- Mechanics: In this section, admin can manage mechanics(add and update).
- Vehicle Category: In this section, admin can manage vehicle category(add and update)..
- Reg Users: In this section, admin can view user detail and update user detail.
- Service Request: In this section, admin can add service prices(service charge, parts charge additional(if any)). Admin can view services on the basis of status(pending services, rejected services and complete services). Admin also can approve pending policy
- Customer Query: In this section, admin can respond to the customer query and also view the customer responded query and none responded query.
Admin can also update his profile, change the password and recover the password. Note: In this project MD5 encryption method used.
Some Project Screenshots
User Sign up
User Service Request page
Service Details Page
How to run the Vehicle Service Management System (VSMS) Project
1. Download the zip file
2. Extract the file and copy vsms 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 name vsmsdb
6. Import vsmsdb.sql file(given inside the zip package in SQL file folder)
7.Run the script http://localhost/vsms (frontend) 8. For admin panel
http://localhost/vsms/admin (admin panel)
Credential for admin panel :
Username: admin Password: Test@123
Credential for user panel :
Username: email@example.com Password: Test@123
Project Download Link