School Clinic

Management System

Checking database…

Dashboard

Database
πŸ‘€ Clinic Staff

User Accounts

Create login accounts, assign roles and reset passwords.

Add User

All Users

UsernameFull NameRoleCreatedActions

Dashboard

Overview of student health services and clinic operations.

Privacy and security: This system stores records in a MySQL database on your XAMPP server. Accounts are stored in the database with roles (Admin, Clinic Staff, Student, Referrals). Menu access follows the role; for real use, also enforce roles in api.php, use HTTPS, and keep regular database backups.
πŸ‘¨β€πŸŽ“

Registered Students

0
🩺

Clinic Visits

0
πŸ“…

Appointments

0
πŸ“¦

Total Medicine Stock

0

Recent Clinic Visits

DateStudentReason

Clinic Alerts

Today's Consultation Schedule

TimeConsultantLocationNotes

Student Records

Centralized student information and QR-linked clinic profiles.

Register Student

Registered Students

Student IDNameGrade / YearSection / CourseContactQR / Actions

Student QR Scanner

Scan a student clinic ID QR code to retrieve the matching student profile and clinic history.

Camera scanning requires camera permission and a secure browser context (HTTPS or localhost). If the scanner library or camera is unavailable, enter the QR value or Student ID manually.

Scan QR Code

Student Profile Result

No student selected yet.

Clinic Visits

Record every student visit and keep a searchable clinic visit history.

Record Clinic Visit

Visit History

Date / TimeStudent IDStudent NameVisit TypeReasonAction

Digital Medical Records

Save assessment findings and connect them to the student's clinic history.

Medical Assessment

Saved Medical Records

DateStudent IDStudent NameTemperatureBPAssessmentNotes

Appointment Scheduling

Schedule student clinic appointments and track their status.

New Appointment

Appointment List

DateTimeStudentPurposeStatusActions

Consultation Schedule

Publish clinic consultation hours, assigned personnel, and availability.

Add Consultation Schedule

Published Consultation Schedules

DateDayTimeConsultantLocationNotesAction

Treatment / Medicine

Record treatment and medicine issued to students. Dispensing automatically deducts inventory stock.

Record Treatment / Dispensing

Treatment History

DateStudent IDMedicineQuantityDosageNotes

Medicine Inventory

Monitor stock-in, stock-out, available quantities, batch numbers, expiration dates, and low-stock levels.

Add / Update Medicine Item

Stock Movement

Current Medicine Stocks

MedicineAvailable StockUnitBatch No.ExpirationReorder LevelStatus

Stock Movement History

DateMedicineMovementQuantityReferenceNotes

Referrals

Record students referred for further medical attention.

New Referral

Referral Records

DateStudent IDStudent NameReferred ToReasonNotes

Automated Notifications

System-generated reminders for appointments, schedules, low medicine stocks, and expiring supplies.

Reports

Generate summaries of patient visits, medicine utilization, inventory levels, and clinic activities.

Report Period

🩺

Patient Visits

0
πŸ“…

Appointments

0
πŸ’Š

Medicines Dispensed

0
πŸ₯

Referrals

0

Patient Visit Report

Clinic visits and visit reasons for the selected period.

Medicine Utilization

Medicine dispensed, quantity, student, and date.

Inventory Levels

Current stock, expiry, and reorder information.

Appointments

Scheduled consultation appointments.

Medical Assessments

Assessment records and findings.

Referrals

Student referral records for the selected period.

Clinic Activities

Visits, assessments, treatments, referrals, and stock movements.

Backup / Recovery

Download or restore a JSON copy of the database records. (For a full copy, also use phpMyAdmin > Export.)