Clinic Management System

Posted By phpprojectz on August 28, 2017

Objective of Clinic Management System

Clinic Management System is a web based application which has been developed over PHP and MySQL and runs on WAMP, XAMP or Apache2 server.. The main modules of the project is Clinic,Patient,Nurses,Appointments,Medicines. Admin user can manage all the operations of Appointments,Medicines,Clinic,Doctors,Patient and their details. Admin can create different type of reports of Clinic,Patient,Nurses,Appointments,Medicines according to their choise and filters. You can Download PHP and MySQL Project Clinic Management System with source code and database from this site. We also provide Project Report of Clinic Management System.

Functionalities and their descriptions of Clinic Management System are as follows:

  • You can search records on various criterias. Such as Clinic, Nurses, Appointments, Medicines
  • Create, read, update and delete (CRUD) application has been implemented on Clinic,Patient,Nurses,Appointments,Medicines
  • Keep the track logs of Patient, Doctors, Appointments ect
  • Advance search has been implemented on Patient,Doctors, Appointments
  • You can see all the details of the Clinic, Nurses, Doctors, Appointments
  • All the modules Doctors, Appointments, Patient,Medicines, Clinic are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Appointments.
  • All the Patient,Doctors, Appointments modules has their unique record ID for fast transactions and searching
  • Editing, adding and updating of Records is improved which results in proper resource management of Clinic data.

Modules of Clinic Management System and their descriptions:

  • Clinic Module : Manage all the operations of Clinic
  • Patient Module : Manage all the operations of Patient
  • Doctors Module : Manage all the operations of Doctors
  • Nurses Module : Manage all the operations of Nurses
  • Appointments Module : Manage all the operations of Appointments
  • Medicines Module : Manage all the operations of Medicines

Classes and their methods of Clinic Management System:

  • Clinic Methods : addClinic(), editClinic(), deleteClinic(), updateClinic(), saveClinic(), searchClinic()
  • Patient Methods : addPatient(), editPatient(), deletePatient(), updatePatient(), savePatient(), searchPatient()
  • Doctors Methods : addDoctors(), editDoctors(), deleteDoctors(), updateDoctors(), saveDoctors(), searchDoctors()
  • Nurses Methods : addNurses(), editNurses(), deleteNurses(), updateNurses(), saveNurses(), searchNurses()
  • Appointments Methods : addAppointments(), editAppointments(), deleteAppointments(), updateAppointments(), saveAppointments(), searchAppointments()
  • Medicines Methods : addMedicines(), editMedicines(), deleteMedicines(), updateMedicines(), saveMedicines(), searchMedicines()

Database tables and attributes of the Clinic Management System:

  • Clinic Entity : Attributes of Clinic are clinic_id, clinic_doctor_id, clinic_name, clinic_place, clinic_type, clinic_description, clinic_address
  • Patient Entity : Attributes of Patient are patient_id, patient_name, patient_mobile, patient_email, patient_username, patient_password, patient_address,
  • Doctors Entity : Attributes of Doctors are doctor_id, doctor_name, doctor_specialist, doctor_mobile, doctor_email, doctor_username, doctor_password, doctor_address
  • Nurses Entity : Attributes of Nurses are nurse_id, nurse_name, nurse_duty_hour, nurse_mobile, nurse_email, nurse_username, nurse_password, nurse_address,
  • Appointments Entity : Attributes of Appointments are appointment_id, appointment_doctor_id, appointment_number, appointment_type, appointment_date, appointment_description
  • Medicines Entity : Attributes of Medicines are medicine_id, medicine_name, medicine_company, medicine_composition, medicine_cost, medicine_type, medicine_dose, medicine_description

Database definition of Clinic Management System:

  • The details of Clinic is store into the Clinic tables respective with all tables
  • Each entity (Medicines, Doctors, Appointments, Patient, Clinic) contains primary key and unique keys.
  • The entity Doctors, Appointments has binded with Clinic, Patient entities with foreign key
  • There is one-to-one and one-to-many relationships available between Appointments, Nurses, Medicines, Clinic
  • All the entities Clinic, Appointments, Doctors, Medicines are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Clinic Management System tables for fast query execution.

Super admin functionality of Clinic Management System:

  • Admin can add, edit, delete and view the records of Clinic, Appointments, Doctors, Medicines
  • Admin can manage all the details of Patient, Doctors, Nurses, Appointments
  • Admin can also generate reports of Clinic, Patient, Doctors, Nurses
  • Admin can search the details of Clinic, Appointments, Doctors, Medicines
  • Admin can apply different level of filters on report of Clinic, Doctors, Medicines
  • Admin can tracks the detailed information of Appointments, Medicines, Clinic, Patient

Report of Clinic Management System:

  • Generates the report on Doctors,Nurses,Clinic,Patient,Appointments,Medicines,
  • Nurses,Appointments,Medicines has been integrated with the dynamic filter. So you can filter the records run time
  • You can also import the report data into PDF of Nurses,Appointments,Medicines
  • Excel Sheet report has also been integrated for Patient,Nurses,Medicines
  • You can create the CSV reports for Clinic,Appointments,Doctors

Limitation of Clinic Management System

  • Run time report generation is not available in Clinic Management System.
  • We have not implemented the dynamic report for Clinic,Nurses,Appointments,Patient,Doctors,Medicines
  • This project Clinic Management System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Clinic, Nurses, Medicines cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Clinic Management System

  • We have added all the validations for input value on the modules Clinic,Patient,Doctors
  • Nurses,Appointments,Medicines can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Clinic,Doctors,Medicines
  • CSRF token has also been implemented on Nurses,Patient,Clinic, Appointments,Medicines
  • All the Clinic,Nurses,Appointments,Patient,Doctors,Medicines has integrated with captcha for spam protections
  • Access level validation has been implemented on Medicines,Appointments,Nurses
  • Number and character validation has also been implemented on Doctors,Appointments,Clinic

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database