This project “Hospital Management System” includes Admin, doctor & patient login, storing/fetching their details into/from the system. The software has the facility to give a unique id for every patient & doctor; stores the clinical details of every patient. It includes a search facility to know the current status of each patient. One can login into Mapaish Hospital using an email and a password. It is accessible by an administrator, and only they can add data/delete into/from the database. The data can be retrieved easily. The interface is very user-friendly.
In a Mapaish Hospital a database is to be designed to store following requirements. Permanent doctors get fixed salaries. Personal information like name, address, date of birth, contact number, specialization, and salary are required. Consulting doctors visits at a fixed time every day. Personal information like name, address, date of birth, contact number, specialization, and charges are required. Patients are admitted to the hospital. Personal information like name, address, date of birth, contact number, blood group. relative's name & address, reasons for admission are required. Patients are admitted to rooms of different types, per day charges depends on room type. Various labs in hospitals, where several tests are conducted on patients, each test has fixed charge. GUI should allow recording details of Doctors, Patients and rooms also modifying current details etc. Only the administrator is allowed to do these operations. Doctors can see information of patients if and only if the patient is under treatment of the doctor. Administrator is allowed to generate various reports based on data, patient, room types, doctors etc.
Query 1: Given any reason for admission, list the number of patients having that same reason.
Query 2: Find permanent doctors having a salary in a range of salaries.
● Personal Computer ● 128 MB minimum RAM Required ● Internet or LAN Connections
● Modern Browser ● PHP server ● Database Server(MariaDB/ MySQL)
- Presentation layer (your PC, Tablet, Mobile, etc.)
- Application layer (PHP server)
- Database Server (MySQL, MariaDB)
The user then needs to login to access the system, where they can view the data present in the hospital database. Only the admin can edit the data present in the database. The login form validation is done using jQuery library for Javascript , PHP and Database . Duplicate E-Mail IDs are validated against the database using AJAX and PHP. When the user logins, the user session is created to uniquely identify the user. The admin sends requests to the PHP server for addition/updation/deletion of data, which then updates the database as per the assigned query. In similar fashion other users view and sort the database.
a. Client side validation is done using jQuery and server side validation is done using AJAX, PHP and database.
a. If the user is logged in as a doctor then the patient page will be inactive.
b. Same goes for the patient who won’t be able to access the doctor page .
a. It greets every user that logs on the system.
b. It performs Sorting query for the doctor and Search query for the patient.
c. And an add button only available for admin.
a. It displays the data in the form of a table.
The SQL file in the project needs to be imported in MySQL/MariaDB Database server. The Database contains the following tables.
Login: It has 3 attributes: password, email and user_type.
Patient: It has 7 attributes: patient_ID, name, dob, gender, blood_group, email and mobile number.
Doctor: It has 9 attributes: doctor_ID, Name, dob, gender, salary, email, mobile number, specialization and type.
Assigned to: It is a relationship table containing the following attributes: treatment_ID, patient_OD, doctor_ID, room_type, treatment_type, fees, startTime, days.
Room: It has 2 attributes: room_type and charge.
Test: It has 2 attributes: name and charge.
Test Conducted: It is a relationship table containing the following attributes: treament_ID, test_name and count.
