Student Project Guide

As the name suggests, the online eye care system is an application that will help in maintaining the details in the eye care clinic with great ease. The manual operations can also be done through this automated system. It will also help in maintaining the patients records without any difficulty. The treatment records can also be got through this application with great ease. The user interface must be simple and easy to understand even by the common man. This will be one of the applications that will help in maintaining the details of the treatment that are given to the patients just with one mouse click. This will be one of the interesting applications that one can work on.

The doctor details like name, address and the patient treated can also be maintained through this application with great ease. The functions that are included in the online eye care system application are as follows:

• Appointment details: The appointments that are placed by the patients on the particular day and time can be recorded through this application.
• Patient details: The details of the patients like name, address, treatment details and the other medication details can be maintained with great ease.
• Eye problems and diseases: The eye problems and the related diseases that a patient has can be maintained through this application.
• Treatment details: The treatment details and the medications that are given to the patients can be obtained in just one mouse click without any difficulty.
• Medical problem: The medications that are given to the patients for the particular eye problem can also be entered through this application.
• Reports: The daily, weekly or monthly reports of the patients can be generated through this application.
• Billing details: This will help in maintaining the billing details like the fees of the doctors can be maintained with great ease through this application.

The database name is onlineeyeclinic and it has 10 tables.

1. admin: Admin table stores administrator records.
2. appointment: Appointment table stores all appointment records taken by patient.
3. branch : Branch table stores branch details.
4. doctor: Doctor table has details of the doctor.
5. doctor_bill: This table stores bills generated by doctors after consultation.
6. orders: Patient ordered optical detail stores in this table.
7. patient: Patient registration detail stores in this table.
8. prescription: Prescription or medicine details stores in this table.
9. products : This stores optical details . Glass, lense, etc.
10. test : This table will store lab test records.

There are three types of users in this system.

• Administrator
• Doctor
• Patient

Customer: First the customer needs to register to the website. After the registration customer can login to the site. Patient can view his appointment details and product order details in the patient dashboard. Patient can book appointment and he has option to cancel his appoinement.

Admin: In the Admin dashboard admin can view order details. Administrator can update his profile and he can change his existing password. Admin can view patient details and doctor details. Admin can set appoint schedule for patient and he can cancel the appointment. Administrator can add branch details, Other admin records, Doctor details, Patient details and product details. Admin can manage product inventory details.

Doctor: In the doctor panel doctor can view his appointment details. In the doctor dashboard he can update his profile and doctor can change his password. Doctors can view appointment details. and he can place order for patients.

Login credentials:

Default login ID is : optomate
Default password is : 123

Default Login ID for doctor is : doctor
Default Password for doctor is : doctor

Default Login ID for customer is : patient@gmail.com
Default password for customer is : patient

Download Source code:

Video Preview: