Attendance and Payroll System using PHP/MySQLi Source Code
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
- Download the source code using the Download button below.
- Extract the downloaded file to your localhost folder ex. htdocs for XAMMP.
- 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.
- 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
- Fixed dynamic buttons (edit, delete, etc ) not functioning on page2 or more of the table.
- Fixed time in showing late even on time.
*Updates: 12-1-20
- 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
error in Payslip and pay roll button
Error message
Add new comment
- Add new comment
- 40541 views