Medical Record System in PHP and MySQL User Interface

Medical Record System in PHP and MySQL User Interface

SUMMARY

The Medical Record System is an area of clinic office function. These include patient’s personal information, official health records, medical and dental history, daily transaction, medicine log and inventory, common and uncommon illness.

The clinic is responsible in keeping these records secure and accessible. This is because, these records serves as basis in producing patients information like medical and dental history.

This will help the clinic personnel process records and keep the patients information in faster and accurate way. It will help to keep and handle essential information of the patients for their convenience. Clinic personnel can easily access and retrieve information regarding with patients records.

People ware Requirements

Medical and Dental Record Personnel – they are the persons who take charge for record keeping. Since they are the ones assigned for encoding and retrieving patients record as well as statistical report needed, they must learn how to use the system.

System Module and User Interface

1. Medical Record System Patient Information Module

Module Description: This module allows the user to add/edit patient’s information. Displayed in this module are the patient information including full name, gender, age, address, contact, username, and password.

Table Fields and Entities: id, recordNo, lname, fname, mname, gender, age, address, contact, username, password

2. Medical Record System Queue Module

Module Description: this module displays the queueing of the patients

Table Fields and Entities: id, patientid, mdate

3. Medical Record System Doctor Information Module

Module Description: this module displays the lists of doctors and their details such as full name, address, contact no., field of specialization, username and password. The user can also add/edit doctor details.

Table Fields and Entities: id, doctorrecono, doctorName, address, contact, fieldOfSpecialization, username, password

4. Medical Record System Cases/Diseases Information Module

Module Description: this module allows the user to add/edit identified diseases or cases.

Table Fields and Entities: id, caseName, description

5. Medical Record System Medicine Information Module

Module Description: this section allows the user to encode and manage available medicines.

Table Fields and Entities: id, medicineName, purpose, initialQty, dateDelivered

6. Medical Record System Consultation Module

Module Description: User can encode consultation details such as patient name, diagnostic, treatment, blood pressure, weight, attending doctor, date recorded.

Table Fields and Entities: id, patientid, diagnostic, treatment, bp, weight, attendingDoctorid, dateRecorded

7. Medical Record System Medicine Dispersion Module

• Module Description: user can encode medicine used after the consultation. Details includes the name of the medicine, quantity, amount, and the status.

• Module Description: this module displays the medicine dispersed after the consultation.

Table Fields and Entities: id, consultationid, medicineid, qty, amount, mstatus(sold or not)

8. Medical Record System Patient Lab Record Module

Module Description: this module displays the patient’s laboratory information such as laboratory used, result/status, and date released.

Table Fields and Entities: id, patientid, labName, resultStatus, dateReleased

9. Medical Record System Billing Information Module

• Module Description: the user can encode the billing information of the patient after the consultation.

• Module Description: this module displays the billing information in tabular form.

Table Fields and Entities: id, patientid, billTo, billAmount, dateRecorded, tblgivenmedicine.consultationid

10. Medical Record System Clerk Information Module

Module Description: This module allows the user to add/edit clerk accounts, details include clerk record number, full name, address, contact number, username, and password.

Table Fields and Entities: id, clerkrecno, fullname, address, contact, username, password

Development Tools:

The project is available in the following programming languages:

• Visual Basic and MySQL
• C# and MySQL
• PHP, MySQL and Bootstrap

You may visit our Facebook page for more information, inquiries, and comments. Please subscribe also to our YouTube Channel to receive  free capstone projects resources and computer programming tutorials.

Hire our team to do the project.

FREE DOWNLOAD SOURCE CODE