Eye Care Appoitment System

Posted By phpprojectz on August 28, 2017

Objective of Eye Care Appoitment System

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

Functionalities and their descriptions of Eye Care Appoitment System are as follows:

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

Modules of Eye Care Appoitment System and their descriptions:

  • Doctor Module : Manage all the operations of Doctor
  • Patient Module : Manage all the operations of Patient
  • Test Module : Manage all the operations of Test
  • Spectacles Module : Manage all the operations of Spectacles
  • Appointment Module : Manage all the operations of Appointment
  • Booking Module : Manage all the operations of Booking

Classes and their methods of Eye Care Appoitment System:

  • Doctor Methods : addDoctor(), editDoctor(), deleteDoctor(), updateDoctor(), saveDoctor(), searchDoctor()
  • Patient Methods : addPatient(), editPatient(), deletePatient(), updatePatient(), savePatient(), searchPatient()
  • Test Methods : addTest(), editTest(), deleteTest(), updateTest(), saveTest(), searchTest()
  • Spectacles Methods : addSpectacles(), editSpectacles(), deleteSpectacles(), updateSpectacles(), saveSpectacles(), searchSpectacles()
  • Appointment Methods : addAppointment(), editAppointment(), deleteAppointment(), updateAppointment(), saveAppointment(), searchAppointment()
  • Booking Methods : addBooking(), editBooking(), deleteBooking(), updateBooking(), saveBooking(), searchBooking()

Database tables and attributes of the Eye Care Appoitment System:

  • Doctor Entity : Attributes of Doctor are doctor_id, doctor_name, doctor_specialist, doctor_mobile, doctor_email, doctor_username, doctor_password, doctor_address
  • Patient Entity : Attributes of Patient are patient_id, patient_name, patient_mobile, patient_email, patient_username, patient_password, patient_address,
  • Test Entity : Attributes of Test are test_id, test_patient_id, test_name, test_type, test_cost, test_report, test_description
  • Spectacles Entity : Attributes of Spectacles are spectacle_id, spectacle_patient_id, spectacle_number, spectacle_type, spectacle_description
  • Appointment Entity : Attributes of Appointment are appointment_id, appointment_doctor_id, appointment_number, appointment_type, appointment_date, appointment_description
  • Booking Entity : Attributes of Booking are booking_id, booking_title, booking_type, booking_appointmnet booking_date, booking_description

Database definition of Eye Care Appoitment System:

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

Super admin functionality of Eye Care Appoitment System:

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

Report of Eye Care Appoitment System:

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

Limitation of Eye Care Appoitment System

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

Input Data and Validation of Eye Care Appoitment System

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database