You are tasked with developing a comprehensive program code $($php$)$ for a Clinic Patient Management

System based on the provided information using PHP and CSS$.$ ASSIGNMENT

Lens:

Lens Price:

Frame:

Frame code:

Frame Price:

Amount:

Discount:

TOTAL

Mode of payment:

Optometrist:

REPLACEMENTS:

Start$-$up Page

First of all, the system needs to have a start$-$up page for the clinic staff. This page consists of:

$\backslash$table$[[$Functions$,$Descriptions$],[$Clinic Logo,$\backslash$table$[[$This is the logo of the clinic which needs to$],[$design it based on your creativity.$]]],[$Welcoming Text,$\backslash$table$[[$This is the text to welcome all the users into the$],[$system$.]]],[$Register Button,$\backslash$table$[[$Button for new users to register an account in this$],[$system$]]],[$Login Button,$\backslash$table$[[$Button for the existing users to login into the$],[$system before using it$.]]]]$

Patient Profile

$\backslash$table$[[$Input Details,Descriptions$],[$Patient$\text{'}$s Name,$\backslash$table$[[$Name of the patient that want to register a new$],[$account in this system$]]],[$Date Examined,$\backslash$table$[[$Allowing the attendant to insert a date of$],[$examination of the patient$]]],[$Age$,\backslash$table$[[$The attendant needs to input the phone number$],[$into the system.$]]],[$Address$,\backslash$table$[[$Allow the librarian to insert a chosen username$],[$that consist of strings and numbers.$]]],[$Birthdate$,\backslash$table$[[$Allowing the attendant to insert the patient's date$],[$of birth$]]],[$Contact$,\backslash$table$[[$Allowing the attendant to insert the patient's$],[$contact information$]]],[$Patient$\text{'}$s Complain $-$ Concerns,$\backslash$table$[[$Allowing the attendant to insert the patients$],[$complains or concerns$]]]]$

Page $3$ of $7$ ASSIGNMENT

Health History

Allowing the attendant to insert the patient's

health history

Rx Form

Modified$/$Final Rx

PD Form

PD

Contact Lens Conversion

Diagnosis and Remarks Form

Each form must be able to add and retrieve transaction information. $1\mathrm{.}1$ Login Page

For the login page, the existing users $($the attendants$)$ need to input all the information details:

$\backslash$table$[[$Input Details,Descriptions$],[$Username$,$Insert the existing username$],[$Password$,$Insert the existing password$],[$Message Box,$\backslash$table$[[$Display a message for validation if the user$],[$entered the wrong username or password$]]]]$

$2\mathrm{.}1$ Patient Profile Page

When users click on the patient menu in the menu list page, it will show this page that offers variety of functions.

This page consists of all the below functions:

$\backslash$table$[[$Functions$,$Descriptions$],[$Search$/$Retrieve$,\backslash$table$[[$With this function, users can look for a patient's$],[$details by entering parameters like name, patient$],[$ID$,$ or medical record number $($users can select$],[$any of these$).$ The comprehensive patient data,$],[$including patient ID$,$ date of birth, name,$],[$contact details, attending physician, and medical$],[$history$,$ will all be shown on one page.$]]],[$Add$,\backslash$table$[[$This capability enables users to input new details$],[$for a patient into the database.$]]],[$Update$,\backslash$table$[[$This capability enables users to update new$],[$details for a patient into the database.$]]],[$Delete$,\backslash$table$[[$This capability enables users to delete details for$],[$a patient from the database.$]]],[$Return$,$To exit this page and return to the menu list page$]]$

$3\mathrm{.}0$ Database

For the database of this system, it consists of all the below tables:

$\backslash$table$[[$Functions$,$Descriptions$],[$User$,\backslash$table$[[$This table stores all the data for the registered$],[$users in the system $($date stored: staff name, staff$],[$id$,$ phone number, username and password$)]]],[$Patients$,\backslash$table$[["$This table stores all the information and details$],[$about the patient that are provided in the medical$],[$records $($data stored: patient ID$,$ date of birth,$]]]]$

Page $5$ of $73\mathrm{.}0$ Database

For the database of this system, it consists of all the below tables:

ASSIGNMENT

The newly established Haven Eye Clinic, supported by government funding, has commenced its

services. Accessible to the public, the clinic is staffed by three $(3)$ healthcare professionals. In light

of this, there is a crucial need for a Clinic Patient Management System to streamline the clinic's

operations. The system should enable eye care providers to manage patient information efficiently,

facilitating appointment scheduling, tracking medical records, and managing the examinations

processes. The detailed system requirements are outlined below.

Patients Name:

Date Examined:

Age:

Address:

Contact number:

Patient's Complaint$/$concerns:

Healthy History:

$Px$

Modified$/$Final $Rx$

PD:

Contact lens comversion:

Diagnosis:

Remarks: