Support Ticket System using PHP and MySQL
“Support-Tickets Management System” software offers numerous benefits to system administrators. It acts as a web-based ticket system that manages inquiries, as well as other types of support processes. The software also ranks inquiries and classifies them all by priority.
This type of software can also help reduce the amount of training that’s needed for the support staff. As a result, support staff can become experts in a shorter amount of time. Such an advantage allows for a much speedier resolution of tickets.
Project Requirements
| Project Name | Support Ticket 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) |
Project Modules
In Support Ticket Management System project there are two module admin, user.
Admin:
- Dashboard: In this section, admin can briefly view total sub-admin, all tickets received, Total New Tickets, Total In-Process Tickets, Total On-Hold Tickets, Total Tickets Resolved, Total Category and Total Knowledge-Base.
- Sub-Admin: In this section, admin can manage sub-admins (add/delete/update).
- Category: In this section, admin can manage category (add/delete).
- Tickets: In this section, admin can manage tickets and resolved user’s queries.
- Reports: In this section, admin can view the and check tickets details in a particular period.
- Knowledge Base: In this section, admin can manage knowledge-base(Add/Update/Del)
- Profile: User can update his/her profile.
- Change Password: User can update/his/her account password.
User:
- User can raise the Ticket
- Check the Ticket History
- Users can Update the Ticket
- Can check the Knowledge Base
Some of the Project Screens
Home Page/Raise Ticket
Admin Login
Admin Dashboard
Tickets
Ticket Details
How to run the Support Ticket System Project using PHP and MySQL
1. Download the project zip file
2. Extract the file and copy supportts 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 sticketsdb
6. Import sticketsdb.sql file(given inside the zip package in SQL file folder)
7. Run the script http://localhost/supportts
Admin Login Details
Username: Admin
Password: Test@123
