Hospital Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Hospital Management System

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

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

  • You can search records on various criterias. Such as Hospitals, Nurses, Appointments, Medicines
  • Create, read, update and delete (CRUD) application has been implemented on Hospitals,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 Hospitals, Nurses, Doctors, Appointments
  • All the modules Doctors, Appointments, Patient,Medicines, Hospitals 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 Hospitals data.

Modules of Hospital Management System and their descriptions:

  • Hospitals Module : Manage all the operations of Hospitals
  • 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 Hospital Management System:

  • Hospitals Methods : addHospitals(), editHospitals(), deleteHospitals(), updateHospitals(), saveHospitals(), searchHospitals()
  • 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 Hospital Management System:

  • Hospitals Entity : Attributes of Hospitals are hospital_id, hospital_doctor_id, hospital_name, hospital_place, hospital_type, hospital_description, hospital_address
  • Patient Entity : Attributes of Patient are patient_id, patient_name, patient_mobile, patient_email, patient_username, patient_password, patient_address, patient_blood_group
  • 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 Hospital Management System:

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

Super admin functionality of Hospital Management System:

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

Report of Hospital Management System:

  • Generates the report on Doctors,Nurses,Hospitals,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 Hospitals,Appointments,Doctors

Limitation of Hospital Management System

  • Run time report generation is not available in Hospital Management System.
  • We have not implemented the dynamic report for Hospitals,Nurses,Appointments,Patient,Doctors,Medicines
  • This project Hospital 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 Hospitals, Nurses, Medicines cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Hospital Management System

  • We have added all the validations for input value on the modules Hospitals,Patient,Doctors
  • Nurses,Appointments,Medicines can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Hospitals,Doctors,Medicines
  • CSRF token has also been implemented on Nurses,Patient,Hospitals, Appointments,Medicines
  • All the Hospitals,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,Hospitals

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database