Simple Attendance System in PHP and SQLite Free Source Code

Language

This is a Simple Attendance System in PHP. This simple project is a web-based application that records the attendance of employees of a certain company. This mini-project has an Admin Panel where the system admin or staff can manage the relevant data in the system. I am sharing this source code to help other new programmers especially those students to have a project source code to start with to develop an Attendance Management System or any related project.

About the Simple Attendance System

This project was developed using PHP and SQLite Database. As I have mentioned above, this Simple Attendance System has an Admin Side to manage the data. The system users can store the list of employees of the company. The System Administrator users are in charge of managing the list of users, departments, and designation in the system. They are the only ones who can manage and populate the said lists. This simple project also lists all the attendance records of the employees and this record is printable. The system has a pleasant user interface and user-friendly functionalities.

I developed this project using the following:

  • XAMPP v3.3.0 as my local webserver that has a PHP Version 8.0.7
  • PHP Language
  • SQLite Database
  • HTML
  • CSS
  • JavaScript
  • jQuery
  • Ajax
  • Bootstrap

Features

Admin Side

  • Secure Login/Logout
  • Manage Department List
  • Manage Designation List
  • Manage Employees List
  • View Attendance Records
  • Print Attendance Records
  • Manage Account Details

Staff Side

  • Secure Login/Logout
  • Manage Employees List
  • View Attendance Records
  • Print Attendance Records
  • Manage Account Details

Public/Employees Side

  • Record Attendance
  • View All Attendance Records for the current date

System Snapshots of some Features

Attendance Page (Public Side)

Simple Attendance System

Employee List

Simple Attendance System

Employee Details Modal

Simple Attendance System

Maintenance Page

Simple Attendance System

Printable Attendance Records Page

Simple Attendance System

The Simple Attendance System Project's Source Code is free to download on this website. Feel free to modify it the way you desire.

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 Simple Attendance System in a browser. i.e. http://localhost/attendance/

Default Admin Access Information

Username: admin
Password: admin123

DEMO

That's it. You can now explore the features and functionalities of this Simple Attendance System in PHP. I hope this project will help you with what you are looking for and you'll find something useful for your future projects.

Explore more on this website for more Free Source Codes and Tutorials.

Enjoy :)

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Submitted bykasali samson (not verified)on Thu, 09/16/2021 - 05:44

Hi Thanks for he project i so appreciate it but after following the video and instructions i am experiencing this error code: Fatal error: Uncaught Error: Class 'SQLite3' not found in C:\xampp\htdocs\attendance\DBConnection.php:9 Stack trace: #0 C:\xampp\htdocs\attendance\attendance.php(3): require_once() #1 {main} thrown in C:\xampp\htdocs\attendance\DBConnection.php on line 9 I would be glad if you can assist me with some help. thanks
Submitted byNameless (not verified)on Sun, 01/30/2022 - 03:18

Today's record is not showing any records even I tried to time in and no records shown
Submitted byNameless (not verified)on Sun, 01/30/2022 - 03:19

Today's record is not showing any records even I tried to time in and no records shown
Submitted bymikasa1 (not verified)on Tue, 03/01/2022 - 08:52

Hello oretnom23 where can i reach you to ask more about how to host this website
Submitted bySqlite3 table (not verified)on Sat, 04/09/2022 - 07:19

The sqlite3 table is not showing How can i access the sqlite3 table And i can't login as an employee What will i use to login as an employee have try the way in the tutoria it not working

Add new comment