Student Attendance System In PHP / MYSQL

The Student Attendance System is a web-based application developed using PHP and MySQL. It aims to digitize and simplify the attendance management process in educational institutions. The system provides distinct roles for administrators and teachers, ensuring efficient and secure data handling.

Purpose

The system is designed for educational purposes, focusing on:

• Automating attendance tracking.
• Reducing manual effort and errors.
• Providing secure role-based access for administrators and teachers.
• Serving as a learning tool for students studying database-driven web applications.

Features

Admin Features

1. User Management
   • Add, update, or delete teacher accounts.
2. Class Management
   • Create, edit, or delete class details.
3. View Attendance Reports
   • Access attendance data for all classes.
4. Role Assignment
   • Assign specific roles and permissions to teachers.

Teacher Features

1. Mark Attendance
   • Record daily attendance for their assigned classes.
2. View Attendance
   • Review attendance records for specific dates.
3. Generate Reports
   • Generate and download attendance reports for students.

System Architecture

1. Frontend
   • Developed using HTML, CSS, and JavaScript.
   • Responsive design for desktop and mobile devices.
2. Backend
   • Developed in PHP for server-side logic.
   • Implements role-based access control.
3. Database
   • MySQL database for managing user accounts, class details, and attendance records.
   • Key tables include:
     • tbl_admin: Admin login credentials.
     • tbl_teachers: Teacher details and login credentials.
     • tbl_students: Student information.
     • tbl_classes: Class details.
     • tbl_attendance: Attendance records.

System Workflow

1. Admin Login
   Admins log in and access the dashboard to manage teachers, classes, and reports.
2. Teacher Login
   Teachers log in to their accounts and access their assigned class data.
3. Marking Attendance
   Teachers select a class, view the student list, and mark attendance as “Present” or “Absent.”
4. Generating Reports
   Admins and teachers can view attendance data for specific classes, students, or time periods.

Installation Steps

1. Requirements
   • PHP 7.4 or higher
   • MySQL 5.6 or higher
   • A web server (e.g., Apache or Nginx)
2. Setup
   • Download the project files.
   • Import the SQL database file (attendancemsystem.sql) into your MySQL server.
   • Update the database configuration in config.php.
   • Start the server and access the application via a web browser.

Educational Value

This project demonstrates:

• Role-based authentication.
• CRUD operations with PHP and MySQL.
• User-friendly web interface design.
• Integration of backend logic with frontend forms.

Future Enhancements

• Add student login for self-attendance tracking.
• Implement biometric or QR code-based attendance.
• Integrate analytics for attendance trends.