1

HEALTHCARE WEBSITE
‘HMS’

MINOR PROJECT REPORT

MASTER OF COMPUTER APPLICATIONS (3rd SEMESTER)

SUBMITTED BY
ABHISHEK PRATAP SINGH
Batch Year -2023-25
Enrollment No- U2349002

PROJECT GUIDE- Mr. Rajendra Kr. Pandey

Centre of Computer Education & Training

Institute of Professional Studies
University of Allahabad, Prayagraj
Uttar Pradesh

CCET,IPS, University of Allahahabd

2

ACKNOWLEFGMENT

I would like to take this opportunity to express my gratitude to everyone who has supported
me in completing this project report. The completion of this project is no doubt a product of
invaluable support and the contribution of the number of people.

I would like to express our sincere gratitude to Professor Ashish Khare, the Co-ordinator of
the Centre of Computer Education and Training at the University of Allahabad.

Foremost, I would like to thank my project supervisor Mr. Rajendra Kr. Pandey (Centre of
Computer Education and Training, Institute of Professional Studies, University of Allahabad)
for their continuous help and valuable suggestions and providing encouraging environment,
without which our project and this documentation would not have been possible.

I am also grateful to my family and friends for their constant support and motivation, which
has kept me going throughout the project. Their belief in me and my abilities has been a
source of inspiration and encouragement.

Date: __/04/24 ABHISHEK PRATAP SINGH

Place: IPS, UoA, Prayagraj (Enrollment No. – U2349002)

CCET,IPS, University of Allahahabd

3

SELF- DECLARATION

I hereby declare that the project report entitled “HEALTHCARE HMS Website” is
submitted by me in the 3th semester of Master of Computer Application Centre of Computer
Education and Training, Institute of Professional Studies of University of Allahabad is the
record of my own work carried under the supervision and the guidance of Mr Rajendra kr.
Pandey.

All the information and data presented in the report are authentic and have been surely
acknowledged and this project work has not been submitted to ‘University of Allahabad’.

I confirm that all the sources consulted during the project have been duly acknowledged in
the reference section, and the report does not contain any plagiarized content. I understand
that any act of plagiarism, including copying or paraphrasing the work of others without
proper citation, is considered academic misconduct and can lead to severe penalties. I also
understand that any misrepresentation or falsification of information can lead to the
rejection of my project report and can affect my academic standing.

Date: __/04/24 ABHISHEK PRATAP SINGH

Place: IPS, UoA, Prayagraj (Enrollment No. – U2349002)

CCET,IPS, University of Allahahabd

4

CERTIFICATE

This is to certify that Abhishek Pratap Singh, student of the Master of Computer
Application (Semester – 3th) of the Centre of Computer Education and Training, Institute of
Professional Studies, University of Allahabad has completed his work in the project entitled
“ Healthcare Website (HMS)” under my guidance in the academic session (2023-24).

He has been taken proper care and shown utmost sincerity in completion of this project. I certify
that his work in this project as per the guidelines. This project is original and is never submitted
somewhere else for this same purpose.

Date: __/04/24 ABHISHEK PRATAP SINGH

Place: IPS, UoA, Prayagraj (Enrollment No. – U2349002)

CCET,IPS, University of Allahahabd

5

TABLE OF CONTENT

Table of Contents

S.No. Contents
1. Acknowledgement

2. SELF-Declaration

3. Certificate

4. Synopsis

5. Introduction

6. Problem defination

7. Motivation

8. Ojectives

9. Requirement Analysis

10. 1.1 Software Analysis

Hardware Analysis

11. Data flow diagram

12. Name of algorithm used

13. Project Report

14. Source Code

15. Conclusion

16. Milestone

17. Plagiarism Report

CCET,IPS, University of Allahahabd

6

SYNOPSIS

CCET,IPS, University of Allahahabd

7

TABLE OF CONTENTS

1. INTRODUCTION

1.1 Problem Definition

1.2 Motivation

2. OBJECTIVES

3. PROBLEM and SOLUTION

4. REQUIREMENT ANALYSIS

4.1 Interface Requirements Document

4.2 Software & Hardware Requirements

5. DFD (Data Flow Diagram)

6. NAME OF ALGORITHM

7. MILESTONE

8.MEETING WITH SUPERVISOR

CCET,IPS, University of Allahahabd

8

INTRODUCTION

Title - (Hospital Management System)

In today's fast-paced world, efficient management of healthcare facilities is
crucial to delivering high-quality patient care and ensuring smooth operational
workflows. “MedWeb” Hospital Management System (HMS) emerges as an
indispensable tool in modern healthcare, integrating various functions into a
unified platform to enhance the overall efficiency of hospital operations.
An HMS is designed to streamline and automate the diverse processes involved
in managing a hospital. From patient registration and appointment scheduling to
billing, inventory management, and staff coordination, an HMS addresses the
complexities of hospital administration with precision and ease. By centralizing
data and facilitating real-time access to critical information, this system not only
improves operational efficiency but also enhances patient satisfaction and safety.
With advanced features such as electronic medical records (EMR), patient
management, and data analytics, an HMS empowers healthcare providers to
make informed decisions, reduce errors, and optimize resource allocation. In
addition, it supports compliance with regulatory standards and provides a robust
platform for integrating with other healthcare systems and technologies.
As hospitals face increasing demands for quality care and operational excellence,
investing in a comprehensive Hospital Management System becomes a strategic
move to stay ahead in the competitive healthcare landscape. The HMS transforms
traditional hospital management practices, making them more effective,
transparent, and patient-centric.

CCET,IPS, University of Allahahabd

9

PROBLEM DEFINITION

Empowering Hospitals with Smart Solutions" PROBLEM and

SOLUTION
Effective hospital management is crucial for the delivery of high-quality patient
care and the smooth operation of healthcare facilities. However, many hospitals
face significant challenges due to poor management practices. This problem
manifests in several critical areas:
1. Problem: Inefficient Patient Flow
o Improvement: A good HMS can streamline patient scheduling and
appointment management, reducing wait times and optimizing
patient flow. Automated reminders and real-time updates help in
managing patient arrivals and minimizing delays in treatment.
2. Problem: Inaccurate and Fragmented Data
o Improvement: By integrating Electronic Medical Records (EMR)
and centralized data management, an HMS ensures that patient
information is accurate, complete, and accessible across
departments. This reduces errors and provides a comprehensive
view of patient history.
3. Problem: Resource Misallocation
o Improvement: An effective HMS provides real-time tracking of
medical supplies, equipment, and staff utilization. Inventory
management features and resource allocation tools help ensure that
resources are used efficiently, minimizing waste and shortages.
4. Problem: Financial Management Issues
o Improvement: Advanced billing and financial management
modules in an HMS facilitate accurate billing, transparent
financial tracking, and efficient claims processing. This helps in
managing revenue, controlling costs, and maintaining financial
health.
5. Problem: Inadequate Communication
o Improvement: An HMS enhances communication through
integrated messaging systems and collaborative tools. This ensures
seamless information flow between departments, staff, and
patients, improving coordination and reducing the risk of
miscommunication.
6. Problem: Compliance and Regulatory Challenges
o Improvement: A robust HMS helps hospitals adhere to regulatory
requirements by providing compliance tracking, documentation
management, and audit trails. This minimizes the risk of non-
compliance and ensures that the hospital meets industry standards.
7. Problem: Low Staff Morale and Productivity
o Improvement: By automating routine tasks and providing user-
friendly interfaces, an HMS reduces the administrative burden on

CCET,IPS, University of Allahahabd

10

staff. Enhanced workflow management and better access to

information contribute to higher staff satisfaction and productivity.
8. Problem: Ineffective Data Analytics
o Improvement: Modern HMS platforms come with advanced data
analytics and reporting capabilities. This enables hospitals to
generate insights on patient outcomes, operational performance,
and resource utilization, facilitating informed decision-making and
strategic planning.
9. Problem: Patient Satisfaction and Safety Concerns
o Improvement: With features like electronic health records, real-
time patient monitoring, and streamlined communication, an HMS
enhances patient safety and improves the overall patient
experience. Efficient management and accurate data contribute to
better care and higher patient satisfaction.
10. Problem: Difficulty in Scaling Operations
o Improvement: A scalable HMS allows hospitals to easily expand
their operations, add new services, and integrate with other
systems. This flexibility supports growth and adaptation to
changing healthcare needs.

CCET,IPS, University of Allahahabd

11

Motivation

A hospital management system is pivotal for advancing healthcare efficiency and

effectiveness. By automating and integrating various hospital functions—from
patient registration and medical records to billing and resource management—the
system minimizes administrative burdens and reduces the likelihood of errors.
This streamlined approach enables healthcare professionals to deliver higher-
quality care, improve patient outcomes, and manage resources more effectively.
Ultimately, the system enhances overall operational efficiency, ensuring a more
responsive and reliable healthcare environment.

CCET,IPS, University of Allahahabd

12

OBJECTIVES

Here are key objectives for a Hospital Management System (HMS):

1. Optimize Workflow Efficiency: Streamline hospital operations by
automating administrative tasks and integrating various functions.
2. Enhance Patient Care: Provide healthcare professionals with
comprehensive, realtime patient information to improve diagnosis,
treatment, and care coordination.
3. Ensure Accurate Record Keeping: Maintain precise, up-to-date patient
records for effective clinical decision-making and continuity of care.
4. Achieve Regulatory Compliance: Facilitate adherence to healthcare
regulations, including data privacy laws and billing standards.
5. Improve Financial Management: Manage billing, invoicing, and financial
reporting to reduce errors and enhance revenue cycle management.
6. Maximize Resource Utilization: Efficiently manage hospital resources,
including staff scheduling, equipment, and facility usage.
7. Support Data-Driven Insights: Provide analytics and reporting tools to
monitor performance, identify trends, and make informed decisions.
8. Enhance Communication: Foster seamless communication among
healthcare providers, departments, and patients.
9. Increase Patient Engagement: Empower patients with access to their
health information, appointment scheduling, and communication tools.
10. Ensure Scalability and Flexibility: Allow the system to adapt to changing
hospital needs and integrate new technologies as required.

CCET,IPS, University of Allahahabd

13

REQUIREMENT ANALYSIS

1. Introduction
• Purpose: Define the objectives, scope, and purpose of the HMS, including its impact
on hospital operations and patient care.
• Scope: Outline the boundaries of the HMS, including what functions it will cover and
any exclusions.
2. Stakeholder Identification

• Primary Users: Doctors, nurses, administrative staff, hospital management.

• Secondary Users: Patients, insurance companies, external healthcare providers.
• Regulatory Bodies: Compliance with healthcare regulations and standards.
3. Functional Requirements

• Patient Management o Registration and admission o Patient history and record

management o Appointment scheduling and management

• Clinical Management o Electronic Health Records (EHR) o Order management (tests,

medications) o Treatment and medication administration

• Billing and Financial Management o Patient billing and invoicing o Insurance

claim processing o Financial reporting and analytics

• Inventory Management o Medical supplies and equipment tracking o Stock level

monitoring and reordering

• Staff Management o Scheduling and payroll

o Credentialing and training

• Hospital Administration o Reporting and analytics o Compliance

management o Patient feedback and complaints management

4. Non-Functional Requirements
• Performance o System response time o Scalability to handle increasing loads

• Reliability o System uptime and backup procedures

• Security o Data encryption and access control o Compliance with data protection
regulations (e.g., HIPAA, GDPR)

• Usability o User-friendly interfaces for various stakeholders

• Interoperability o Integration with other systems (e.g., laboratory systems, external

databases)
5. System Architecture

CCET,IPS, University of Allahahabd

14

• Client-Server Architecture: Describe the architecture, including front-end interfaces,

back-end servers, and database systems.
• Data Storage: Database schema, data backup, and recovery procedures.

• Integration Points: APIs or interfaces for integrating with external systems.

6. Data Requirements
• Data Input: Types of data to be entered (e.g., patient information, test results).
• Data Output: Reports, analytics, and user interfaces.

• Data Security: Measures to protect sensitive information and ensure privacy.

7. User Interface Design
• User Roles: Define interfaces and access levels for different user roles (e.g., doctors,
nurses, administrative staff).
• Design Guidelines: Principles for designing intuitive and accessible interfaces.
8. Testing and Validation

• Testing Strategies: Unit testing, integration testing, system testing, and user acceptance
testing.
• Validation Criteria: Success criteria for system functionality, performance, and
security.
9. Deployment and Maintenance
• Deployment Plan: Steps for system rollout, including training and support.

• Maintenance Plan: Procedures for system updates, bug fixes, and ongoing support.
10. Documentation
• User Manuals: Guides for end-users on how to use the system.
• Technical Documentation: System design, architecture, and code documentation for
developers and IT staff.

11. Legal and Compliance Requirements

• Regulatory Compliance: Ensure the system meets all relevant healthcare regulations
and standards.
• Data Protection: Adhere to data protection laws and standards.
By thoroughly addressing these aspects, the HMS will be well-defined, functional, and aligned with
the needs of all stakeholders, leading to improved hospital management and patient care

CCET,IPS, University of Allahahabd

15

SOFTWARE ANALYSIS

Software Components:
1. Data Ingestion:
- Database: MySQL, PostgreSQL, or SQLite for persistent data storage.
- Web Server: Apache, Nginx, or similar web server to serve PHP pages
- Tools: visual studio code, xampp server
2. Frontend:
- HTML, CSS, java script

HARDWARE ANALYSIS

Processor - Intel Core i5(11th generation)

RAM - 8GB DDR4
Storage - 256 GB
GPU - Intel UHD Graphics 620
OS - Windows 11
Network Speed- 10 Mbps

CCET,IPS, University of Allahahabd

16

USE CASE DIAGRAM:

LEVEL-0

LEVEL-1

CCET,IPS, University of Allahahabd

17

Level 2:-

CCET,IPS, University of Allahahabd

18

NAME OF ALGORITHMS

Hospital management systems (HMS) can involve a variety of algorithms depending on the
specific needs of the system. Here are some key algorithms and techniques that might be used
in a comprehensive hospital management system:
1. Scheduling Algorithms:

o Round-Robin Scheduling: Used for managing patient appointments and staff

shifts.
o Priority Scheduling: For managing critical cases and prioritizing patients
based on urgency.
2. Patient Management Algorithms:
o Patient Flow Algorithms: Optimizing the movement and processing of
patients through various departments.
o Resource Allocation Algorithms: Ensuring that hospital resources (like beds
and equipment) are efficiently allocated.
3. Data Management:
o Database Management Systems (DBMS): Using algorithms for efficient data
retrieval, storage, and management (e.g., indexing, normalization).
4. Security and Privacy:

o Encryption Algorithms: For securing patient data and maintaining privacy

(e.g., AES, RSA).
o Access Control Algorithms: Managing permissions and access to sensitive
information.

CCET,IPS, University of Allahahabd

19

MILESTONE

Sr. No. Project Activity Estimated Start Estimated End

Date Date
1 Project allotment
2 Project layout

CCET,IPS, University of Allahahabd

20

MEETING WITH THE SUPERVISOR

Date of the Mode Comments by the Signature of the

meet supervisor Supervisor

CCET,IPS, University of Allahahabd

21

References

Python docs :
LINK: https://www.geeksforgeeks.org/php-programming-language-
tuto…

Machine learning docs:

LINK: Building a Hospital Management System Recommendation System
with Machine Learning (analyticsvidhya.com)

CCET,IPS, University of Allahahabd

22

PROJECT REPORT

CCET,IPS, University of Allahahabd

23

INTRODUCTION

A Hospital Management System (HMS) is a software solution designed to

help hospitals and healthcare facilities manage their operations efficiently.
It integrates various departments and functions of a hospital into a single,
centralized system, streamlining processes and improving overall
management.

CCET,IPS, University of Allahahabd

24

PROBLEM DEFINITION

Traditional hospital management often involves manual processes, paper-based

records, and disparate systems, leading to inefficiencies, errors, and delays in patient
care. This results in:
• Inefficient Operations: Manual tasks consume significant time and resources,
hindering productivity.
• Poor Patient Care: Delayed access to medical records, miscommunication, and
scheduling conflicts can negatively impact patient outcomes.
• Data Security Risks: Paper-based records are vulnerable to loss, damage, and
unauthorized access, compromising patient privacy.
• Difficulty in Decision Making: Lack of real-time data and analytics hinders
strategic planning and resource allocation.
• Increased Costs: Inefficient processes and manual errors can lead to higher
operational costs.

CCET,IPS, University of Allahahabd

25

Motivation

A Hospital Management System (HMS) is driven by a variety of motivations, primarily

focused on improving efficiency, patient care, and overall operational performance.
Here are some key motivations:
Improving Efficiency and Productivity:
• Automation of Routine Tasks: Automating routine tasks like appointment
scheduling, billing, and inventory management frees up staff time for more
critical duties.
• Reduced Paperwork: Digitalizing records and eliminating paper-based
processes reduces administrative overhead and storage costs.
• Streamlined Workflow: Integrating various departments and processes into a
single system enhances coordination and reduces bottlenecks.
• Faster Access to Information: Quick access to patient records, test results, and
medical history enables faster decision-making.

CCET,IPS, University of Allahahabd

26

OBJECTIVES

A Hospital Management System (HMS) is designed to achieve a variety of

objectives that ultimately aim to improve patient care, operational efficiency,
and financial performance. Here are the primary objectives:
Patient Care Objectives:
• Enhanced Patient Experience: Providing a seamless and positive patient
experience through efficient check-in/checkout, reduced wait times, and
personalized care.
• Improved Patient Safety: Minimizing medical errors by providing accurate
and up-to-date patient information to healthcare providers.
• Accurate and Timely Diagnosis: Facilitating timely and accurate diagnosis
through efficient access to medical records, test results, and consultation
reports.
• Effective Treatment Planning: Supporting effective treatment planning by
providing comprehensive patient information and treatment history.
Operational Efficiency Objectives:
• Streamlined Workflow: Automating routine tasks and streamlining
workflows to reduce administrative burden and improve productivity.
• Reduced Administrative Costs: Minimizing paperwork and manual
processes to reduce operational costs.
• Efficient Resource Utilization: Optimizing the utilization of resources such
as beds, staff, and equipment.
• Improved Decision-Making: Providing real-time data and analytics to
support informed decision-making.
Financial Performance Objectives:
• Increased Revenue: Improving revenue cycle management through
efficient billing and insurance claims processing.
• Reduced Costs: Minimizing operational costs by streamlining processes
and reducing errors.

CCET,IPS, University of Allahahabd

27

• Enhanced Financial Management: Providing better financial visibility and

control through accurate financial reporting.
Regulatory Compliance Objectives:
• Adherence to Standards: Ensuring compliance with healthcare regulations
and industry standards.
• Data Security and Privacy: Protecting patient data and maintaining
confidentiality.
By achieving these objectives, a Hospital Management System can significantly
contribute to the overall success of a healthcare organization

CCET,IPS, University of Allahahabd

28

GOALS

A Hospital Management System (HMS) is designed to achieve a variety of goals that

ultimately aim to improve patient care, operational efficiency, and financial
performance. Here are the primary goals:

Patient Care Goals:

• Enhanced Patient Experience: Providing a seamless and positive patient

experience through efficient check-in/checkout, reduced wait times, and
personalized care.

• Improved Patient Safety: Minimizing medical errors by providing accurate

and up-to-date patient information to healthcare providers.

• Accurate and Timely Diagnosis: Facilitating timely and accurate diagnosis

through efficient access to medical records, test results, and consultation
reports.

• Effective Treatment Planning: Supporting effective treatment planning by

providing comprehensive patient information and treatment history.

Operational Efficiency Goals:

• Streamlined Workflow: Automating routine tasks and streamlining

workflows to reduce administrative burden and improve productivity.

• Reduced Administrative Costs: Minimizing paperwork and manual

processes to reduce operational costs.

• Efficient Resource Utilization: Optimizing the utilization of resources such

as beds, staff, and equipment.

• Improved Decision-Making: Providing real-time data and analytics to

support informed decision-making.

CCET,IPS, University of Allahahabd

29

REQUIREMENT ANALYSIS

A comprehensive Hospital Management System (HMS) requires a thorough

analysis of the specific needs of a healthcare facility. Here's a breakdown of
the key functional and non-functional requirements:
Functional Requirements:
1. Patient Management:
o Patient Registration and Demographics
o Medical History and Allergies
o Appointment Scheduling
o Discharge Summary
o Insurance Information
2. Clinical Management:
o Electronic Health Records (EHR)
o Laboratory Information System (LIS)
o Radiology Information System (RIS)
o Pharmacy Management
o Telemedicine Integration
3. Financial Management:
o Billing and Invoicing
o Insurance Claims Processing
o Payment Gateway Integration
o Financial Reporting
4. Human Resource Management:
o Employee Information Management
o Payroll and Benefits
o Time and Attendance Tracking
o Performance Management
5. Inventory Management:
o Medical Supply Inventory
o Equipment Inventory
o Stock Alerts and Reordering
6.

CCET,IPS, University of Allahahabd

30

CCET,IPS, University of Allahahabd

31

CCET,IPS, University of Allahahabd

32

PROJECT FLOW

DATASET DATA MODEL

PREPROCESSING

WEBSITE

DEPLOYEMENT

CCET,IPS, University of Allahahabd

33

NAME OF ALGORITHMS
While a Hospital Management System (HMS) doesn't rely on a single,
overarching algorithm, it incorporates various algorithms and data
structures to efficiently manage its diverse functionalities. Here are
some common algorithms and data structures used in HMS:
1. Data Structures:
• Arrays: For storing lists of patients, appointments, or medical
records.
• Linked Lists: For managing dynamic data structures like
patient queues or medical test results.
• Trees: For hierarchical data structures like medical
classifications or organizational hierarchies.
• Hash Tables: For efficient data retrieval, such as patient lookup
by ID or name.
2. Algorithms:
• Search Algorithms:
o Linear Search: For simple searches within small datasets.
o Binary Search: For efficient searching in sorted arrays or
lists.
o Hashing: For rapid data retrieval based on keys.
• Sorting Algorithms:
o Bubble Sort: For simple sorting tasks.
o Insertion Sort: Efficient for small datasets or nearly
sorted data.
o Merge Sort: Efficient for large datasets.
o Quick Sort: Generally efficient for most datasets.
• Encryption Algorithms:
o AES: For encrypting sensitive patient data.

CCET,IPS, University of Allahahabd

34

o RSA: For secure communication and key exchange.

• Data Mining Algorithms:
o Decision Trees: For identifying patterns in medical data.
o Neural Networks: For complex pattern recognition and
prediction.
o Clustering Algorithms: For grouping similar patients or
medical conditions.

CCET,IPS, University of Allahahabd

35

SCREENSHOTS OF PROJECT OUTPUT

CCET,IPS, University of Allahahabd

36

CCET,IPS, University of Allahahabd

37

CCET,IPS, University of Allahahabd

38

CCET,IPS, University of Allahahabd

39

CCET,IPS, University of Allahahabd

40

SOURCE CODE

<?php

include_once('hms/include/config.php');

if(isset($_POST['submit']))

$name=$_POST['fullname'];

$email=$_POST['emailid'];

$mobileno=$_POST['mobileno'];

$dscrption=$_POST['description'];

$query=mysqli_query($con,"insert into
tblcontactus(fullname,email,contactno,message)
value('$name','$email','$mobileno','$dscrption')");

echo "<script>alert('Your information succesfully submitted');</script>";

echo "<script>window.location.href ='index.php'</script>";

} ?>

<!doctype html>

<html lang="en">

<head>

<meta charset="utf-8">

<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-

fit=no">

<title> Hospital management System </title>

<link rel="shortcut icon" href="assets/images/fav.jpg">

<link rel="stylesheet" href="assets/css/bootstrap.min.css">

CCET,IPS, University of Allahahabd

41

<link rel="stylesheet" href="assets/css/fontawsom-all.min.css">

<link rel="stylesheet" href="assets/css/animate.css">

<link rel="stylesheet" type="text/css" href="assets/css/style.css" />

</head>

<body>

<!-- ################# Header Starts Here#######################--->

<header id="menu-jk">

<div id="nav-head" class="header-nav">

<div class="container">

<div class="row">

<div class="col-lg-2 col-md-3 col-sm-12" style="color:#000;font-

weight:bold; font-size:42px; margin-top: 1% !important;">HMS

<a data-toggle="collapse" data-target="#menu" href="#menu" ><i

class="fas d-block d-md-none small-menu fa-bars"></i></a>

</div>

<div id="menu" class="col-lg-8 col-md-9 d-none d-md-block nav-item">

<ul>

<li><a href="#">Home</a></li>

<li><a href="#services">Services</a></li>

<li><a href="#about_us">About Us</a></li>

<li><a href="#gallery">Gallery</a></li>

<li><a href="#contact_us">Contact Us</a></li>

<li><a href="#logins">Logins</a></li>

</ul>

</div>

<div class="col-sm-2 d-none d-lg-block appoint">

CCET,IPS, University of Allahahabd

42

<a class="btn btn-success" href="hms/user-login.php">Book an

Appointment</a>

</div>

</div>

</div>

</div>

</header>

<!-- ################# Slider Starts Here#######################--->

<div class="slider-detail">

<div id="carouselExampleIndicators" class="carousel slide" data-ride="carousel"

data-interval="2000">

<ol class="carousel-indicators">

<li data-target="#carouselExampleIndicators" data-slide-to="0"

class="active"></li>

<li data-target="#carouselExampleIndicators" data-slide-to="1"></li>

<li data-target="#carouselExampleIndicators" data-slide-to="2"></li>

<li data-target="#carouselExampleIndicators" data-slide-to="3"></li>

</ol>

<div class="carousel-inner">

<div class="carousel-item ">

<img class="d-block w-100" src="assets/images/slider/h1.jpeg" alt="First

slide">

<div class="carousel-cover"></div>

<div class="carousel-caption vdg-cur d-none d-md-block">

<h5 class="animated bounceInDown">Hospital Management System</h5>

</div>

</div>

CCET,IPS, University of Allahahabd

43

<div class="carousel-item active">

<img class="d-block w-100" src="assets/images/slider/H2.jpg" alt="Second

slide">

<div class="carousel-cover"></div>

<div class="carousel-caption vdg-cur d-none d-md-block">

<h5 class="animated bounceInDown">Hospital Management System</h5>

</div>

</div>

<div class="carousel-item">

<img class="d-block w-100" src="assets/images/slider/H3.jpg" alt="Third

slide">

<div class="carousel-cover"></div>

<div class="carousel-caption vdg-cur d-none d-md-block">

<h5 class="animated bounceInDown">Hospital Management System</h5>

</div>

</div>

<div class="carousel-item">

<img class="d-block w-100" src="assets/images/slider/H4.jpg" alt="Fourth

slide">

<div class="carousel-cover"></div>

<div class="carousel-caption vdg-cur d-none d-md-block">

<h5 class="animated bounceInDown">Hospital Management System</h5>

</div>

</div>

</div>

CCET,IPS, University of Allahahabd

44

<a class="carousel-control-prev" href="#carouselExampleIndicators"

role="button" data-slide="prev">

<span class="carousel-control-prev-icon" aria-hidden="true"></span>

<span class="sr-only">Previous</span>

</a>

<a class="carousel-control-next" href="#carouselExampleIndicators"

role="button" data-slide="next">

<span class="carousel-control-next-icon" aria-hidden="true"></span>

<span class="sr-only">Next</span>

</a>

</div>

</div>

<!-- ************************* Logins ************************** -->

<section id="logins" class="our-blog container-fluid">

<div class="container">

<div class="inner-title">

<h2 style="font-size: 38px;font-family:times new roman; text-align: center; margin-

bottom: 20px;"><b>Logins</b></h2>

</div>

<div class="col-sm-12 blog-cont">

<div class="row no-margin">

<div class="col-sm-4 blog-smk">

<div class="blog-single">

CCET,IPS, University of Allahahabd

45

<img src="assets/images/new-user.jpg" height="200px" alt="">

<div class="blog-single-det">

<h6>Patient Login</h6>

<a href="hms/user-login.php" target="_blank">

<button class="btn btn-success btn-sm">Click Here</button>

</a>

</div>

</div>

</div>

<div class="col-sm-4 blog-smk">

<div class="blog-single">

<img src="assets/images/d1.jpg" alt="">

<div class="blog-single-det">

<h6>Doctors login</h6>

<a href="hms/doctor" target="_blank">

<button class="btn btn-success btn-sm">Click Here</button>

</a>

</div>

</div>

</div>

<div class="col-sm-4 blog-smk">

<div class="blog-single">

CCET,IPS, University of Allahahabd

46

<img src="assets/images/a1.jpg" height="200px" alt="">

<div class="blog-single-det">

<h6>Admin Login</h6>

<a href="hms/admin" target="_blank">

<button class="btn btn-success btn-sm">Click Here</button>

</a>

</div>

</div>

</div>

</div>

</div>

</div>

</section>

<!-- ################# Our Departments Starts Here#######################-

-->

<section id="services" class="key-features department">

<div class="container">

<div class="inner-title">

<h2>Our Key Features</h2>

<p>Explore some of our key features below</p>

</div>

CCET,IPS, University of Allahahabd

47

<div class="row">

<!-- Existing key features -->

<div class="col-lg-4 col-md-6">

<div class="single-key">

<i class="fas fa-heart"></i>

<h5>Cardiology</h5>

<p>Specialized care for heart-related issues.</p>

</div>

</div>

<div class="col-lg-4 col-md-6">

<div class="single-key">

<i class="fas fa-bone"></i>

<h5>Orthopaedic</h5>

<p>Comprehensive orthopedic services for bone health.</p>

</div>

</div>

<div class="col-lg-4 col-md-6">

<div class="single-key">

<i class="fas fa-brain"></i>

<h5>Neurology</h5>

<p>Expert care for neurological disorders.</p>

</div>

</div>

CCET,IPS, University of Allahahabd

48

<div class="col-lg-4 col-md-6">

<div class="single-key">

<i class="fas fa-pills"></i>

<h5>Pharma Pipeline</h5>

<p>Innovative pharmaceutical developments.</p>

</div>

</div>

<div class="col-lg-4 col-md-6">

<div class="single-key">

<i class="fas fa-user-md"></i>

<h5>Pharma Team</h5>

<p>Collaborative team dedicated to pharmaceutical advancements.</p>

</div>

</div>

<div class="col-lg-4 col-md-6">

<div class="single-key">

<i class="fas fa-medkit"></i>

<h5>High-Quality Treatments</h5>

<p>Providing top-notch medical treatments for your well-being.</p>

</div>

</div>

<!-- Additional key features -->

<div class="col-lg-4 col-md-6">

<div class="single-key">

CCET,IPS, University of Allahahabd

49

<i class="fas fa-dna"></i>

<h5>Genetics</h5>

<p>Exploring genetic solutions for personalized healthcare.</p>

</div>

</div>

<div class="col-lg-4 col-md-6">

<div class="single-key">

<i class="fas fa-tooth"></i>

<h5>Dentistry</h5>

<p>Comprehensive dental care for a healthy smile.</p>

</div>

</div>

<div class="col-lg-4 col-md-6">

<div class="single-key">

<i class="fas fa-microscope"></i>

<h5>Research & Development</h5>

<p>Advancing healthcare through cutting-edge research.</p>

</div>

</div>

</div>

</div>

</section>

<!-- ************************* About Us Starts Here

************************** -->

CCET,IPS, University of Allahahabd

50

<section id="about_us" class="about-us">

<div class="row no-margin">

<div class="col-sm-6 image-bg no-padding">

</div>

<div class="col-sm-6 abut-yoiu">

<h3>About Our Hospital</h3>

<?php

$ret=mysqli_query($con,"select * from tblpage where PageType='aboutus' ");

while ($row=mysqli_fetch_array($ret)) {

?>

<p><?php echo $row['PageDescription'];?>.</p><?php } ?>

</div>

</div>

</section>

<!-- ************************* Gallery Starts Here

************************** -->

<div id="gallery" class="gallery">

<div class="container">

<div class="inner-title">

<h2>Our Gallery</h2>

<p>View Our Gallery</p>

</div>

CCET,IPS, University of Allahahabd

51

<div class="row">

<div class="gallery-filter d-none d-sm-block">

<button class="btn btn-default filter-button" data-filter="all">All</button>

<button class="btn btn-default filter-button" data-

filter="hdpe">Dental</button>

<button class="btn btn-default filter-button" data-

filter="sprinkle">Cardiology</button>

<button class="btn btn-default filter-button" data-

filter="spray">Neurology</button>

<button class="btn btn-default filter-button" data-

filter="irrigation">Laboratory</button>

</div>

<br/>

<div class="gallery_product col-lg-4 col-md-4 col-sm-4 col-xs-6 filter hdpe">

<img src="assets/images/gallery/gallery_01.jpg" class="img-responsive">

</div>

<div class="gallery_product col-lg-4 col-md-4 col-sm-4 col-xs-6 filter hdpe">

<img src="assets/images/gallery/gallery_03.jpg" class="img-responsive">

</div>

<div class="gallery_product col-lg-4 col-md-4 col-sm-4 col-xs-6 filter hdpe">

<img src="assets/images/gallery/d1.jpg" class="img-responsive">

</div>

<div class="gallery_product col-lg-4 col-md-4 col-sm-4 col-xs-6 filter hdpe">

<img src="assets/images/gallery/d2.jpg" class="img-responsive">

</div>

CCET,IPS, University of Allahahabd

52

<!-- Add two more images to the Cardiology section -->

<div class="gallery_product col-lg-4 col-md-4 col-sm-4 col-xs-6 filter

sprinkle">

<img src="assets/images/gallery/h1.jpg" class="img-responsive">

</div>

<div class="gallery_product col-lg-4 col-md-4 col-sm-4 col-xs-6 filter

sprinkle">

<img src="assets/images/gallery/h2.jpg" class="img-responsive">

</div>

<div class="gallery_product col-lg-4 col-md-4 col-sm-4 col-xs-6 filter

sprinkle">

<img src="assets/images/gallery/h3.jpg" class="img-responsive">

</div>

<div class="gallery_product col-lg-4 col-md-4 col-sm-4 col-xs-6 filter

sprinkle">

<img src="assets/images/gallery/h4.jpg" class="img-responsive">

</div>

<div class="gallery_product col-lg-4 col-md-4 col-sm-4 col-xs-6 filter

irrigation">

<img src="assets/images/gallery/gallery_13.jpg" class="img-responsive">

</div>

<div class="gallery_product col-lg-4 col-md-4 col-sm-4 col-xs-6 filter

irrigation">

CCET,IPS, University of Allahahabd

53

<img src="assets/images/gallery/gallery_14.jpg" class="img-responsive">

</div>

<div class="gallery_product col-lg-4 col-md-4 col-sm-4 col-xs-6 filter

irrigation">

<img src="assets/images/gallery/gallery_15.jpg" class="img-responsive">

</div>

<div class="gallery_product col-lg-4 col-md-4 col-sm-4 col-xs-6 filter spray">

<img src="assets/images/gallery/gallery_05.jpg" class="img-responsive">

</div>

<div class="gallery_product col-lg-4 col-md-4 col-sm-4 col-xs-6 filter spray">

<img src="assets/images/gallery/gallery_06.jpg" class="img-responsive">

</div>

</div>

</div>

</div>

<!-- ######## Gallery End ####### -->

<!-- ************************* Contact Us Starts Here

************************** -->

<style>

#contact_us {

background-color: #f8f8f8;

padding: 50px 0;

.contact-us-single {

CCET,IPS, University of Allahahabd

54

text-align: center;

font-family: 'Open Sans', sans-serif;

.cop-ck {

background-color: #fff;

padding: 30px;

border-radius: 8px;

box-shadow: 0 0 20px rgba(0, 0, 0, 0.1);

.form-control {

width: 100%;

padding: 12px;

margin: 12px 0;

box-sizing: border-box;

border: 1px solid #ccc;

border-radius: 6px;

font-family: 'Open Sans', sans-serif;

h2 {

color: #333;

font-weight: bold;

margin-bottom: 20px;

font-size: 28px;

CCET,IPS, University of Allahahabd

55

label {

font-weight: bold;

margin-bottom: 10px;

display: block;

font-size: 16px;

textarea {

width: 100%;

padding: 12px;

margin: 12px 0;

box-sizing: border-box;

border: 1px solid #ccc;

border-radius: 6px;

resize: vertical;

font-family: 'Open Sans', sans-serif;

button {

background-color: #28a745;

color: #fff;

padding: 15px 30px;

border: none;

border-radius: 8px;

cursor: pointer;

font-size: 18px;

CCET,IPS, University of Allahahabd

56

font-weight: bold;

button:hover {

background-color: #218838;

</style>

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Open+Sans">

<section id="contact_us" class="contact-us-single">

<div class="row no-margin">

<div class="col-sm-12 cop-ck">

<form method="post" id="contactForm">

<h2>Contact Form</h2>

<div class="row cf-ro">

<div class="col-sm-3"><label for="fullname">Enter Name:</label></div>

<div class="col-sm-8"><input type="text" id="fullname"

placeholder="Enter Name" name="fullname" class="form-control input-sm"
required></div>

</div>

<div class="row cf-ro">

<div class="col-sm-3"><label for="emailid">Email

Address:</label></div>

<div class="col-sm-8"><input type="email" id="emailid" name="emailid"

placeholder="Enter Email Address" class="form-control input-sm" required></div>

</div>

<div class="row cf-ro">

CCET,IPS, University of Allahahabd

57

<div class="col-sm-3"><label for="mobileno">Mobile

Number:</label></div>

<div class="col-sm-8"><input type="tel" id="mobileno" name="mobileno"

placeholder="Enter Mobile Number" class="form-control input-sm" required></div>

</div>

<div class="row cf-ro">

<div class="col-sm-3"><label for="description">Enter

Message:</label></div>

<div class="col-sm-8">

<textarea rows="5" id="description" placeholder="Enter Your Message"

class="form-control input-sm" name="description" required></textarea>

</div>

</div>

<div class="row cf-ro">

<div class="col-sm-3"><label></label></div>

<div class="col-sm-8">

<button class="btn btn-success btn-sm" type="submit"

name="submit">Send Message</button>

</div>

</div>

</form>

</div>

</div>

</section>

<!-- ################# Footer Starts Here#######################--->

<footer class="footer">

<div class="container">

<div class="row">

CCET,IPS, University of Allahahabd

58

<div class="col-md-6 col-sm-12">

<h2 style="color: white; font-family: 'Times New Roman', Times, serif;">Useful

Links</h2>

<ul class="list-unstyled link-list">

<li><a ui-sref="about" href="#about_us">About us</a><i class="fa fa-angle-

right"></i></li>

<li><a ui-sref="portfolio" href="#services">Services</a><i class="fa fa-angle-

right"></i></li>

<li><a ui-sref="products" href="#logins">Logins</a><i class="fa fa-angle-

right"></i></li>

<li><a ui-sref="gallery" href="#gallery">Gallery</a><i class="fa fa-angle-

right"></i></li>

<li><a ui-sref="contact" href="#contact">Contact us</a><i class="fa fa-angle-

right"></i></li>

</ul>

</div>

<div class="col-md-6 col-sm-12 map-img">

<h2 style="font-family: 'Times New Roman', Times, serif; color: white;

text-decoration: underline;"><b>Contact Us</b></h2>

<address class="md-margin-bottom-40">

<?php

$ret=mysqli_query($con,"select * from tblpage where PageType='contactus' ");

while ($row=mysqli_fetch_array($ret)) {

?>

<?php echo $row['PageDescription'];?> <br>

Phone: <?php echo $row['MobileNumber'];?> <br>

Email: <a href="mailto:<?php echo $row['Email'];?>"

class=""><?php echo $row['Email'];?></a><br>

Timing: <?php echo $row['OpenningTime'];?>

CCET,IPS, University of Allahahabd

59

</address>

<?php } ?>

</div>

</div>

</div>

</footer>

<div class="copy" style="text-align: right; font-family: 'Times New Roman', Times,

serif;">

<div class="container">

<b> Hospital Management System | It's Me </b>

</div>

</div>

</body>

<script src="assets/js/jquery-3.2.1.min.js"></script>

<script src="assets/js/popper.min.js"></script>

<script src="assets/js/bootstrap.min.js"></script>

<script src="assets/plugins/scroll-nav/js/jquery.easing.min.js"></script>

<script src="assets/plugins/scroll-nav/js/scrolling-nav.js"></script>

<script src="assets/plugins/scroll-fixed/jquery-scrolltofixed-min.js"></script>

<script src="assets/js/script.js"></script>

</html>

CCET,IPS, University of Allahahabd

60

Database creation

-- phpMyAdmin SQL Dump

-- version 5.2.1

-- https://www.phpmyadmin.net/

--

-- Host: 127.0.0.1

-- Generation Time: Mar 02, 2024 at 03:09 PM

-- Server version: 10.4.32-MariaDB

-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

START TRANSACTION;

SET time_zone = "+00:00";

/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIE
NT */;

/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RE
SULTS */;

/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECT
ION */;

/*!40101 SET NAMES utf8mb4 */;

CCET,IPS, University of Allahahabd

61

--

-- Database: `hms`

--

-- --------------------------------------------------------

--

-- Table structure for table `admin`

--

CREATE TABLE `admin` (

`id` int(11) NOT NULL,

`username` varchar(255) NOT NULL,

`password` varchar(255) NOT NULL,

`updationDate` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1

COLLATE=latin1_swedish_ci;

--

-- Dumping data for table `admin`

--

INSERT INTO `admin` (`id`, `username`, `password`, `updationDate`)

VALUES

(1, 'admin', 'Karthi@19', '26-01-2024 08:41:10 AM');

CCET,IPS, University of Allahahabd

62

-- --------------------------------------------------------

--

-- Table structure for table `appointment`

--

CREATE TABLE `appointment` (

`id` int(11) NOT NULL,

`doctorSpecialization` varchar(255) DEFAULT NULL,

`doctorId` int(11) DEFAULT NULL,

`userId` int(11) DEFAULT NULL,

`consultancyFees` int(11) DEFAULT NULL,

`appointmentDate` varchar(255) DEFAULT NULL,

`appointmentTime` varchar(255) DEFAULT NULL,

`postingDate` timestamp NULL DEFAULT current_timestamp(),

`userStatus` int(11) DEFAULT NULL,

`doctorStatus` int(11) DEFAULT NULL,

`updationDate` timestamp NULL DEFAULT NULL ON UPDATE

current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=latin1

COLLATE=latin1_swedish_ci;

--

-- Dumping data for table `appointment`

CCET,IPS, University of Allahahabd

63

--

INSERT INTO `appointment` (`id`, `doctorSpecialization`, `doctorId`,

`userId`, `consultancyFees`, `appointmentDate`, `appointmentTime`,
`postingDate`, `userStatus`, `doctorStatus`, `updationDate`) VALUES

(1, 'ENT', 1, 1, 500, '2022-11-10', '12:45 PM', '2022-11-06 12:21:48', 1, 0,

'2022-11-06 12:23:35'),

(2, 'ENT', 1, 2, 500, '2022-11-17', '7:00 PM', '2022-11-06 13:16:18', 1, 1,

NULL),

(3, 'Dental Care', 13, 4, 1000, '2024-01-26', '8:30 AM', '2024-01-26

02:56:17', 1, 1, NULL);

-- --------------------------------------------------------

--

-- Table structure for table `doctors`

--

CREATE TABLE `doctors` (

`id` int(11) NOT NULL,

`specilization` varchar(255) DEFAULT NULL,

`doctorName` varchar(255) DEFAULT NULL,

`address` longtext DEFAULT NULL,

`docFees` varchar(255) DEFAULT NULL,

`contactno` bigint(11) DEFAULT NULL,

`docEmail` varchar(255) DEFAULT NULL,

CCET,IPS, University of Allahahabd

64

`password` varchar(255) DEFAULT NULL,

`creationDate` timestamp NULL DEFAULT current_timestamp(),

`updationDate` timestamp NULL DEFAULT NULL ON UPDATE

current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=latin1

COLLATE=latin1_swedish_ci;

--

-- Dumping data for table `doctors`

--

INSERT INTO `doctors` (`id`, `specilization`, `doctorName`, `address`,

`docFees`, `contactno`, `docEmail`, `password`, `creationDate`,
`updationDate`) VALUES

(4, 'Allergists/Immunologists', 'Vivek', 'Kaveripura Kamakshipalya', '500',

7485963210, '[email protected]',
'b6b3278e009d18e777ab00df3f07b35a', '2024-01-26 02:06:29', NULL),

(5, 'Anesthesiologists', 'Sumanth Shetty', '18, 1st Main, Koramangala 1st

Block, Jakkasandra Extension', '300', 7452103689,
'[email protected]', '3951eef4d6486efb865b6aa12dd83957', '2024-01-
26 02:12:38', NULL),

(6, 'Cardiologists', 'Mohan', '111, 4th Main, Landmark: Kalki Dhyana

Mandir, Bangalore', '500', 8769412503, '[email protected]',
'46e7520c8b2e2cdb4b33cba2e1e47fea', '2024-01-26 02:14:33', NULL),

(7, 'Critical Care Medicine Specialists', 'Baswaraj Biradar', 'Number 864,

Prakriti, D Block, 60 Feet Road', '400', 9847521603,
'[email protected]', 'd7b110d5d687208c155bb820e5dd6c3a', '2024-
01-26 02:16:59', NULL),

CCET,IPS, University of Allahahabd

65

(8, 'Dermatologists', 'Shilpa', '157/1, Gaurav Building, Landmark:

Manipal County Road', '400', 7475210369, '[email protected]',
'176725b568a33f4111a04bb0e6b8e631', '2024-01-26 02:19:46', NULL),

(9, 'Endocrinologists', 'Aditi Garg', 'HSR Layout', '500', 8574960213,

'[email protected]', '49204a41aaa14b9b16e307736dc98a80', '2024-01-26
02:33:13', NULL),

(10, 'Family Physicians', 'Archana S', '#764/1, Vishal Tower,19th Main,

2nd Sector, HSR Layout', '350', 9988774455, '[email protected]',
'cbe5803e46c2de9fbcdd33b1e95a23d2', '2024-01-26 02:35:17', NULL),

(11, 'Nephrologists', 'Santosh B S', '157/1, Gaurav Building, Landmark:

Manipal County Road', '450', 8574960213, '[email protected]',
'11953f2acf3bed074f6dea1252d1a00f', '2024-01-26 02:36:50', NULL),

(12, 'Neurologists', 'Chaitra Nayak', '110/4, Rebus Realam ,Neeladri Main

Road, Doddathoguru, Bangalore', '700', 8769412503,
'[email protected]', 'fd5de215639bc55880e3f8b5b5f0b8a5', '2024-01-
26 02:38:37', NULL),

(13, 'Dental Care', 'Karthik', 'Kamakshipalya', '1000', 7483968541,

'[email protected]', 'caf0d9771459a47169a2fcc45700c430', '2024-01-
26 02:48:48', NULL),

(14, 'ENT', 'M J Murali', '545, Binnamangala 1st Stage , CMH Road',
'500', 9847521603, '[email protected]',
'b2b9bd4bf8636e3acaed80c613109044', '2024-01-26 02:51:24', NULL);

-- --------------------------------------------------------

--

-- Table structure for table `doctorslog`

--

CREATE TABLE `doctorslog` (

CCET,IPS, University of Allahahabd

66

`id` int(11) NOT NULL,

`uid` int(11) DEFAULT NULL,

`username` varchar(255) DEFAULT NULL,

`userip` binary(16) DEFAULT NULL,

`loginTime` timestamp NULL DEFAULT current_timestamp(),

`logout` varchar(255) DEFAULT NULL,

`status` int(11) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1

COLLATE=latin1_swedish_ci;

--

-- Dumping data for table `doctorslog`

--

INSERT INTO `doctorslog` (`id`, `uid`, `username`, `userip`,

`loginTime`, `logout`, `status`) VALUES

(27, 4, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-01-26 02:07:29', '26-01-2024 08:36:00 AM', 1),

(28, 13, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-01-26 02:53:21', NULL, 1),

(29, 13, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-01-26 02:56:58', NULL, 1),

(30, 13, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-01-26 03:06:17', NULL, 1),

(31, 13, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-01-26 03:18:44', '26-01-2024 08:48:48 AM', 1),

CCET,IPS, University of Allahahabd

67

(32, 13, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-03-01 02:31:53', NULL, 1);

-- --------------------------------------------------------

--

-- Table structure for table `doctorspecilization`

--

CREATE TABLE `doctorspecilization` (

`id` int(11) NOT NULL,

`specilization` varchar(255) DEFAULT NULL,

`creationDate` timestamp NULL DEFAULT current_timestamp(),

`updationDate` timestamp NULL DEFAULT NULL ON UPDATE

current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=latin1

COLLATE=latin1_swedish_ci;

--

-- Dumping data for table `doctorspecilization`

--

INSERT INTO `doctorspecilization` (`id`, `specilization`, `creationDate`,

`updationDate`) VALUES

(18, 'Allergists/Immunologists', '2024-01-26 02:00:43', NULL),

(19, 'Anesthesiologists', '2024-01-26 02:00:52', NULL),

CCET,IPS, University of Allahahabd

68

(20, 'Cardiologists', '2024-01-26 02:01:02', NULL),

(21, 'Critical Care Medicine Specialists', '2024-01-26 02:01:24', NULL),

(22, 'Dermatologists', '2024-01-26 02:01:33', NULL),

(23, 'Endocrinologists', '2024-01-26 02:01:47', NULL),

(24, 'Family Physicians', '2024-01-26 02:01:57', NULL),

(25, 'Nephrologists', '2024-01-26 02:02:16', NULL),

(26, 'Neurologists', '2024-01-26 02:02:33', NULL),

(27, 'Dental Care', '2024-01-26 02:03:16', NULL),

(28, 'ENT', '2024-01-26 02:03:23', NULL);

-- --------------------------------------------------------

--

-- Table structure for table `tblcontactus`

--

CREATE TABLE `tblcontactus` (

`id` int(11) NOT NULL,

`fullname` varchar(255) DEFAULT NULL,

`email` varchar(255) DEFAULT NULL,

`contactno` bigint(12) DEFAULT NULL,

`message` mediumtext DEFAULT NULL,

`PostingDate` timestamp NULL DEFAULT current_timestamp(),

`AdminRemark` mediumtext DEFAULT NULL,

CCET,IPS, University of Allahahabd

69

`LastupdationDate` timestamp NULL DEFAULT NULL ON UPDATE

current_timestamp(),

`IsRead` int(11) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1

COLLATE=latin1_swedish_ci;

--

-- Dumping data for table `tblcontactus`

--

INSERT INTO `tblcontactus` (`id`, `fullname`, `email`, `contactno`,

`message`, `PostingDate`, `AdminRemark`, `LastupdationDate`,
`IsRead`) VALUES

(1, 'Anuj kumar', '[email protected]', 1425362514, 'This is for testing

purposes. This is for testing purposes.This is for testing purposes.This is
for testing purposes.This is for testing purposes.This is for testing
purposes.This is for testing purposes.This is for testing purposes.This is
for testing purposes.', '2022-10-30 16:52:03', NULL, NULL, NULL),

(2, 'Anuj kumar', '[email protected]', 1111122233, 'This is for testing',

'2022-11-06 13:13:41', 'Contact the patient', '2022-11-06 13:13:57', 1),

(3, 'Testing', '[email protected]', 8596320147, 'This is a message to

check ', '2024-03-01 01:50:44', 'Solevd', '2024-03-01 01:51:09', 1);

-- --------------------------------------------------------

--

-- Table structure for table `tblmedicalhistory`

--

CCET,IPS, University of Allahahabd

70

CREATE TABLE `tblmedicalhistory` (

`ID` int(10) NOT NULL,

`PatientID` int(10) DEFAULT NULL,

`BloodPressure` varchar(200) DEFAULT NULL,

`BloodSugar` varchar(200) NOT NULL,

`Weight` varchar(100) DEFAULT NULL,

`Temperature` varchar(200) DEFAULT NULL,

`MedicalPres` mediumtext DEFAULT NULL,

`CreationDate` timestamp NOT NULL DEFAULT current_timestamp()

ON UPDATE current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=latin1

COLLATE=latin1_swedish_ci;

--

-- Dumping data for table `tblmedicalhistory`

--

INSERT INTO `tblmedicalhistory` (`ID`, `PatientID`, `BloodPressure`,

`BloodSugar`, `Weight`, `Temperature`, `MedicalPres`, `CreationDate`)
VALUES

(1, 1, '80/120', '120', '85', '98', 'Test', '2022-11-06 13:19:41'),

(2, 3, '20', '30', '40', '60', 'Normal', '2024-01-26 03:03:22'),

(3, 5, '70/80', '50', '65', '60', 'Normal', '2024-03-01 02:33:24');

-- --------------------------------------------------------

CCET,IPS, University of Allahahabd

71

--

-- Table structure for table `tblpage`

--

CREATE TABLE `tblpage` (

`ID` int(10) NOT NULL,

`PageType` varchar(200) DEFAULT NULL,

`PageTitle` varchar(200) DEFAULT NULL,

`PageDescription` mediumtext DEFAULT NULL,

`Email` varchar(120) DEFAULT NULL,

`MobileNumber` bigint(10) DEFAULT NULL,

`UpdationDate` timestamp NULL DEFAULT current_timestamp(),

`OpenningTime` varchar(255) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

COLLATE=utf8mb4_general_ci;

--

-- Dumping data for table `tblpage`

--

INSERT INTO `tblpage` (`ID`, `PageType`, `PageTitle`,

`PageDescription`, `Email`, `MobileNumber`, `UpdationDate`,
`OpenningTime`) VALUES

(1, 'aboutus', 'About Us', '<ul style=\"padding: 0px; margin-right: 0px;

margin-bottom: 1.313em; margin-left: 1.655em;\" times=\"\" new=\"\"

CCET,IPS, University of Allahahabd

72

roman\";=\"\" font-size:=\"\" 14px;=\"\" text-align:=\"\" center;=\"\"

background-color:=\"\" rgb(255,=\"\" 246,=\"\" 246);\"=\"\"><li
style=\"text-align: left;\"><font color=\"#000000\">The Hospital
Management System (HMS) is designed for Any Hospital to replace their
existing manual, paper based system. The new system is to control the
following information; patient information, room availability, staff and
operating room schedules, and patient invoices. These services are to be
provided in an efficient, cost effective manner, with the goal of reducing
the time and resources currently required for such tasks.</font></li><li
style=\"text-align: left;\"><font color=\"#000000\">A significant part of
the operation of any hospital involves the acquisition, management and
timely retrieval of great volumes of information. This information
typically involves; patient personal information and medical history, staff
information, room and ward scheduling, staff scheduling, operating
theater scheduling and various facilities waiting lists. All of this
information must be managed in an efficient and cost wise fashion so that
an institution\'s resources may be effectively utilized HMS will automate
the management of the hospital making it more efficient and error free. It
aims at standardizing data, consolidating data ensuring data integrity and
reducing inconsistencies.&nbsp;</font></li></ul>', NULL, NULL,
'2020-05-20 07:21:52', NULL),

(2, 'contactus', 'Contact Details', '#19 12th A cross Kaveripura

Kamakshipalya Bangalore 560079', '[email protected]', 9841253067,
'2020-05-20 07:24:07', '9 am To 8 Pm');

-- --------------------------------------------------------

--

-- Table structure for table `tblpatient`

--

CREATE TABLE `tblpatient` (

CCET,IPS, University of Allahahabd

73

`ID` int(10) NOT NULL,

`Docid` int(10) DEFAULT NULL,

`PatientName` varchar(200) DEFAULT NULL,

`PatientContno` bigint(10) DEFAULT NULL,

`PatientEmail` varchar(200) DEFAULT NULL,

`PatientGender` varchar(50) DEFAULT NULL,

`PatientAdd` mediumtext DEFAULT NULL,

`PatientAge` int(10) DEFAULT NULL,

`PatientMedhis` mediumtext DEFAULT NULL,

`CreationDate` timestamp NULL DEFAULT current_timestamp(),

`UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE

current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=latin1

COLLATE=latin1_swedish_ci;

--

-- Dumping data for table `tblpatient`

--

INSERT INTO `tblpatient` (`ID`, `Docid`, `PatientName`,

`PatientContno`, `PatientEmail`, `PatientGender`, `PatientAdd`,
`PatientAge`, `PatientMedhis`, `CreationDate`, `UpdationDate`)
VALUES

(2, 13, 'Abhishek', 7485962013, '[email protected]', 'male',

'Kamaksipalya', 21, 'Normal', '2024-01-26 02:54:10', NULL),

(3, 4, 'Raju', 7485120396, '[email protected]', 'male', 'bangalore', 20,

'Normal', '2024-01-26 03:02:30', NULL),

CCET,IPS, University of Allahahabd

74

(4, 4, 'anjan', 7485962013, '[email protected]', 'male', 'bangalore', 20,

'normal', '2024-01-26 03:08:08', NULL),

(5, 13, 'Divya', 8596742103, '[email protected]', 'female', 'Bangalore',

20, 'Nothing', '2024-03-01 02:32:39', NULL);

-- --------------------------------------------------------

--

-- Table structure for table `userlog`

--

CREATE TABLE `userlog` (

`id` int(11) NOT NULL,

`uid` int(11) DEFAULT NULL,

`username` varchar(255) DEFAULT NULL,

`userip` binary(16) DEFAULT NULL,

`loginTime` timestamp NULL DEFAULT current_timestamp(),

`logout` varchar(255) DEFAULT NULL,

`status` int(11) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1

COLLATE=latin1_swedish_ci;

--

-- Dumping data for table `userlog`

--

CCET,IPS, University of Allahahabd

75

INSERT INTO `userlog` (`id`, `uid`, `username`, `userip`, `loginTime`,

`logout`, `status`) VALUES

(5, 1, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-01-23 14:52:07', '01-03-2024 08:06:57 AM', 1),

(6, 3, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-01-23 14:53:50', '23-01-2024 08:24:06 PM', 1),

(7, NULL, 'Prashanth', 0x3a3a3100000000000000000000000000, '2024-

01-23 14:54:22', NULL, 0),

(8, 3, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-01-23 14:54:29', '23-01-2024 08:24:36 PM', 1),

(9, NULL, 'anjan', 0x3a3a3100000000000000000000000000, '2024-01-

26 01:47:52', NULL, 0),

(10, 4, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-01-26 01:48:11', '26-01-2024 07:19:49 AM', 1),

(11, 5, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-01-26 01:53:13', '26-01-2024 07:23:28 AM', 1),

(12, 6, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-01-26 01:56:08', '26-01-2024 07:26:29 AM', 1),

(13, 7, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-01-26 01:58:10', '26-01-2024 07:28:35 AM', 1),

(14, 4, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-01-26 02:55:46', NULL, 1),

(15, 4, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-01-26 03:00:32', NULL, 1),

(16, 4, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-01-26 03:07:19', '26-01-2024 08:39:56 AM', 1),

(17, 8, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-03-01 02:34:33', NULL, 1),

CCET,IPS, University of Allahahabd

76

(18, 4, '[email protected]', 0x3a3a3100000000000000000000000000,

'2024-03-02 13:52:52', '02-03-2024 07:23:00 PM', 1);

-- --------------------------------------------------------

--

-- Table structure for table `users`

--

CREATE TABLE `users` (

`id` int(11) NOT NULL,

`fullName` varchar(255) DEFAULT NULL,

`address` longtext DEFAULT NULL,

`city` varchar(255) DEFAULT NULL,

`gender` varchar(255) DEFAULT NULL,

`email` varchar(255) DEFAULT NULL,

`password` varchar(255) DEFAULT NULL,

`regDate` timestamp NULL DEFAULT current_timestamp(),

`updationDate` timestamp NULL DEFAULT NULL ON UPDATE

current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=latin1

COLLATE=latin1_swedish_ci;

--

-- Dumping data for table `users`

CCET,IPS, University of Allahahabd

77

--

INSERT INTO `users` (`id`, `fullName`, `address`, `city`, `gender`,

`email`, `password`, `regDate`, `updationDate`) VALUES

(3, 'Prashanth', 'as', 'as', 'male', '[email protected]',

'd12746246ff39c9f52fc7466cf287dcd', '2024-01-23 14:53:36', NULL),

(4, 'Anjan', 'bangalore', 'bangalore', 'male', '[email protected]',

'38cd458a5bfb04b036725c17c656f34f', '2024-01-26 01:47:23', NULL),

(5, 'Varsha', 'Mysore', 'Mydore', 'female', '[email protected]',

'5e275f53a4d937dc890b80e5919e22ab', '2024-01-26 01:50:53', NULL),

(6, 'Pranitha', 'bangalore', 'bangalore', 'female', '[email protected]',

'7a8cacb2bf0648cc67407737dfe8a0d3', '2024-01-26 01:55:15', '2024-01-
26 01:56:18'),

(7, 'Girish', 'Mysore', 'Mysore', 'male', '[email protected]',

'378153728e9ce3bbc04ab696686cf578', '2024-01-26 01:57:23', '2024-01-
26 01:58:28'),

(8, 'Divya', 'bangalore', 'bangalore', 'female', '[email protected]',

'fb97e10f3c85d8ca84a18d84291366eb', '2024-03-01 02:34:09', NULL);

--

-- Indexes for dumped tables

--

--

-- Indexes for table `admin`

--

ALTER TABLE `admin`

ADD PRIMARY KEY (`id`);

CCET,IPS, University of Allahahabd

78

--

-- Indexes for table `appointment`

--

ALTER TABLE `appointment`

ADD PRIMARY KEY (`id`);

--

-- Indexes for table `doctors`

--

ALTER TABLE `doctors`

ADD PRIMARY KEY (`id`);

--

-- Indexes for table `doctorslog`

--

ALTER TABLE `doctorslog`

ADD PRIMARY KEY (`id`);

--

-- Indexes for table `doctorspecilization`

--

ALTER TABLE `doctorspecilization`

ADD PRIMARY KEY (`id`);

CCET,IPS, University of Allahahabd

79

--

-- Indexes for table `tblcontactus`

--

ALTER TABLE `tblcontactus`

ADD PRIMARY KEY (`id`);

--

-- Indexes for table `tblmedicalhistory`

--

ALTER TABLE `tblmedicalhistory`

ADD PRIMARY KEY (`ID`);

--

-- Indexes for table `tblpage`

--

ALTER TABLE `tblpage`

ADD PRIMARY KEY (`ID`);

--

-- Indexes for table `tblpatient`

--

ALTER TABLE `tblpatient`

ADD PRIMARY KEY (`ID`);

CCET,IPS, University of Allahahabd

80

--

-- Indexes for table `userlog`

--

ALTER TABLE `userlog`

ADD PRIMARY KEY (`id`);

--

-- Indexes for table `users`

--

ALTER TABLE `users`

ADD PRIMARY KEY (`id`),

ADD KEY `email` (`email`);

--

-- AUTO_INCREMENT for dumped tables

--

--

-- AUTO_INCREMENT for table `admin`

--

ALTER TABLE `admin`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,

AUTO_INCREMENT=2;

CCET,IPS, University of Allahahabd

81

--

-- AUTO_INCREMENT for table `appointment`

--

ALTER TABLE `appointment`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,

AUTO_INCREMENT=4;

--

-- AUTO_INCREMENT for table `doctors`

--

ALTER TABLE `doctors`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,

AUTO_INCREMENT=15;

--

-- AUTO_INCREMENT for table `doctorslog`

--

ALTER TABLE `doctorslog`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,

AUTO_INCREMENT=33;

--

-- AUTO_INCREMENT for table `doctorspecilization`

--

ALTER TABLE `doctorspecilization`

CCET,IPS, University of Allahahabd

82

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,

AUTO_INCREMENT=29;

--

-- AUTO_INCREMENT for table `tblcontactus`

--

ALTER TABLE `tblcontactus`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,

AUTO_INCREMENT=4;

--

-- AUTO_INCREMENT for table `tblmedicalhistory`

--

ALTER TABLE `tblmedicalhistory`

MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT,

AUTO_INCREMENT=4;

--

-- AUTO_INCREMENT for table `tblpage`

--

ALTER TABLE `tblpage`

MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT,

AUTO_INCREMENT=3;

--

-- AUTO_INCREMENT for table `tblpatient`

CCET,IPS, University of Allahahabd

83

--

ALTER TABLE `tblpatient`

MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT,

AUTO_INCREMENT=6;

--

-- AUTO_INCREMENT for table `userlog`

--

ALTER TABLE `userlog`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,

AUTO_INCREMENT=19;

--

-- AUTO_INCREMENT for table `users`

--

ALTER TABLE `users`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,

AUTO_INCREMENT=9;

COMMIT;

/*!40101 SET
CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT
*/;

/*!40101 SET
CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESUL
TS */;

CCET,IPS, University of Allahahabd

84

/*!40101 SET
COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION
*/;

CCET,IPS, University of Allahahabd

85

CONCLUSION

In conclusion, the development and implementation of a Hospital Management

System (HMS) provide significant improvements in the efficiency, accuracy, and
overall quality of healthcare delivery. By automating key processes such as patient
registration, appointment scheduling, medical record management, billing, and
inventory control, HMS reduces the administrative burden on healthcare staff,
minimizes the risk of errors, and ensures smoother operations.

With features like real-time access to patient information, streamlined communication

between departments, and improved data security, the system enhances decision-
making and patient care. Moreover, the HMS fosters greater transparency and
accountability in hospital management, leading to enhanced operational efficiency
and cost-effectiveness.

Ultimately, the Hospital Management System serves as a crucial tool in modern

healthcare, enabling hospitals to offer better services, improve patient satisfaction,
and contribute to the overall advancement of the healthcare sector. As technology
continues to evolve, further innovations in HMS will likely continue to drive
improvements in hospital operations and patient outcomes.

CCET,IPS, University of Allahahabd

86

CCET,IPS, University of Allahahabd

87

MILESTONE

S.No. Project Activity Estimated Start Date Estimated End Date

1. Project Allotment 23/07/2024 26/07/2024

2. Requirements Gathering 27/07/2024 09/08/2024

3 Design Phase and project flow 10/08/2024 30/08/2024

4. Studied about technology used 2/09/2024 25/09/2024

5. Studied about dataset used 28/09/2024 05/10/2024

6. Data preprocessing 06/10/2024 16/10/2024

7. Testing phase 18/10/2024 28/10/2024

8. Frontend website 29/10/2024 4/11/2024

CCET,IPS, University of Allahahabd

88

MEETING WITH THE SUPERVISOR

Date of the Mode Comments by the Signature of the

meet supervisor Supervisor

CCET,IPS, University of Allahahabd

89

PLAGIARISM REPORT

CCET,IPS, University of Allahahabd