Client Management System using PHP & MySQL
| Project Name | Client Management System |
|---|---|
| Language Used | PHP5.6, PHP7.x |
| Database | MySQL 5.x |
| User Interface Design | HTML, AJAX,JQUERY,JAVASCRIPT |
| Web Browser | Mozilla, Google Chrome, IE8, OPERA |
| Software | XAMPP / Wamp / Mamp/ Lamp (anyone) |
| Last Updated | 20 March 2022 |
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
Why is the client details keep on popping an error message that the details are invalid
Reset the password.
I Uploaded it to my server: The Client and Admin Login GUI is working Fine But Can’t Login. It keeps error_msg (Invalid Details) at both the Admin and the Client login Interface each time i login.
The database connection is fine.
What could be the reason?
Share your URL at phpgurukulteam@gmail.com
Very good work sir, however the invoice is just summing one row, which is the last row in the invoice.
The issue is fixed. Please latest updated code.
Thanks a lot it works!!, but quantity of is also missing on the invoice, have you noticed?
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
i have the same problem. i uploaded in my website and shows me Access denied for user ‘root’@’localhost’ (using password: NO)
Check the database connection.
unable to download
This issue is fixed now. You can download the project. If you still facing same issue let me know.