Online Employees Work From Home Attendance System in PHP and SQLite Free Source Code

Language

Introduction

This is a PHP Project entitled Online Employees Work From Home Attendance System. This simple application uses an SQLite Database as the storage that provides certain company's employees an online platform to log their attendance. This simple project can be useful especially this mid of pandemic where some companies let their employees work from their respected homes. The project has only a small scope but enough to meet or reach the goal of this project. It has a simple 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
  • Summernote
  • and more...

About the Online Employees Work From Home Attendance System

This project has 2 modules which are the administrator side and the employee side. The Admin Side is in charge of managing all data that does the project has. The employee will be provided credentials in order for them to access the system where they can log their attendance. When the employees log their attendance, the system captures the IP and location of the employee and this data can be only viewed by the admin.

Project Features

Admin Panel

  • Secure Login/Logout
  • Home Page
  • Manage Department List (CRUD)
  • Manage Position List (CRUD)
  • Manage Employee List (CRUD)
  • Manage Attendance Log
  • View Attendance Log Details
  • Print Attendance Log List
  • Manage System Users
  • Manage Account Credentials

Employees Side

  • Secure Login/Logout
  • Log Attendance
    • Time In
    • Lunch Break Out
    • After Lunch In
    • Time Out
  • List All Employee's Attendance Log
  • Manage Account Credentials

Some of the System Snapshots

Employees Attendance Log Page

Online Employees Work From Home Attendance System

Page

Online Employees Work From Home Attendance System

Attendance Log's Details Modal

Online Employees Work From Home Attendance System

Attendance Log List Print View

Online Employees Work From Home Attendance System

The project source code is free to download on this website. Feel Free to download and modify the source code the way you wanter. Follow the instruction below to run this project.

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 gd extension. Then, 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 Online Employees Work From Home Attendance System in a browser. i.e. http://localhost/wfh_attendance/.

Default Admin Access

Username: admin
Password: admin123

DEMO Video

That's it! You can now explore the features and functionalities of this Online Employees Work From Home Attendance System project in PHP and SQLite Database. I hope this will help you with what you are looking for and you'll find something useful for your future PHP 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 byBukari Amo (not verified)on Sat, 10/09/2021 - 02:51

no db file
Submitted byoretnom23on Sat, 10/09/2021 - 08:31

Hi, the database will be automatically created and the admin access will be automatically created also it does not exist yet. Run the project by following the instruction given. Thanks

Submitted byAli mohammed (not verified)on Wed, 11/10/2021 - 12:57

hello thank u for ur project , can you help to to to make it works on my server plz I need to db.file and connection.php file
Submitted byyakoub (not verified)on Thu, 11/11/2021 - 00:34

can you tell me please how to run it on my server because there is no db file
Submitted byTizyo (not verified)on Fri, 12/24/2021 - 22:16

Hi, thank you this was really helpful. I have an issue . The tale on admin side is not returning any results. But it works okay in localhost. What could be the reason>
Submitted byNaresh Chandavarkar (not verified)on Sat, 01/08/2022 - 15:14

It works on the same laptop but it is not able to access from other laptops. Please guide me

Add new comment