School Intramurals - Student Attendance Management System using PHP and SQLite

This project is entitled Intramural's Student Attendance Management System. It is a web-based application developed in PHP and MySQL Database that manages certain College School or University's Student Attendance for their Intramural. It has a simple and pleasant user interface using the Bootstrap v5 Framework. It also consists of user-friendly features and functionalities.

How does the Intramural Student Attendance Management System work?

The Intramural Student Attendance Management System work contains a small scope of features and functionalities which mainly focuses on storing, retrieving, and managing the attendance records of the students during the school's Intramural events. The application has a Management Site where the management can populate the list of students, courses, and year levels. On the same side of the system. Users can list all the attendance logs of the student which can be filtered by courses and year level.

The public site of the system is the side of the application where students can log their attendance. Students can simply enter their Student ID Number or Code and click the time log type button (In/Out). The system itself contains a simple logic that prevents the double entry of the students' logs.

Features and Functionalities

The system contains the following features and functionalities:

• Student Attendance Log Page
• Admin/User Login Page
• Simple Home Page
• Maintenance Page
  • School Year Management Panel
  • Year Level Management Panel
  • Courses Management Panel
• Student Management
• Attendance Records
• Filter Attendance Records by Courses
• Filter Attendance Records by Year Level
• Print Attendance Record
• Set Current School Year
• Users Management
• Logout

Technologies

Here are the following technologies I used to develop the Intramural's Student Attendance Management System

• HTML
• CSS
• JavaScript
• PHP
• SQLite Database
• jQuery
• Ajax
• Bootstrap Framework
• Fontawesome Icons

Snapshots

Here are some snapshots of the Intramural's Student Attendance Management System

Attendance Log Page

Maintenance Page (Admin Only)

Student List Page

Attendance Records Page

Attendance Records Print View

I have provided the Intramural's Student Attendance Management System's source code zip file on this website and is free to download. Feel free to download and modify it the way you wanted. I have developed the project just for educational purposes only.

How to Run?

Requirements

• Download and Install any local web server such as XAMPP/WAMP.
• Download the provided source code zip file. (download button is located below)

Installation/Setup

1. Open your XAMPP/WAMP's php.ini file and uncomment the sqlite3 and save the file.
2. Open your XAMPP/WAMP's Control Panel and start Apache.
3. Extract the downloaded source code zip file.
4. If you are using XAMPP, copy the extracted source code folder and paste it into the XAMPP's "htdocs" directory. And If you are using WAMP, paste it into the "www" directory.
5. Browse the Intramural's Student Attendance Management System in a browser. i.e. http://localhost/intrams_sams/

The Database file is located in the db folder named attendance_db.db

Default Admin Access Information

Username: admin
Password: admin123

That's it! I hope this Intramural's Student Attendance Management System Project in PHP and SQLite Database will help you with what you are looking for and that you'll find something useful from the source code itself for your current and future PHP Projects.

Enjoy :)