Customer Support System using PHP/MySQLi with Source Code

Language

Project: Customer Support System using PHP/MySQLi

About

The Customer Support System is a simple project that can help a certain business or company that provides customer support after their customer purchased a product from them. In this system, the customer and staff can communicate about the issue or instances that occurred in the purchased product. In this feature, the customer can create a ticket for any problems that occurred to their purchased product then the support staff under the department what did the customer or admin choose to fix the problem. The system has 3 types of users which are the admin, support staff, and the customer. Only admin users can create new access for the customer and support staff. Talking about the communication between the customer and the support staff, the system has a comment section in each ticket so the users can leave their comments on the specific ticket to communicate with each other.

Features

All Users

  • Login Page
    • The page where system users will submit their credentials to access the data and functionalities of the system.
  • Dashboard Page
    • The page where the system users will be redirected by default after logging into the customer support system.
  • New Ticket Page
    • The page where can system users create a new ticket. The admin or support staff has a custom field because this feature is based on customers encountered issues with the product.
  • Manage Ticket
    • This feature includes View, Edit, and Delete. The admin and support staff are permitted to update the status of the ticket.
  • Manage Account Modal
    • The popup modal where the system users update their system credentials such as their email and password.

Admin Side Only

  • Customer Page
    • The page where the admin can manage the list of customers.
  • Staff Page
    • The page where the admin can manage the list of staff.
  • Departments Page
    • The page where the admin can manage the list of departments.

The Customer Support System was developed using HTML, PHP/MySQLi, CSS, JavaScript (jQuery/Ajax), and Bootstrap for the design. The source code is fully functional and easy to modify or enhance. Follow the instruction below to have an actual experience using this simple project.

How to Run

  1. Download the source code and extract the zip file.
  2. Download or set up any local web server that runs PHP script.
  3. Open the web-server database and create a new database name it css_db.
  4. Import the SQL file located in the database folder of the source code.
  5. Copy and paste the source code to the location where your local web server accessing your local projects. Example for XAMPP('C:\xampp\htdocs')
  6. Open a web browser and browse the project. E.g [http://localhost/customer-support-system]

Default Admin Access

Email: admin
Password: admin123
Type: Admin

I hope this simple Customer Support System will help you with what you are looking for, feel free to download and modify the source code.

Explore more on this website for more source codes and tutorials.

Enjoy!

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

How to write send email code if the user submit a ticket?

not able to submit new ticket

UNABLE TO CREATE NEW TICKET

In reply to by ST3WQR (not verified)

Same here

In reply to by Happy Walia (not verified)

"PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: Field 'status' doesn't have a default value in /var/www/support/admin_class.php:220 Stack trace: #0 /var/www/support/admin_class.php(220): mysqli->query() #1 /var/www/support/ajax.php(62): Action->save_ticket() #2 {main} thrown in /var/www/support/admin_class.php on line 220" while reading response header from upstream, client: IP, server: ticket.net, request: "POST /ajax.php?action=save_ticket HTTP/2.0", upstream: "fastcgi://unix:/run/php-fpm/www.sock:", host: "ticket.net", referrer: "https://ticket.net/index.php?page=new_ticket"

Dear Oretnom, I would add a button for filter in "departmet_list.php"
.... And the script as below $('#new_department').click(function(){ uni_modal("New Department","manage_department.php") }) $('#filter').click(function(){ // I want to filter using button with id filter to fitler dapartment. I added a item filter value 0, 1 in SQL. }) Could you help me write some code in $('#filter').click(function(){...} to show departments with filter=1 (in SQL) Thanks alot.

I am not able to perform Delete action on "Customer, Staff, Department or Tickets" on Page 2 (Sr. no 11 onward). Although it does allow to view and View and Edit action on page 2 onward only Delete action is not working. What changes needed to enable this action?

I Am not able create new ticket, when I click on save it's popping up preload for too long. What to do

Add new comment