A web-based system to automate medical leave applications and approvals in educational institutions.
Traditionally, medical leave processing involves physical forms and multiple manual approvals, which is slow and error-prone.
This project streamlines the entire workflow with a centralized online portal.
- Role-based login: Student, Doctor, Teacher, HOD, Dean
- Online application: Students can submit leave requests with supporting documents
- Sequential approvals: Doctor → Dean → HOD → Teacher
- Live status tracking: Students and faculty can view current status and history
- Responsive UI: Clean, user-friendly design using Bootstrap 5
- Login System: Secure, role-based access validated via MySQL
- Student Panel: Apply for leave, upload documents, check request status
- Doctor Panel: Approve/reject requests
- Dean, HOD, Teacher Panels: Approve/reject in sequence
- Leave Approval Chain: Automated status update after all approvals
| Component | Description |
|---|---|
| HTML/CSS | Frontend structure & styling |
| Bootstrap 5 | Responsive design framework |
| PHP | Server-side scripting |
| MySQL | Backend database |
| XAMPP | Local server (Apache & MySQL) |
userstable: Stores user credentials & rolesleave_requeststable: Tracks leave applications & statusuploadstable: Stores uploaded documents
- Clone or download this repository.
- Place project files in your
htdocsfolder (if using XAMPP). - Start Apache and MySQL using XAMPP Control Panel.
- Import the provided
.sqlfile to set up the database. - Open your browser and navigate to
http://localhost/your-project-folder.
- Student submits request → Status is "Pending"
- Doctor approves → Status updated
- Dean, HOD, Teacher approve in sequence
- After final approval → Status auto-updated to "Approved"
- OTP or biometric login
- SMS/email notifications on approvals
- Admin dashboard for user management
- Reports export (PDF/Excel)
- Analytics and charts for leave trends
Mahima Singh