Skip to main content

Customer Relationship Management (CRM) System in PHP with Source Code

Language

This is a simple PHP Project entitled Customer Relationship Management (CRM) System. This system provides a certain company an online platform to manage interactions with their customers or potential customers. The system allows the customer/potential customers to request a quotation for the services they selected in the system. The system also has a ticketing feature which is mainly built to address the concerns of their customers. The customer can create their tickets for the issues they have encountered and the management can update the ticket status from pending to On-Going Process or Closed. The system also has a comment section feature in each ticket which the customer support and customer can leave a comment so they could discuss the status and more details about the feature.

The CRMS Project has 2 types of users which are the Admin and the Customers. The Admin users are in charge of managing the data needed in the system and manages the customer tickets. The Customers can register their system accounts using the Registration Modal in the Login Page.

Features:

Admin Side

  • Login/Logout
  • Manage Service Category
  • Manage Services
  • Create Ticket
  • Manage Ticket List
  • Update Ticket Status
  • Leave Comments in a Ticket
  • Manage Comments
  • View Quote Requests List
  • Delete Quote Requests

Customer Side

  • Login/Logout
  • Create Ticket
  • Manage Ticket List
  • Leave Comments in a Ticket
  • Manage Comments in a ticket
  • Request a Quote

The system was developed using ff technologies:

Backend

  • PHP v8.0.2
  • MySQLi OOP
  • MySQL Database

Frontend:

  • HTML5
  • CSS
  • Javascript

Plugins/Libraries:

  • Bootstrap
  • AdminLTE
  • JPaging
  • DataTables
  • jQuery (Ajax)
  • and more

Sample Images of some pages:

Quote Request Form

Create Ticket Form

Ticket List

Ticket View

How to Run

Requirements

  • Download and Install any local web server such as XAMPP/WAMP.
  • Download the provided source code zip file. (download button is located below)

Installation/Setup

  1. Open your XAMPP/WAMP's Control Panel and start the Apache and MySQL.
  2. Extract the downloaded source code zip file.
  3. If you are using XAMPP, copy the extracted source code folder and paste it into the XAMPP's "htdocs" directory. And If you are using WAMP, paste it into the "www" directory.
  4. Browse the PHPMyAdmin in a browser. i.e. http://localhost/phpmyadmin
  5. Create a new database naming crm_db.
  6. Import the provided SQL file. The file is known as crm_db.sql located inside the database folder.
  7. Browse the CRM System in a browser. i.e. http://localhost/crm and http://localhost/crm/admin for the admin side.

Admin Access Information

Username: admin
Password: admin123

DEMO

That's it! You can now explore the features and functionalities of this Customer Relationship Management System Project in PHP. The source code is free to download. Feel free to download and modify the source code the way you desire. This project is for educational purposes only.

I hope this project will help you with what you are looking for and you'll learn something useful for your future PHP Projects. Explore more on this website for more Free 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

Submitted byMARTYN (not verified)on Fri, 05/28/2021 - 13:51

I can't access this procedure ( http://localhost/crm/admin ) I follow step by step on your video
Submitted byDonald Diagou (not verified)on Fri, 06/04/2021 - 17:31

Hello, the CRM application has been very well built, but there is a concern is that of this logged in as an admin that is refused yet I enter the right password
Submitted bySumit Pandey (not verified)on Thu, 08/12/2021 - 20:32

Can I use this to manage my clients ?

Add new comment