Client Management System using PHP & MySQL
Project Name : Client Management System Project (CMS)
Language Used : PHP
Database : MySQL
User Interface Design : HTML, AJAX,JQUERY,JAVASCRIPT
Web Browser : Mozilla, Google Chrome, IE8, OPERA
Software : XAMPP / Wamp / Mamp/ Lamp (anyone)
In Client Management System Project we use PHP and MySQL Database. This project keeps the records of clients. Client Management System has two modules ie. Admin and client.
Admin Module
1. Dashboard: In this section, admin can briefly view the total services, total clients, total today’s sales, total yesterday’s sales, last seven day’s sales, and total sales.
2. Services: In this section, admin can manage services (Add/Update).
3. Add Clients: In this section, admin can add new clients
4. Clients List: In this section, admin can update the client details and add services that are provided by the admin.
5. Invoices: In this section, admin can view the invoices of the client and also take print of the invoice.
6. Reports: In this section, admin can view the client’s details and check the sales reports(month-wise/year wise) in a particular period.
7. Search Invoice: In this section, admin can search for clients’ invoices with the help of his/her invoice number.
Admin can also update his profile, change the password and recover the password.
Client Module
1. Dashboard: It is a welcome page for a client.
2. Invoices: In this section, client can view the invoices of the client and also take print of the invoice.
3. Search Invoice: In this section, client can search his/her invoice with the help of the invoice number.
The client can also update his/her profile, change the password and recover the password.
Some Project Screenshots
Home Page
Admin Login
Manage Clients Page
How to run the Client Management System (CMS) Project
1.Download the zip file
2.Extract the file and copy clientms 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 name clientmsdb
6.Import clientmsdb.sql file (given inside the zip package in SQL file folder)
7.Run the script http://localhost/clientms (frontend)
Credential for admin panel :
Username: admin
Password: Test@123
Credential for Client panel :
Username: phpgurukulofficial@gmail.com
Password: Test@123
Hello Sir, thanks for the tutorial but please I’m trying to build a specific client management system for a rehab, with personal info, drug test results, expense and file uploads (prescription, assessment forms), for the personal info i also want to include client picture i’m kinda stuck.
When I click on Admin or Clint i get
Error: SQLSTATE[HY000] [1049] Unknown database ‘clientmsdb’
I followed the above instructions. I even deleted everything and started from scratch.
create database clientmsdb then import clientmsdb.sql file
I did that. I am using Wamp and followed all instructions per the read me file. I even deleted everything and started over. Same results. I am running PHP 7.3.
can you share your error at phpgurukulteam@gmail.com
unable to download
This issue is fixed now. You can download the project. If you still facing same issue let me know.
I love your work Sir it is really awesome… it has helped me a lot.
Very good job