Comprehensive web application for streamlined communication and meeting scheduling between parents and teachers
Traditional parent-teacher communication in educational institutions relies on manual processes including paper-based scheduling, phone calls, and in-person coordination, which lead to missed appointments, scheduling conflicts, inefficient time management, and lack of proper documentation. Parents struggle to track their children's academic performance across multiple subjects and teachers, while teachers face challenges managing numerous parent meetings, maintaining appointment records, and coordinating schedules with their teaching responsibilities. Existing solutions often lack role-based access control, provide inadequate meeting status tracking, offer no integrated performance monitoring, and fail to maintain comprehensive audit trails for administrative oversight.
There is a critical need for a centralized, web-based meeting management system that streamlines parent-teacher communication while providing proper documentation, status tracking, and performance monitoring capabilities. This project addresses these challenges by developing a comprehensive PHP-based web application featuring separate role-based dashboards for parents and teachers, automated meeting scheduling with acceptance/rejection workflow, integrated student performance tracking with USN-based identification, secure authentication using bcrypt password hashing and session management, meeting status management (scheduled, completed, cancelled) with comprehensive logging, responsive Bootstrap 5 interface for mobile and desktop access, and MySQL database backend with prepared statements for SQL injection protection, enabling educational institutions to efficiently manage parent-teacher interactions while maintaining proper records and improving communication between all stakeholders.
The system is built on PHP 7.4+ with MySQL 5.7+ database backend, implementing a modular architecture with separate directories for configuration (config/), pages (pages/), actions (actions/), assets (assets/), and logs (logs/). The database layer uses prepared statements for all queries preventing SQL injection, with four core tables: parent_users and teacher_users for role-based authentication, meetings for scheduling and tracking, and student_performance for academic monitoring. Password security implements bcrypt hashing with automatic salt generation.
The meeting lifecycle implements a complete workflow: teachers initiate meetings through teacher_meeting_form.php with parent details, subject, date, and time; the system creates records with "pending" response status; parents view scheduled meetings in their dashboard; teachers can accept/reject requests via accept_meeting.php and reject_meeting.php with reason tracking; meeting status updates (scheduled/completed/cancelled) are handled through update_status.php; all deletions are logged to meeting_deletion.log for audit compliance. The system maintains complete meeting history with timestamp tracking and status progression.
The responsive interface uses Bootstrap 5.1.3 with custom CSS animations and gradient backgrounds, providing separate dashboards: parent_dashboard.php displays scheduled meetings and student performance summaries; teacher_dashboard.php offers meeting management, request handling, and performance entry; the main dashboard.php serves as the central hub with role-based routing. The UI features modern card layouts, status badges with color coding, form validation with error feedback, and mobile-responsive design. Session management ensures secure access with automatic logout and role-based page restrictions.