Attendance and Payroll System using PHP/MySQLi Source Code

Language

This is a simple Attendance and Payroll System using PHP and MySQLi-OOP as DB driver. It has attendance on the client-side and payroll on the admin side. This system is written in pure PHP with no framework so it is understandable to beginners.

*Submitted: 02-2-18

*Last Updated: 12-01-20 (tested in PHP version 7.2.33)

Features:

  • CRUD - Employee Attendance
  • CRUD - Employee
  • Employee Cash Advance
  • Employee Overtime
  • Employee Schedule
  • Payroll on Date Range
  • Payslip on Date Range

Plugins:

  • AdminLTE
  • TCPDF library

Installation

  1. Download the source code using the Download button below.
  2. Extract the downloaded file to your localhost folder ex. htdocs for XAMMP.
  3. Import the included .sql file which is the database of the system. If you have no idea how to import, please refer to my tutorial on How import .sql file to restore MySQL database.
  4. After a successful import, open the extracted folder and open conn.php in both the root folder and in admin/includes folder. Edit the database name in the connection depending on the name of database you created in importing the included .sql file.

Accessing the Admin

You can access the admin side by adding /admin/. You should be able to navigate to the admin login page.

You can then use the below admin credential:

Username: nurhodelta

Password: password

That's it. You should now be able to run the simple system :)

Installation and System Feature Demo Video

If you have any suggestions, comments, or reactions, feel free to comment below or message me.

Happy Coding :)

*Updates: 05-21-18

  1. Fixed dynamic buttons (edit, delete, etc ) not functioning on page2 or more of the table.
  2. Fixed time in showing late even on time.

*Updates: 12-1-20

  1. Fixed dynamic buttons (edit, delete, etc ) on page2 or more of the table.

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

How to fix the payroll, Payslip button Fatal error: Array and string offset access syntax with curly braces is no longer supported in C:\xampp\htdocs\apsyste\tcpdf\tcpdf.php on line 16893

Sir how to fix Payslip and pay roll button this is the error Fatal error: Array and string offset access syntax with curly braces is no longer supported in C:\xampp\htdocs\apsyste\tcpdf\tcpdf.php on line 16893

i planed to move this system to my website. but this message showing- please help me Connection failed: Access denied for user 'root'@'localhost' (using password: NO)

How do the late been calculated ?

Add new comment