Online Patients Record Platform Using PHP
Online Patients Record Platform Using PHP
Online Patients Record Platform Using PHP
GENERAL INTRODUCTION
1.1 Introduction
The system will store inpatients and outpatient’s records, as well as other
relevant clinical information within the clinic. The system will be used by the
staff (Doctor Nurse, Clerks, Consultants and other relevant authorities as the
demand may be) within the clinic. It will process data speedily and accurately
provide information when and where required.
The clinical database system will be used to store data produce reports and
handle management inquiries. In clinics that are made up of Doctors, Nurse,
Patients and other personnel staff, an information system is required to keep
track of the day-to-day activities of the clinic and to improve the
communication skills. Also this system will help, in highlighting risk/complex
1
patients for consultant input alert of DNA; easily identify all patients taking
certain medications, monitor frequency of major complication e.g. peptic ulcer,
check for known drug interaction, and improve evidence based practice, record
questions.
Maternal and child health care dogon zare was established by late senator
Mamman B. Ali when he was governor of Yobe state on Tuesday 27 th may
2008. The scope of the service in the hospital is basically curative and
preventive and is offered in clinic unit x-ray/ ultra sound and laboratory in the
hospital. Other services include admission (ward) inpatient (where drugs are
issued), antenatal care, routing immunization, labor and delivery, HIV/AIDS
counseling, PMTC, CMAM, DOT, physiotherapy and family planning. The
hospital offers 24 hours services to its staff and the entire population. The
records of patients in the hospital have been using manual system. This led to
poor record keeping since it’s a paper based system. The reason why the
current system used is manual has led to a variety of problems and these
2
include; un necessary duplication of the data especially for inpatients and
outpatients, inconsistence may occur since data is held more than once and
hard to analyze the data hence difficult to trace the flow of patient past
medication data.
One of the unit of the std/aids control program (STD/HCP) a server doctor at
consultant level who is assisted by 3 doctors, a secretary, medical assistance,
nurses trained consolers and laboratory technologists head of units. The
3
various diseases managed at the unit include the following syphilis, molluscus,
scabies‟, pubic lice, gonorrhea, trichomoiasis, gentle mart etc.
The absence of a well established information system to serve patient and staff
has led to inconveniences. This has tantamount to the loss of patient and staff
records.
4
1.4 Objectives of the Study
1.5 Scope
This project is basically designed for Maternal and child health care dogon
zare hospital Potiskum. This hospital provides a lot of services to patients
which includes; Daily treatment of patients, Admission of patients, Keeps
records about inpatients and outpatients respectively. Other services with
departments that include radiography and ultra sound, pathology, pharmacy,
inpatient and outpatient, causality and dental which in information will be used
for making reports for researchers in various departments, drug/stock taking
unit at the central pharmacy and medical practitioners. The following are the
language confined within the system to enable development and
implementation.
i. The system is a land mark in the field of modern technology since its
automated it becomes a quick access to the required information as it is
only one click away.
ii. In the field of ICT, decision support and information availability which
is required by the administration. This is because it is able to generate
reports daily, monthly and yearly. This makes it simple for managers to
make decisions.
iii. Electronic security is maintained as the staff and management are able to
login and access the system depending on their privileges. They are also
able to work on the policies and claims more effectively and efficiently.
1.7 Methodology
The project is carried out following the appropriate stages involved in design
and development of clinical software. The stages are briefly discussed below.
6
iii. System modeling: Using relevant facts obtained from relevant sources,
the Clinical database system is designed.
iv. System Development and implementation: The conceptual design is
development and implemented as computer program. After the
development and implementation, the system is tested to ensure that it
fulfills the objectives of the project.
v. System installation: The developed clinical database system software is
installed on the computer system and made ready for use.
Hospital: is defined as the entity that provides the medical services to the
patient in questioned at a given period of time which is basically curative and
preventive and is offered in clinic unit x-ray/ ultra sound, laboratory and dental
unit in the hospital.
7
CHAPTER TWO
8
LITERATURE REVIEW
2.1 Introductions
In this chapter the researchers, location and analysis of the existing knowledge
related to the subject of inquiry are explored and cited. It also sells at the
relationship of the proposed research for purposes of good representation and
critical review of the existing literature.
9
following; order entry, service scheduling, treatment and other personal
staffing and scheduling.
ii. Control reporting and operating function: provides summarized data
about the operation of the organization to the manager and health care
professional that permits the monitoring of various activities. These
tasks include medical record tracking, medical audit and peer review.
iii. Strategic planning function: provides a frame work from decision
making with long range implications which include patient care strategy
like level of care, occupancy and service demand, requirement and
project cost.
Thus the patient management information system in this study ideally consists
of integrated approach to maintain patient related administrative and clinical
data considering the continuum of care dependent on the services provided.
Patient information system has benefits which accrue in the long run.
According to Wang (2003) the long term benefit of the health electronic record
(HER), the united states of used it to minimize a cost benefit per provider for
having used an (HER) system over a five (5) year period was estimated to be at
$87000 and $330900 over a ten (10) year period. The implementation of this
project was likely to reduce the cost in the long run.
Llan (2002) defined a medical record as confidential information kept for each
patient by heath care professional or organization. It contains the patients‟
personal details such as name, address, date of birth, a summary of the patient
medical history and documentation of each event including symptoms,
diagnosis, treatment and outcome. Relevant documents and correspondence are
also included. Traditionally, each healthcare provider involves in patient care
kept an independent record usually paper based, the main purpose of the
medical record of the summary of a person‟s conduct with the health care
provider and treatment provided to ensure appropriate health care, information
from medical record also provide essential data for monitoring patient care,
clinical audit and accessing patterns of care and services delivered. The
management information system enables the medical record to form a first link
in the information chain producing the depersonalized aggregated coded data
for statistical.
11
2.2.4 Related Case Study
In this project doctors are able to view patients’ medical records immediately at
their private offices using secure internet transmission. The project aimed at
increasing competitiveness of the medical profession by improving the
accuracy of medical records and efficient retrieval and usage of medical
records. Patient medical records are very critical for doctors to establish their
diagnosis, with detailed and on-hand patients’ medical records; doctors can
make appropriate medical decision efficiently. Security was a critical issue in
the storage and transferring of patient medical records between hospitals and
doctors‟ offices. All clients were authenticated with a patient identity number.
Paper based records are still by far the preferred method of recording patient
information for most hospitals and practices in the U.S. New England Journal
of Medicine, (March 25, 2009). The majority of doctors still find their ease of
12
data entry and low cost hard to part with. However, as easy as they are for the
doctor to record medical data at the point of care, they require a significant
amount of storage space compared to digital records. In the US, most states
require physical records be held for a minimum of seven years. The costs of
storage media, such as paper and film, per unit of information differ
dramatically from that of electronic storage media. When paper records are
stored in different locations, collating them to a single location for review by a
health care provider is time consuming and complicated, whereas the process
can be simplified with electronic records. This is particularly true in the case of
person-centered records, which are impractical to maintain if not electronic
(thus difficult to centralize or federate). When paperbased records are required
in multiple locations, copying, faxing, and transporting costs are significant
compared to duplication and transfer of digital records. Because of these many
"after entry" benefits, federal and state governments, insurance companies and
other large medical institutions are heavily promoting the adoption of
electronic medical records. Congress included a formula of both incentives (up
to $44K per physician under Medicare or up to $65K over 6 years, under
Medicaid) and penalties (i.e. decreased Medicare/Medicaid reimbursements for
covered patients to doctors who fail to use EMR's by 2015) for EMR/EHR
adoption versus continued use of paper records as part of the American
Recovery and Reinvestment Act of 2009.
14
2.4 Previous Studies from Maternal and child health care Dogon Zare
Hospital
Previously the hospital employees have been able to collect data from agents
by providing them with a piece of paper with required fields to fill. Its routine
for every health worker to collect data, this should be processed and stored
completely. They avail the right information and knowledge to the right person
and institution in the form at the right time and place. The information ranges
from individual patient reports to disease rebalance to mortality rate in the
right persons and institutions which include the counties that use the health
service, the service provider at local level, ministry of health and the donors.
The company's employees and patients are straining to process lots of policy
documents every day. Integrating and streamlining policy.
Streveler (2004) grouped the component making HIS into 2 which are
information processing and management. Information processing involves data
collection, transmission, processing, analysis and presentation of information
for use in patient care and health care management decisions. Health
management system cannot exist alone but as functional unit aimed at
improving the health of individuals and that of the community.
15
According to Gordon (2006), the following are what he identified as the
advantages of computers- base information system.
16
CHAPTER THREE
3.1 Introduction
i. Observation:
We went to the hospital and observed their daily as regards their current system
and they were manually recording the patients’ records as specified by the
receptionists, doctors and pharmacist. A follow up was made to determine the
time it took to carry out the patient record management. We observed the
system’s weaknesses like it was vulnerable to errors.
ii. Interviewing:
In this method, there was interaction between us, the researchers and the Staff.
Interviews were conducted with the medical supridendant and some potential
employees to find out what difficulties they encountered with the existing
system. These interviews were held to verify the information collected using
the questionnaires since there was room to search for further information
during the interview.
18
iii. Questionnaires
This describes the tools used to implement the graphical user interface and the
database. MySQL was used to create and connect relational tables to the
database. HTML was used to develop the graphical user interface (GUI).
Javascript was used to send queries to PHP without reloading the page, PHP
19
was used to process queries and request flash to integrate sounds and interfaces
was done to develop the model that meets all the requirements of this system.
This section describes what is evolves to come up with the system and how the
system works.
Front end: Html (hyper text makeup language) enable the construction of easy
and intuitive user interface for accessing the database and any browser can
display the html document.
Middle end: PHP enables links of the text entered in the created graphic user
interface to be sent to the database
Back end: Mysql its easy to use, inexpensive database language it can run on a
variety of operating system such as window,linux,unix.os/2 and others , its
secured with technical support widely available on the internet but most of all
it support large database.
CHAPTER FOUR
4.1 Introduction
20
This chapter describes the system analysis and design of the developed
patients’ record management system of the Maternal and child health care
Dogon-Zare Potiskum.
During data collection, we investigated and found out how the current system
operates, not only that but also tried out which problems are faced and how
best they can be settled. The users described some of the basic requirements of
the system this includes Add and Search of patients, register staff, update
patients’ records and View all types of reports.
After interpretation of the data, tables were drawn and process of data
determined to guide the researcher of the implementation stage of the project.
The tools, which were employed during this methodology stage, were mainly
tables, Data Flow Diagrams (DFDs). The design ensures that only allows
authorized users to access the systems’ information.
Only authorized user with the right user name and password has right to access
the services to particular department he or she intent to view. When wrong user
name and password is used the system rejects access to the services.
22
Figure 4.1 Login page
This page can only be shown when a valid username and password is entered
in the above form. The security protection has been added to redirect a user
when try to bypass the login form. The navigation links are given to allow staff
to add, edit and delete a patient when necessary, search patient by entering his
unique number, update staff information and view record of the previous
visited patients.
23
This is the most important page as it is the objective of this work, keeping
patients’ record. However we have to deal with some other facts. Hence they
are information to be used in filling a record of a specific patient. This record
can also be printed as a report.
The project does not only focus on storing patients’ record in a database, but it
also has the feature of giving out that stored information as hard copy for
reference purposes. The figure below indicates a patient’s card generated from
the platform which can be printed and used by the patients and the hospital’s
staffs.
24
Figure 4.4 Shows a patient’s card generated from patients
information stored in the database.
25
CHAPTER FIVE
5.1 Introduction
This chapter describes discuss the objectives of the system stipulated in earlier
chapter, Summary of the system conclusion and recommendation of the system
5.2 Summary
As discussed in the previous chapters the main problem that we addressed was
dealing with patient medical document. It is the above situation that drove us
to techniques of developing this Patient Record/Information Management
System to be used at Maternal and child health care dogon zare Potiskum to
enable them to handle details on policies efficiently and effectively. The project
has implemented Most of the objectives stipulated in earlier chapter. The
patient record management system offers a number of benefits to the user and
can capture data, store, view, add and delete the records entered the data can
also be posted information to the database. Problems Encountered during Data
collection: sensitive information released to us, few projects and books written
about patient records management system.
26
5.3 Conclusions
5.4 Recommendations
Training of all the members of the staff in the hospital to get accustomed to the
system will be a priority. This being a new system, some members of the staffs
management will get threatened that the computerized patient records
management system will replace their jobs .I would recommend that
management of the hospital educates the staff of how this system will operate
and how it will supplement their efforts .For the efficiency of the hospital,
users of the system need to be thoroughly educated about the use of the
27
passwords and staff name, not only that but also not to be careless of them.
They should be kept confidential. Access to the server room should be
physically guarded against unauthorized person; the server room should be
dust free and should be fully protected and should have an air conditioner to
prevent the server from overheating. Backup media like CDs, Diskettes and
Flush disks can be used for backups and storage of data.
During the course of this project, we were able to understand better what goes
in the patient records management system in the hospital. This was effectively
done through reading of literature and research. The whole process of
developing the system was an opportunistic challenge. Seeing the system into a
tangible system was a rewarding exercise.
28
REFERENCE
Arizona, R., (2011): Electronic Health Records, about $500 Million at stake
in digital move. England: Smith and Sons.
Habib, J.L,. (2010). EHRs, meaningful use, and a model EMR. Drug Benefit
Trends. May 2010; 22(4):99-101.
Hoffman, S., & Podgurski, A. (2008). "Finding a Cure; The Case for
Regulation and Oversight of Electronic Health Record Systems"
(PDF). Harvard Journal of Law & Technology
Robson, B., Baek, K. (2009). The Engines of Hippocrates. From the Dawn of
Medicine to Medical and Pharmaceutical Informatics. USA: JohnWiley
& Sons
Starmer. K., Bratan, T., Byrne, E., Russell, J., & Potts, H.W.W. (2010).
Adoption and non-adoption of a shared electronic summary care
record. England: John Wiley & Sons.
29
APPENDIX
<?php
require_once 'functions.php';
$usn_em = $usp = ""; ?>
<html lang="en"><head>
<title>HOSPITAL MANAGEMENT</title>
<?php include 'include'; ?></head>
<body>
<?php centered_logo(); ?>
<div class="formbox"><div id="ajax"></div>
<h2>Welcome...</h2><p class="error"></p>
<form method="post"><div class="field">
<i class="fa fa-user"></i> <label>Email... <span
class="req">*</span></label>
<input type="text" tabindex="1" autofocus required id="email"
name="email" value="<?= $usn_em; ?>"> </div><div class="field"><i
class="fa fa-lock"></i> <label>Password... <span
class="req">*</span></label>
<input type="password" tabindex="2" required id="pass" name="pass"
value="<?= $usp; ?>">
</div>
<div class="field"><input class="buttom" type="submit" value="Sign-in"
id="sign-in"></div>
<i class="fa fa-spinner"></i>
30
</form>
<span class="forgot"><a href="forgot.php">Forgot password</a></span>
</div></body>
</html><?php
require_once '../functions.php';
exit_non_logged();
is_installed();
if (isset($_GET['per_page']) && isset($_GET['page'])){
$per_page = $_GET['per_page'];
$page = $_GET['page'];
} else {
$per_page = 20;
$page = 1; } $START = $per_page * $page - $per_page;?>
elseif ($page < $pages){ $nxt = $page + 1; ?>
<div class="p"><a href="?page=<?= $nxt; ?>&per_page=<?=
$per_page; ?>">Next »»</a>
<?php } for ($p = 1; $p <= $pages; $p++){ ?>
<a href="?page=<?= $p; ?>&per_page=<?= $per_page; ?>"><?= $p; ?></a>
<?php } if ($page > 1){
$prv = $page - 1; ?>
<a href="?page=<?= $prv; ?>&per_page=<?= $per_page; ?
>">«« Previous</a>
<?php } ?> </div> </div></div></div> <?php include '../footer.php'; ?
></body></html>
31