Client Management System using PHP & MySQL

16

- Advertisement -

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 18 April 2021

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

View Demo———————————————

Full Source Code (Client Management System)
Size: 5.48 MB
Version: V 1.1

Client Management System Project Report


- Advertisement -

Leave A Reply

Your email address will not be published.

16 Comments
  1. GT Obadiah says

    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?

    1. Anuj Kumar says

      Share your URL at phpgurukulteam@gmail.com

  2. Jones says

    Very good work sir, however the invoice is just summing one row, which is the last row in the invoice.

    1. Anuj Kumar says

      The issue is fixed. Please latest updated code.

      1. Jones says

        Thanks a lot it works!!, but quantity of is also missing on the invoice, have you noticed?

  3. Gideon says

    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.

  4. Raymond says

    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.

    1. Anuj Kumar says

      create database clientmsdb then import clientmsdb.sql file

      1. Raymond says

        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.

        1. Anuj Kumar says

          can you share your error at phpgurukulteam@gmail.com

          1. Brigen Voci says

            i have the same problem. i uploaded in my website and shows me Access denied for user ‘root’@’localhost’ (using password: NO)

          2. Anuj Kumar says

            Check the database connection.

  5. azharskynet says

    unable to download

    1. admin says

      This issue is fixed now. You can download the project. If you still facing same issue let me know.

  6. bokungai says

    I love your work Sir it is really awesome… it has helped me a lot.

  7. Manoj kalla says

    Very good job

Leave A Reply

Your email address will not be published.