Vehicle Service Management System Using PHP and MySQL
Vehicle Service Management System Introduction
Vehicle service Management System using PHP ias web Application
This system “Vehicle service management system (VSMS)” allows providing vehicle for service. If customer got any problem with his vehicle they are providing services.
Project Requirements
| Project Name | Vehicle Service Management System | |
|---|---|---|
| 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 | 18 May 2024 |
Vehicle Service Management System Modules
In this project, we use PHP and Mysql database. It has two module 1.User Module 2. Admin Module.
User Module:
1. Dashboard
2. Enquiry: In this section, user can fill the enquiry form and check his query is response or not(which is done by admin).
3.Service Request: In this section, the 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). Users can also update his/ her profile, change their password and recover their password.
Admin Module
- 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,delete, and update).
- Vehicle Category: In this section, admin can manage vehicle category(add,delete 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
Home Page
User Sign up
User Service Request page
Service Details Page
Admin Dashboard
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: testuser@test.com Password: Test@123
