Health Care Appointment System

Posted By phpprojectz on August 28, 2017

Objective of Health Care Appointment System

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

Functionalities and their descriptions of Health Care Appointment System are as follows:

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

Modules of Health Care Appointment System and their descriptions:

  • Health Care Module : Manage all the operations of Health Care
  • Booking Module : Manage all the operations of Booking
  • Appointment Module : Manage all the operations of Appointment
  • Customer Module : Manage all the operations of Customer
  • Medicine Module : Manage all the operations of Medicine
  • Test Module : Manage all the operations of Test

Classes and their methods of Health Care Appointment System:

  • Health Care Methods : addHealth Care(), editHealth Care(), deleteHealth Care(), updateHealth Care(), saveHealth Care(), searchHealth Care()
  • Booking Methods : addBooking(), editBooking(), deleteBooking(), updateBooking(), saveBooking(), searchBooking()
  • Appointment Methods : addAppointment(), editAppointment(), deleteAppointment(), updateAppointment(), saveAppointment(), searchAppointment()
  • Customer Methods : addCustomer(), editCustomer(), deleteCustomer(), updateCustomer(), saveCustomer(), searchCustomer()
  • Medicine Methods : addMedicine(), editMedicine(), deleteMedicine(), updateMedicine(), saveMedicine(), searchMedicine()
  • Test Methods : addTest(), editTest(), deleteTest(), updateTest(), saveTest(), searchTest()

Database tables and attributes of the Health Care Appointment System:

  • Health Care Entity : Attributes of Health Care are health_care_id, health_care_name, health_care_type, health_care_description
  • Booking Entity : Attributes of Booking are booking_id, booking_title, booking_type, booking_appointment, booking_date, booking_description
  • Appointment Entity : Attributes of Appointment are appointment_id, appointment_doctor_id, appointment_number, appointment_type, appointment_date, appointment_description
  • Customer Entity : Attributes of Customer are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
  • Medicine Entity : Attributes of Medicine are medicine_id, medicine_name, medicine_company, medicine_composition, medicine_cost, medicine_type, medicine_dose, medicine_description
  • Test Entity : Attributes of Test are test_id, test_patient_id, test_name, test_type, test_cost, test_report, test_description

Database definition of Health Care Appointment System:

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

Super admin functionality of Health Care Appointment System:

  • Admin can add, edit, delete and view the records of Health Care, Medicine, Appointment, Test
  • Admin can manage all the details of Booking, Appointment, Customer, Medicine
  • Admin can also generate reports of Health Care, Booking, Appointment, Customer
  • Admin can search the details of Health Care, Medicine, Appointment, Test
  • Admin can apply different level of filters on report of Health Care, Appointment, Test
  • Admin can tracks the detailed information of Medicine, Test, Health Care, Booking

Report of Health Care Appointment System:

  • Generates the report on Appointment,Customer,Health Care,Booking,Medicine,Test,
  • Customer,Medicine,Test 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 Customer,Medicine,Test
  • Excel Sheet report has also been integrated for Booking,Customer,Test
  • You can create the CSV reports for Health Care,Medicine,Appointment

Limitation of Health Care Appointment System

  • Run time report generation is not available in Health Care Appointment System.
  • We have not implemented the dynamic report for Health Care,Customer,Medicine,Booking,Appointment,Test
  • This project Health Care Appointment System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Health Care, Customer, Test cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Health Care Appointment System

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database