Hospital Patient Management Dashboard

A full-stack web application for managing patient records, doctor assignments, room allocation, and treatment history.

Overview

The Hospital Patient Management Dashboard is a Flask-based web application that streamlines hospital record management through separate interfaces for patients and administrators.

Patients can securely register, log in, and view their assigned doctor, room information, admission details, and treatment history. Administrators can manage hospital resources by adding doctors, rooms, and treatment records through a dedicated admin portal.

The application uses Flask for the backend, MySQL for persistent data storage, and a lightweight HTML/CSS/JavaScript frontend to provide a responsive and intuitive user experience.

---

Features

Patient Portal

• Two-step patient authentication
• New patient registration
• Secure login using name and phone number
• View assigned doctor details
• View room allocation
• Access treatment history
• View admission details
• Delete patient account
• Logout functionality

Admin Portal

• Add new doctors
• Add hospital rooms
• Record patient treatments
• Manage hospital information through dedicated forms

Backend

• RESTful API endpoints using Flask
• CRUD operations with MySQL
• Cross-Origin Resource Sharing (CORS) support
• Dynamic data retrieval
• Secure database interaction using MySQL Connector

---

Tech Stack

Technology	Purpose
Python	Backend
Flask	REST API & Server
MySQL	Database
HTML5	Frontend
CSS3	Styling
JavaScript	Client-side Logic
Flask-CORS	Cross-origin communication
MySQL Connector	Database connectivity

---

Project Structure

Patient_dashboard/
│
├── app.py                 # Flask backend
│
├── static/
│   ├── index.html         # Patient Portal
│   ├── admin.html         # Admin Portal
│   └── styles.css         # Styling
│
└── README.md

---

Workflow

Patient

1. Enter name and phone number

2. System verifies whether the patient exists

3. Existing patients are directed to their dashboard

4. New patients complete registration

5. Dashboard displays:

   • Doctor information
   • Room details
   • Admission date
   • Treatment history

Administrator

1. Open Admin Portal
2. Add doctors
3. Add hospital rooms
4. Record treatments
5. Patient dashboard updates automatically from the database

---

Database

The project uses a relational MySQL database containing entities such as:

• Patient
• Doctor
• Room
• Treatment

The backend performs SQL queries to retrieve and update information in real time.

---

Installation

Clone the repository

git clone https://github.com/yourusername/Patient_dashboard.git

Install dependencies

pip install flask
pip install flask-cors
pip install mysql-connector-python

Configure MySQL credentials inside app.py.

Run the application

python app.py

Visit

http://127.0.0.1:5000

---

Learning Outcomes

This project demonstrates:

• Full-stack web development
• REST API development
• Database design and SQL integration
• CRUD operations
• Role-based application architecture
• Client-server communication
• Backend development using Flask

---

Future Improvements

• Password-based authentication
• JWT authentication
• Appointment scheduling
• Prescription management
• Medical report uploads
• Search and filter functionality
• Responsive mobile interface
• Docker deployment
• Cloud database integration
• Analytics dashboard for hospital administrators