Hospital Management System Using Php

(1)

1 M.A.M. COLLEGE OF ENGINEERING AND TECHNOLOGY

TRICHY -621105

DEPARTMENT OF INFORMATION TECHNOLOGY

ANNA UNIVERSITY PRACTICAL EXAMINATIONS, OCT–2011

RECORD NOTE BOOK

CS1403 - SOFTWARE DEVELOPMENT LABORATORY

Student Name

:

Register Number

:

Class & Semester

: 2008-2012, B.Tech., IT, VII - Semester

Month & Year

: OCT - 2011

(2)

2

(3)

3 M.A.M. COLLEGE OF ENGINEERING AND TECHNOLOGY

TRICHY -621105

DEPARTMENT OF INFORMATION TECHNOLOGY

ANNA UNIVERSITY PRACTICAL EXAMINATIONS, OCT–2011

BONAFIDE CERTIFICATE

This is to certify that this practical work titled CS1403 – Software Development

Laboratory is the bonafide work of ________________________________

Register Number ______________________ during the academic year 2011-2012.

Faculty Incharge

Head of the Department

Submitted for Anna University of Technology, Tiruchirappalli practical

examination held on __/_/___ at M.A.M. College of Engineering and

Technology, Trichy – 621105.

(4)

4 ABSTRACT

Our project Hospital Management system includes registration of patients,

storing their details into the system, and also computerized billing in the pharmacy,

and labs. Our software has the facility to give a unique id for every patient and

stores the details of every patient and the staff automatically. It includes a search

facility to know the current status of each room. User can search availability of a

doctor and the details of a patient using the id.

The Hospital Management System can be entered using a username and

password. It is accessible either by an administrator or receptionist. Only they can

add data into the database. The data can be retrieved easily. The interface is very

user-friendly. The data are well protected for personal use and makes the data

processing very fast.

(5)

5 TABLE OF CONTENT

Description

Page No

BONAFIE CERTIFICATE

03 ABSTRACT

04 Chapter 1 INTRODUCTION

07

1.1 Problem Definition

08

1.2 Requirement of Proposed System

10

1.3 System Analysis

12

1.4 Proposed System

14 Chapter 2 PROCESS DESCRIPTION

16

2.1 Doctor Module

16

2.2 Patient Module

18

2.3 Appointment Module

20 Chapter 3 PROGRAM DESIGN

22

(6)

6

3.2 Patient Module

27

3.3 Appointment Module

29 Chapter 4 DATABASE DESIGN

32 Chapter 5 CONCLUSION

35 REFERENCES

36 Appendix

(7)

7

Chapter 1 INTRODUCTION

In most developing countries, provision of basic preventive, promotive and

curative services is a major concern of the Government. With growing population

and advancement in the medical technology and increasing expectation of the

people especially for quality curative care, it has now become imperative to

provide quality health care services through the established institutions. In public

Sector 15,393 allopathic hospitals (Health Information of India 2003) are

functioning. In the rural areas, the secondary level care is being provided through

3222 CHCs (Bulletin on Rural Health Statistics in India 2005) with 30 beds each

with specialist services of physicians, pediatricians, O & G specialists, and

surgeons being made available.

However, these services have not been successful in gaining the faith and

confidence of the people because of lack of specialists, facilities and

accountability, along with the paucity of resources and non-involvement of the

community. Hospital Management System is a simple yet effective management

structure. This system acts for the hospitals to manage the affairs of the hospital.

(8)

8 HMS is free to prescribe, generate and use the functioning and maintaining the

quality of services.

1.1 PROBLEM DEFINITION

This project is aimed to automate the hospital management system. This

project is developed mainly to administrate doctor's appointment with the patients.

The purpose of the project entitled as HOSPITAL MANAGEMENT SYSTEM is

to computerize the Front Office Management of Hospital to develop software

which is user friendly, simple, fast, and cost – effective. It deals with the collection

of patient’s information, diagnosis details, etc. Traditionally, it was done manually.

The main function of the system is to register and store patient details and doctor

details and retrieve these details as and when required, and also to manipulate these

details meaningfully.

(9)

9 NEED

1. Efficiently maintains the details about the patient

2. Simultaneously updates changes made to any data, item in the entire data base.

3. It is faster than manual system

(10)

10 The goal of any system development is to develop and implement the system

cost effectively; user-friendly and most suited to the user’s analysis is the heart of

the process.

This function of Hospital Management Information System deals with

registering the new Patient either for OPD or IPD and giving unique Identification

Number to the Patient. This number is unique throughout the System for

identifying the patient.

Analysis is the study of the various operations performed by the system and

their relationship within and outside of the system. During analysis, data collected

on the files, decision points and transactions handled by the present system.

Different kinds of tools are used in analysis of which interview is a common one.

The patient can be registered at Reception. Patient identification number is

also created for each separate visit of the patient. This is also a part of registering

patient. ID is used for tracking of medical records of the patient for that particular

OPD visit or IPD admission. All the medical record of the patient are identified by

combination of numbers i.e. Patient ID. The numbers gives flexible search in terms

of finding patient's History Record.

1.2 REQUIREMENT OF PROPOSED SYSTEM

The first step in system development life cycle is the identification of need

of change to improve or enhance an existing system. An initial investigation on

existing system was carried out. The present system of hospital is completely

(11)

11 manual. Many problems were identified during the initial study of the existing

system. To develop this software detailed study is made at local hospital. Based on

the information collected it is decided to maintain the basic information about

doctors and patients.

PATIENT REGISTRATION

SLOT DETAILS

(12)

12 Each patient will consult the doctor based on the appointment. If the doctor is free

on his/her duty time, the outpatient can consult the doctor after the spot

appointments are made.

APPOINTMENT

Appointments for patients may be made at the reception. New patients are

informed to fill the registration form and pay registration fees. Then the patient id

is generated and issued to the patient for further use.

The appointment may be fixed by verifying doctor's and their free slots available,

then the appointment will be confirmed. Otherwise the dates or slots may be asked

to change for the patients.

1.3 SYSEM ANALYSIS

System analysis is a detailed study of the various operations performed by a

system and their relationships within and outside of the system. Here the key

question is – What all problems exist in the present system? What must be done to

solve the problem? Analysis begins when a user or manager begins a study of the

program using existing system. During analysis, data collected on the various files,

decision points and transactions handled by the present system.

The commonly used tools in the system are Data Flow Diagram, interviews,

etc. training, experience and common sense are required for collection of relevant

information needed to develop the system. The success of the system depends

(13)

13 largely on how clearly the problem is defined, thoroughly investigated and

properly carried out through the choice of solution.

A good analysis model should provide not only the mechanisms of problem

understanding but also the framework of the solution. Then the proposed system

should be analyzed thoroughly in accordance with the needs.

(14)

14  System analysis can be categorized into four parts.

 System planning and initial investigation

 Information gathering

 Applying analysis tools for structured analysis

 Feasibility study

 Cost/benefit analysis

The doctor's appointment with various slots for patient is created and

maintained by system. The appointments can be altered at any time before an hour

of the actual appointment schedule. The doctors and patients details must be

registered to create the appointments.

(15)

15 The drawback of the existing system is that it is very difficult to retrieve data

from case files. It is difficult to handle the whole system manually and it is less

accurate and to keep the data in case files for future reference because it may get

destroyed. Moreover it is very difficult to retrieve data. Redundancy of data may

occur and this may lead to the inconsistency. The manual system is so

time-consuming.

(16)

16 The proposed system is very easy to operate. Speed and accuracy are the

main advantages of proposed system. There is no redundancy of data. The data are

stored in the computer’s secondary memories like hard disk, etc. it can be easily

receive and used at any time. The proposed system will easily handle all the data

and the work done by the existing systems. The proposed systems eliminate the

drawbacks of the existing system to a great extent and it provides tight security to

data.

(17)

17

Chapter 2 PROCESS DESCRIPTION

2.1 DOCTOR MODULE

Process Name

: Doctor list

Process Number

: 1.1

Input

: Doctor Number – Select from List

Output

: Status Message

Error Condition

: Records Not Found – if no records in database

Process Name

: Add Doctor

Process Number

: 1.2

Input

: Name

: Specialization

Output

: Status Message

: Doctor Number (ID)

Error Condition

: Name Can’t be Empty

(18)

18 Process Name

: Delete Doctor

Process Number

: 1.3

Input

: Doctor Number (ID)

Output

: Status Message

Error Condition

: None

Process Name

: Modify Doctor

Process Number

: 1.4

Input

: Doctor Number (ID)

: Name

: Specialization

Output

: Status Message

Error Condition

: Name Can’t be Empty

: Specialization Can’t be Empty

Process Name

: Undelete Doctor

Process Number

: 1.5

Input

: Doctor Number (ID)

Output

: Status Message

(19)

(20)

20 2.2 PATIENT MODULE

Process Name

: Patient list

Process Number

: 2.1

Input

: Patient Number – Select from List

Output

: Status Message

Error Condition

: Records Not Found – if no records in database

Process Name

: Add Patient

Process Number

: 2.2

Input

: Name

: Sex

: Address

Output

: Status Message

: Patient Number (ID)

Error Condition

: Name Can’t be Empty

(21)

21 Process Name

: Delete Patient

Process Number

: 2.3

Input

: Patient Number (ID)

Output

: Status Message

Error Condition

: None

Process Name

: Modify Patient

Process Number

: 2.4

Input

: Patient Number (ID)

: Name

: Sex

: Address

Output

: Status Message

Error Condition

: Name Can’t be Empty

: Address Can’t be Empty

Process Name

: Undelete Patient

Process Number

: 1.5

Input

: Patient Number (ID)

Output

: Status Message

(22)

22 2.3 APPOINTMENT MODULE

Process Name

: Appointment List

Process Number

: 3.1

Input

: Doctor Number

Output

: Appointment with Patient Details

Error Condition

: Records Not Found – if no records in database

Process Name

: Add Appointment

Process Number

: 3.2

Input

: Doctor Number

: Patient Number

: Slot Schedule

Output

: Status Message

: Appointment Number (ID)

Error Condition

: None

(23)

23 Process Name

: Delete Appointment

Process Number

: 3.3

Input

: Appointment Number (ID)

Output

: Status Message

Error Condition

: None

Process Name

: Modify Appointment

Process Number

: 2.4

Input

: Appointment Number (ID)

: Doctor – Select from List

: Patient – Select from List

: Slot – Select from List

Output

: Status Message

Error Condition

: None

Process Name

: Undelete Patient

Process Number

: 3.5

Input

: Appointment Number (ID)

Output

: Status Message

(24)

24

Chapter 3 PROGRAM DESIGN

3.1 DOCTOR MODULE

(25)

25 INSERTION OF NEW DOCTOR RECORD

RECORD CREATION

(26)

26 UPDATED LIST AFTER INSERTION OF NEW RECORD

(27)

27 STATUS MESSAGE

(28)

28 DELETE SELECTED DOCTOR

UPDAED LIST AFTER DELETION

(29)

29 3.2 PATIENT MODULE

REGISTERED PATIENTS

(30)

30 MODIFICATION OF EXISTING PATIENT RECORD

DELETION OF EXISTING PATIENT RECORD

(31)

31 3.3 APPOINTMENT MODULE

APPOINTMENT DETAILS

(32)

32 STATUS MESSAGE

MODIFICATION OF APPOINTMENT

(33)

33

(34)

34

Chapter 4 DATABASE DESIGN

DATABASE: HOSPITAL

(35)

35 TABLE: DOCTOR (DOCT)

(36)

36

(37)

37

Chapter 5 CONCLUSION

The HOSPITAL MANAGEMENT SYSTEM is a great improvement over

the manual system using case fields and paper. The computerization of the system

has sped up the process. In the current system, the front office managing is very

slow. The hospital managing system was thoroughly checked and tested with

dummy data and thus is found to be very reliable.

ADVANTAGES

 It is fast, efficient and reliable

 Avoids data redundancy and inconsistency

 Web-based

 Number of personnel required is considerably less

 Provides more security and integrity to data

FUTURE ENHANCEMENTS

The proposed system is Hospital Management System. We can enhance this

system by including more facilities like billing system, inpatient room allotment

for the admitted patients and the stock details of medicines in the pharmacy.

Providing such features enable the users to include more comments into the

system.

(38)

38 REFERENCES

1. PHP MySQL Website Programming: Problem - Design – Solution byChris

Lea, Mike Buzzard, Dilip Thomas , Jessey White-Cinis

2. Beginning PHP5, Apache, and MySQL Web Development (Programmer to

Programmer) by Elizabeth Naramore

3. MySQL/PHP Database Applications, 2nd Edition by Brad Bulger

4. How to Do Everything with PHP and MySQL by Vikram Vaswani

(39)

39

Appendix 1 SAMPLE SOURCE CODE

DADD.PHP

<html>

<head>

</head> <body>

<tr bgcolor=blue><td align=center><font SIZE=6 color=white>HOSPITAL MANAGEMENT SYSTEM</font></td></tr>

<tr><td><table align=center width=750 cellspacing=0 cellpadding=5> <tr><td align=center><a href=dlist.php>Doctors</td><td align=center><a href=plist.php>Patients</td><td align=center><a

href=app.php>Appointments</td> </table></td></tr>

<tr bgcolor=red><td ><font size=4 color=white>New Doctor</font></td></tr>

<tr><td>Doctor Name</td><td><input type=text name=name size=30 maxlength=30></td></tr>

<tr><td>Specilization</td><td><input type=text name=spec size=30 maxlength=30></td></tr>

</table></td></tr>

</table> </body>

(40)

40

</html>

DSAVE.PHP <html>

<head>

</head> <body>

<tr bgcolor=red><td ><font size=4 color=white>Save Doctor</font></td></tr>

<?php

$name=trim($_POST["name"]); $spec=trim($_POST["spec"]); $error=0;

if ($name=="") { $error=1; echo "<tr><td><font color=red size=4>Name can't empty</font></td></tr>"; }

if ($spec=="") { $error=1; echo "<tr><td><font color=red size=4>Specilization can't empty</font></td></tr>"; } if ($error==0) {

if(!mysql_connect("localhost","root","")) {

echo "<tr><td><font color=red size=4>Connection Error</font></td></tr>";

(41)

41

die(); }

mysql_select_db("hospital");

mysql_query("insert into doct(dname,dspec,dshow) values('".$name."','".$spec."','Y')");

echo "<tr><td align=center><font size=4 color=green>Successfully Records Inserted</font></td></tr>";

} else {

echo "<form name=fdadd method=post action=dsave.php>";

echo "<tr><td><table width=750 cellspacing=0 cellpadding=5>"; echo "<tr><td>Doctor Name</td><td><input type=text name=name size=30 maxlength=30 value='".$name."'></td></tr>";

echo "<tr><td>Specilization</td><td><input type=text name=spec size=30 maxlength=30 value='".$spec."'></td></tr>";

echo "</table></td></tr>";

echo "<tr><td align=center><input type=submit value=Submit></td></tr>"; echo "</form>"; } echo "<tr><td align=center><a href=dlist.php>Continue...</a></td></tr>"; echo "</table>"; echo "</body></html>"; DLIST.PHP <html> <head>

(42)

42

<body>

<tr bgcolor=red><td ><font size=4 color=white>Doctors List</font></td></tr>

<tr><td><a href=dadd.php>Add New Record</a></td></tr> <tr><td><table width=750 cellspacing=0 cellpadding=5>

<tr bgcolor=#ccccc><td align=center>S No</td><td align=center>Doctor Name</td><td align=center>Specialization</td><td

align=center>Options</td></tr> <?php

die(); }

$rs1=mysql_query("SELECT * from doct where dshow='Y' order by dname;"); $sno=1; while( $row=mysql_fetch_array($rs1)) { echo "<tr><td>$sno</td><td>$row[1]</td><td>$row[2]</td><td><a href=dmod.php?rno=".$row[0].">Modify</a> | <a href=ddel.php?rno=".$row[0].">Delete</a></td></tr>"; $sno++; }

(43)

43

if ($sno==1) echo "<tr><td align=center><font size=4 color=red>Records Not Found</font></td></tr>";

?>

</table></td></tr>

<tr bgcolor=red><td><font size=4 color=white>Deleted Records</font></td></tr>

$rs2=mysql_query("SELECT * from doct where dshow='N' order by dname;"); $sno=1; while( $row=mysql_fetch_array($rs2)) { echo "<tr><td>$sno</td><td>$row[1]</td><td>$row[2]</td><td><a href=dundel.php?rno=".$row[0].">Undelete</a></td></tr>"; $sno++; }

if ($sno==1) echo "<tr><td align=center><font size=4 color=red>Records Not Found</font></td></tr>"; ?> </table></td></tr> </table> </body> </html> DMOD.PHP <html> <head>

(44)

44

<title>Modify Doctor Profile</title> </head>

<body>

<tr><td><table align=center width=750 cellspacing=0 cellpadding=5> <tr><td align=center><a href=dlist.php>Doctors</td><td align=center><a href=plist.php>Patients</td><td align=center><a href=app.php>Appointments</td> </table></td></tr> <?php $rno=trim($_GET["rno"]); if(!mysql_connect("localhost","root","")) {

die(); }

$rs1=mysql_query("SELECT * from doct where dno='".$rno."'"); $sno=1;

while( $row=mysql_fetch_array($rs1)) {

echo "<tr bgcolor=red><td ><font size=4 color=white>Edit Doctor Details</font></td></tr>";

echo "<form name=fdmod method=post action=dupdate.php>"; echo "<tr><td><table width=750 cellspacing=0 cellpadding=5>"; echo "<tr><td>Doctor Name</td><td><input type=text name=name size=30 maxlength=30 value='".$row[1]."'></td></tr>";

echo "<tr><td>Specilization</td><td><input type=text name=spec size=30 maxlength=30 value='".$row[2]."'></td></tr>";

(45)

45

value=".$rno."><input type=submit value=Submit></td></tr>"; echo "</form>";

$sno++; }

if ($sno==1) echo "<tr><td align=center><font size=4 color=red>Records Not Found</font></td></tr>"; ?> </table> </body> </html> DUPDATE.PHP <html> <head>

</head> <body>

<tr bgcolor=red><td ><font size=4 color=white>Update Doctor</font></td></tr> <?php $rno=trim($_POST["rno"]); $name=trim($_POST["name"]); $spec=trim($_POST["spec"]); $error=0;

(46)

46

if ($name=="") { $error=1; echo "<tr><td><font color=red size=4>Name can't empty</font></td></tr>"; }

if ($spec=="") { $error=1; echo "<tr><td><font color=red size=4>Specilization can't empty</font></td></tr>"; } if ($error==0) {

die(); }

mysql_connect("localhost","root",""); mysql_select_db("hospital");

mysql_query("update doct set dname='".$name."',dspec='".$spec."' where dno='".$rno."'");

echo "<tr><td align=center><font size=4 color=green>Successfully Records Updated</font></td></tr>";

} else {

echo "<form name=fdadd method=post action=dupdate.php>"; echo "<tr><td><table width=750 cellspacing=0 cellpadding=5>"; echo "<tr><td>Doctor Name</td><td><input type=text name=name size=30 maxlength=30 value='".$name."'></td></tr>";

echo "<tr><td>Specilization</td><td><input type=text name=spec size=30 maxlength=30 value='".$spec."'></td></tr>";

echo "<tr><td align=center><input type=hidden name=rno value=".$rno."><input type=submit value=Submit></td></tr>";

echo "</form>"; }

echo "<tr><td align=center><a

href=dlist.php>Continue...</a></td></tr>"; echo "</table>";

(47)

47

echo "</body></html>";

DDEL.PHP

<html>

<head>

</head> <body>

<tr bgcolor=red><td ><font size=4 color=white>Doctors List</font></td></tr>

<tr><td><a href=dadd.php>Add New Record</a></td></tr> <tr><td><table width=750 cellspacing=0 cellpadding=5>

die(); }

(48)

48

$rs1=mysql_query("SELECT * from doct where dshow='Y' order by dname;"); $sno=1; while( $row=mysql_fetch_array($rs1)) { echo "<tr><td>$sno</td><td>$row[1]</td><td>$row[2]</td><td><a href=dmod.php?rno=".$row[0].">Modify</a> | <a href=ddel.php?rno=".$row[0].">Delete</a></td></tr>"; $sno++; }

?>

</table></td></tr>

<tr bgcolor=red><td><font size=4 color=white>Deleted Records</font></td></tr>

$rs2=mysql_query("SELECT * from doct where dshow='N' order by dname;"); $sno=1; while( $row=mysql_fetch_array($rs2)) { echo "<tr><td>$sno</td><td>$row[1]</td><td>$row[2]</td><td><a href=dundel.php?rno=".$row[0].">Undelete</a></td></tr>"; $sno++; }

?>

(49)

49

</table> </body> </html> DUNDEL.PHP <html> <head>

</head> <body>

<tr bgcolor=red><td ><font size=4 color=white>Recover Doctor</font></td></tr>

<?php

$rno=$_GET["rno"];

die(); }

mysql_query("update doct set dshow='Y' where dno='$rno'");

(50)

50

Records Recovered</font></td></tr>"; echo "<tr><td align=center><a href=dlist.php>Continue...</a></td></tr>"; echo "</table>"; echo "</body></html>";

Hospital Management System Using Php

1

M.A.M. COLLEGE OF ENGINEERING AND TECHNOLOGY

TRICHY -621105

DEPARTMENT OF INFORMATION TECHNOLOGY

ANNA UNIVERSITY PRACTICAL EXAMINATIONS, OCT–2011

RECORD NOTE BOOK

CS1403 - SOFTWARE DEVELOPMENT LABORATORY

Student Name

:

Register Number

:

Class & Semester

: 2008-2012, B.Tech., IT, VII - Semester

Month & Year

: OCT - 2011

2

3

M.A.M. COLLEGE OF ENGINEERING AND TECHNOLOGY

TRICHY -621105

DEPARTMENT OF INFORMATION TECHNOLOGY

ANNA UNIVERSITY PRACTICAL EXAMINATIONS, OCT–2011

BONAFIDE CERTIFICATE

This is to certify that this practical work titled CS1403 – Software Development

Laboratory is the bonafide work of ________________________________

Register Number ______________________ during the academic year 2011-2012.

Faculty Incharge

Head of the Department

Submitted for Anna University of Technology, Tiruchirappalli practical

examination held on ____/___/___ at M.A.M. College of Engineering and

Technology, Trichy – 621105.

4

ABSTRACT

Our project Hospital Management system includes registration of patients,

storing their details into the system, and also computerized billing in the pharmacy,

and labs. Our software has the facility to give a unique id for every patient and

stores the details of every patient and the staff automatically. It includes a search

facility to know the current status of each room. User can search availability of a

doctor and the details of a patient using the id.

The Hospital Management System can be entered using a username and

password. It is accessible either by an administrator or receptionist. Only they can

add data into the database. The data can be retrieved easily. The interface is very

user-friendly. The data are well protected for personal use and makes the data

processing very fast.

5

TABLE OF CONTENT

Description

Page No

BONAFIE CERTIFICATE

03

ABSTRACT

04

Chapter 1 INTRODUCTION

07

1.1

Problem Definition

08

1.2

Requirement of Proposed System

10

1.3

System Analysis

12

1.4

Proposed System

14

Chapter 2 PROCESS DESCRIPTION

16

2.1

Doctor Module

16

2.2

Patient Module

18

2.3

Appointment Module

20

Chapter 3 PROGRAM DESIGN

22

6

examination held on __/_/___ at M.A.M. College of Engineering and