Download Hospital Management System PHP Source code

The assignment is to design and develop hospital management system. Below is the description of how the system works:

1.  Patient attends the hospital and meets the Receptionist at the front counter.
2.  The Receptionist asks about the patient’s details e.g. Name, what doctor they want to see etc. and assigns the patient to the relevant doctor as he/she sends the patient’s information to that doctor.
3.  When the patient visits the doctor, the doctor asks about what he/she is suffering from. The doctor may assign the patient to the lab to undergo various tests / scans or he may prescribe medicine and assign the patient to the pharmacist.
4.  The laboratory department will receive the patient’s information from the doctor and perform certain scans / tests as indicated by the doctor and will send the results back to the doctor.
5.  The doctor will prescribe the medicine and send the prescription to the pharmacist.
6.  The Pharmacist shall give the patient medicine and then will calculate the total cost of the medicine and send the report to the bursar.
7.   The Bursar shall demand payment for the purchased medicine.

§ 

Note: The users can update/change their information e.g username / password once they log into the system.

USER INTERFACE

The requirement of this assignment is to create a user interface which cooperates with the database to access the Hospital Management System.

For user interface, we have used MySQL, PHP, and HTML

Logging in:

This is an interface for Administrator to Log in to the system. The administrator is responsible to for creating other users of the hospital from different departments including doctors, receptionist, pharmacist, laboratorist, bursar.

The following php code was used for log in:

<?php
$con = mysql_connect('localhost', 'root','');
if (empty($con)) {
    echo mysql_error();
 }
 $data = mysql_select_db("Hospital");
 if (empty($data)) {
    echo mysql_error();
 }
?>

The above code performs the following functions, whereby the user enters the username and password and upon clicking the login button it takes the user to the index page provided the credentials are correct.

Login Page

ADMINISTRATOR FUNCTIONS

Staff account management:

The administrator is responsible for adding users, adding rooms and updating. The users refered here are Receptionist, Doctors, Pharmacists, lab etc. Below is the Php script to add users to the database whereby I have used the function to describe the parameters to add the users.

Script to Add user to the system.

function adduser()
{
    $username = trim(htmlspecialchars($_POST['username']));
    $fname = trim(htmlspecialchars($_POST['fname']));
    $sname = trim(htmlspecialchars($_POST['sname']));
    $type = trim(htmlspecialchars($_POST['type']));
    $password = trim(htmlspecialchars($_POST['password']));
    $pass = sha1($password);

    $sql1 = "SELECT * FROM `users` WHERE `username`='$username'";
    $query1 = mysql_query($sql1);
    if (mysql_num_rows($query1)==0) {
        $sql = "INSERT INTO `users` VALUES ('$username','$pass','$fname','$sname','$type')";
        $query = mysql_query($sql);
        if (!empty($query)) {
            echo "<br><b style='color:#008080;font-size:14px;font-family:Arial;'>User is Succesifully Added</b>";
        }
    }
    else{
        echo "<br><b style='color:#008080;font-size:14px;font-family:Arial;'>Choose Unique Name</b>";
    }

Add Users

The total number of users is displayed on the Admin dashboard

Home Page - Statistics

The next step which is most important is because the system comes into function now:

RECEPTIONIST FUNCTIONS

The receptionist logs into the system from the username and password created by the Admin:

Below is the receptionist dashboard and the functions that he / she can perform:

Receptionist Homepage

Below is the form the receptionist uses to add patient’s details and underneath the php code:

Add Patient Page

 function addpatient()
{
    $fname = trim(htmlspecialchars($_POST['fname']));
    $sname = trim(htmlspecialchars($_POST['sname']));
    $email = trim(htmlspecialchars($_POST['email']));
    $phone = trim(htmlspecialchars($_POST['phone']));
    $address = trim(htmlspecialchars($_POST['address']));
    $gender = trim(htmlspecialchars($_POST['gender']));
    $birthyear = trim(htmlspecialchars($_POST['birthyear']));
    $bloodgroup = trim(htmlspecialchars($_POST['bloodgroup']));

    require_once "connect.php";

    $sql = "INSERT INTO `patient` VALUES ('','$fname','$sname','$email','$address','$phone','$gender','$bloodgroup','$birthyear')";
    $query = mysql_query($sql);
    if (!empty($query)) {
        echo "<br><b style='color:#008080;font-size:14px;font-family:Arial;'>Patient is Succesifully Added</b><br><br>";
    }
    else{
        echo mysql_error();
    }}

The receptionist can update his / her information after logging in for the first time:

Update Receptionist

DOCTOR FUNCTIONS

The patient has now been assigned to the doctor and the doctor has received the patient details.

Below is the php script which takes input from the form that the doctor uses to add symptoms from the patient and and then sends the result to the lab for the patient to undergo scans and tests:

function addsymptoms()
{
    $symptoms = trim(htmlspecialchars($_POST['symptoms']));
    $test = trim(htmlspecialchars($_POST['test']));
    if (!empty($symptoms)) {
        $id = $_GET['id'];
        @require_once "connect.php";

        $sql = "UPDATE `medication` SET `status`='laboratory',`symptoms`='$symptoms',`tests`='$test' WHERE `id`='$id'";
        $query = mysql_query($sql);
        if (!empty($query)) {
            echo "<br><b style='color:#008080;font-size:14px;font-family:Arial;'>Succesifully Sent</b>";
        }
    }
}