# Support Ticket System using Laravel and MySQL

A dynamic [Support Ticket System](https://phpgurukul.com/support-ticket-system-using-laravel-and-mysql/) built with Laravel and MySQL that allows organisations to manage customer support requests efficiently. Users can submit tickets, track their status, and communicate with support agents, while admins can manage, assign, and resolve tickets seamlessly.

#### **Key Features:**

![✅](https://s.w.org/images/core/emoji/16.0.1/svg/2705.svg align="left")

**Admin Panel**

Manage categories (departments)

Create Sub-Admins and assign departments

View all tickets (new, in-progress, closed)

Generate reports (date-wise, status-wise, priority-wise)

![✅](https://s.w.org/images/core/emoji/16.0.1/svg/2705.svg align="left")

**Sub-Admin Panel**

Sub-admins can log in separately

Access only the tickets assigned to their department

Update ticket status & remarks

Ticket history is maintained automatically

Buy this project: [https://phpgurukul.com/support-ticket-system-using-laravel-and-mysql/](https://phpgurukul.com/support-ticket-system-using-laravel-and-mysql/)

![✅](https://s.w.org/images/core/emoji/16.0.1/svg/2705.svg align="left")

**User Panel**

Register & login securely

Create support tickets with category & priority

Track ticket status (New, In Progress, Closed)

Password recovery with email

#### **Technology Used:**

* **Backend:** Laravel (PHP Framework)
    
* **Database:** MySQL
    
* **Frontend:** Blade Templates, Bootstrap
    

#### **Installation Guide – Support Ticket System (Laravel Project)**

**Prerequisites**

Before starting, make sure you have the following installed:  
PHP ≥ 8.2  
Composer (latest version)  
MySQL / MariaDB  
Apache/Nginx Web Server

1. Download the zip file
    
2. Extract the file and copy `support_ticket_app` 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](http://localhost/phpmyadmin)) or run the command `php artisan migrate` (if you are using migration commad then skip step 5 and 6)
    
5. Create a database with the name `supportticketdb`
    
6. Import `supportticketdb.sql` file(given inside the zip package in SQL file folder)
    
7. Run this command: `php artisan serve`
    
8. Run the script [`http://127.0.0.1:8000/`](http://127.0.0.1:8000/)
    

\*\*\*\*\*\****Admin Login Details***\*\*\*\*\*\*  
Username: admin  
Password: Tes@123

Create a New Sub-admin or user.

PHP Gurukul Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Email: [info@phpgurukul.com](mailto:info@phpgurukul.com)

Website : [https://phpgurukul.com](https://phpgurukul.com)