Patient Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Patient Management System

Patient 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 Patient,Doctor,Diease,Test,Medicine. Admin user can manage all the operations of Test,Medicine,Patient,Doctor Schedule,Doctor and their details. Admin can create different type of reports of Patient,Doctor,Diease,Test,Medicine according to their choise and filters. You can Download PHP and MySQL Project Patient Management System with source code and database from this site. We also provide Project Report of Patient Management System.

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

  • You can search records on various criterias. Such as Patient, Diease, Test, Medicine
  • Create, read, update and delete (CRUD) application has been implemented on Patient,Doctor,Diease,Test,Medicine
  • Keep the track logs of Doctor, Doctor Schedule, Test ect
  • Advance search has been implemented on Doctor,Doctor Schedule, Test
  • You can see all the details of the Patient, Diease, Doctor Schedule, Test
  • All the modules Doctor Schedule, Test, Doctor,Medicine, Patient are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Test.
  • All the Doctor,Doctor Schedule, Test 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 Patient data.

Modules of Patient Management System and their descriptions:

  • Patient Module : Manage all the operations of Patient
  • Doctor Module : Manage all the operations of Doctor
  • Doctor Schedule Module : Manage all the operations of Doctor Schedule
  • Diease Module : Manage all the operations of Diease
  • Test Module : Manage all the operations of Test
  • Medicine Module : Manage all the operations of Medicine

Classes and their methods of Patient Management System:

  • Patient Methods : addPatient(), editPatient(), deletePatient(), updatePatient(), savePatient(), searchPatient()
  • Doctor Methods : addDoctor(), editDoctor(), deleteDoctor(), updateDoctor(), saveDoctor(), searchDoctor()
  • Doctor Schedule Methods : addDoctor Schedule(), editDoctor Schedule(), deleteDoctor Schedule(), updateDoctor Schedule(), saveDoctor Schedule(), searchDoctor Schedule()
  • Diease Methods : addDiease(), editDiease(), deleteDiease(), updateDiease(), saveDiease(), searchDiease()
  • Test Methods : addTest(), editTest(), deleteTest(), updateTest(), saveTest(), searchTest()
  • Medicine Methods : addMedicine(), editMedicine(), deleteMedicine(), updateMedicine(), saveMedicine(), searchMedicine()

Database tables and attributes of the Patient Management System:

  • Patient Entity : Attributes of Patient are patient_id, patient_name, patient_mobile, patient_email, patient_username, patient_password, patient_address,
  • Doctor Entity : Attributes of Doctor are doctor_id, doctor_name, doctor_specialist, doctor_mobile, doctor_email, doctor_username, doctor_password, doctor_address
  • Doctor Schedule Entity : Attributes of Doctor Schedule are doctor_schedule_id, doctor_schedule_time, doctor_schedule_type, doctor_schedule_date, doctor_schedule_description
  • Diease Entity : Attributes of Diease are diease_id, diease_patient_id, diease_name, diease_type, diease_description
  • Test Entity : Attributes of Test are test_id, test_patient_id, test_name, test_type, test_cost, test_report, test_description
  • Medicine Entity : Attributes of Medicine are medicine_id, medicine_name, medicine_company, medicine_composition, medicine_cost, medicine_type, medicine_dose, medicine_description

Database definition of Patient Management System:

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

Super admin functionality of Patient Management System:

  • Admin can add, edit, delete and view the records of Patient, Test, Doctor Schedule, Medicine
  • Admin can manage all the details of Doctor, Doctor Schedule, Diease, Test
  • Admin can also generate reports of Patient, Doctor, Doctor Schedule, Diease
  • Admin can search the details of Patient, Test, Doctor Schedule, Medicine
  • Admin can apply different level of filters on report of Patient, Doctor Schedule, Medicine
  • Admin can tracks the detailed information of Test, Medicine, Patient, Doctor

Report of Patient Management System:

  • Generates the report on Doctor Schedule,Diease,Patient,Doctor,Test,Medicine,
  • Diease,Test,Medicine 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 Diease,Test,Medicine
  • Excel Sheet report has also been integrated for Doctor,Diease,Medicine
  • You can create the CSV reports for Patient,Test,Doctor Schedule

Limitation of Patient Management System

  • Run time report generation is not available in Patient Management System.
  • We have not implemented the dynamic report for Patient,Diease,Test,Doctor,Doctor Schedule,Medicine
  • This project Patient 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 Patient, Diease, Medicine cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Patient Management System

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database