PHP-Based Open-Source Basic Customer Relationship Management (CRM) System

Download code – PHP-Based Open-Source Basic Customer Relationship Management (CRM) System

PHP-Based Simple Customer Relationship Management (CRM) System

Project Overview

The Simple Customer Relationship Management (CRM) System is a web-based application developed using PHP and MySQL Database. It provides businesses with an online platform where customers can request quotations and submit tickets. The system has a user-friendly interface built with the Bootstrap Framework and offers easy-to-use features and functionalities.

System Users

The system has two types of users:

  1. Administrator – Manages the system and handles customer requests.
  2. Customer – Submits quotation requests and issues tickets.

Administrator Role

  • Accesses the admin panel after logging in with valid credentials.
  • Manages customer quotation requests and tickets.
  • Views and manages registered customer accounts.
  • Monitors user access logs.

Customer Role

  • Must sign up and log in to access the system.
  • Can submit and track quotation requests and tickets.
  • Can update personal profile information.

Features and Functionalities

Administrator Panel

  • Login and Logout
  • Dashboard with summary data and visitor graph
  • Manage Tickets (View, update, and delete)
  • Manage Customers’ Quotation Requests
  • View and Manage Registered Users
  • Monitor Users’ Access Logs
  • Update or Change Password

Customer Panel

  • Login and Registration
  • Dashboard
  • Submit Quotation Requests
  • Create and View Tickets
  • View and Update Profile
  • Change Password

Technologies Used

The system is built using the following technologies:

  • HTML
  • CSS
  • PHP
  • MySQL Database
  • Bootstrap Framework
  • JavaScript & jQuery Library
  • DataTables

How to Install and Run the System

Requirements

  • Install a local web server like XAMPP.
  • Download the source code zip file.

Installation Steps

  1. Start XAMPP and run Apache and MySQL.
  2. Extract the downloaded zip file.
  3. Copy the extracted folder to the “htdocs” directory in XAMPP.
  4. Open phpMyAdmin in a browser (http://localhost/phpmyadmin).
  5. Create a new database named scrm_db.
  6. Import the SQL file located inside the database folder (scrm_db.sql).
  7. Open the system in a browser (http://localhost/php-scrm/).

Admin Login Credentials

  • Username: admin
  • Password: admin123

Conclusion

This Simple CRM System is a helpful tool for businesses to manage customer requests and tickets efficiently. It is free to download and can be modified to fit specific needs.

index PHP

login PHP

scrm_db SQL

 

 

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top