Healthcare Management System
View on GitHubFull-Stack Web Application · PHP · MySQL
Overview
A full-stack web application for managing hospital operations — built with a classic LAMP stack (Linux, Apache, MySQL, PHP). The system handles patient records, doctor schedules, appointment booking, and prescription management through a role-based access control system.
This was a university capstone-level project that required designing a normalized relational database, implementing secure authentication, and building a complete CRUD interface for multiple user roles — all from scratch without any modern frameworks.
Features
Patient Management
Register, update, and search patient records with full medical history tracking.
Appointment Scheduling
Book, reschedule, and cancel appointments with conflict detection.
Doctor Dashboard
Doctors can view their daily schedule, patient notes, and prescription history.
Role-Based Access
Separate access levels for admins, doctors, and receptionists.
Prescription Records
Create and store digital prescriptions linked to appointments.
Reporting
Generate reports on appointments, patient visits, and department activity.
Architecture
Tech Stack
Key Learnings
- ▸Designed a fully normalized relational database schema from scratch, learning the importance of foreign keys, indexing, and avoiding data anomalies.
- ▸Implemented role-based access control (RBAC) without any framework, deepening understanding of session management and authorization logic.
- ▸Learned SQL injection prevention through prepared statements and the importance of input validation on both client and server side.
- ▸Understood the full request-response lifecycle of a web application at a low level — invaluable for understanding modern frameworks later.