Introduction
This project is entitled Simple Payroll System with a Dynamic Tax Bracket. This is a simple web-based application that was developed using PHP/OOP and MySQL Database. This project is the MySQL Database Version of Simple Payroll System with a Dynamic Tax Bracket in PHP using SQLite project that I posted before. This project manages the company employees' payroll (monthly/semi-monthly). The payroll calculation for the employees' tax is being based on the tax table. The project has a simple and pleasant user-interface user interface. It is easy to modify and has user-friendly features and functionalities.
About the Simple Payroll System with a Dynamic Tax Bracket
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
- MySQL Database
- HTML
- CSS
- JavaScript
- jQuery
- Ajax
- Bootstrap
This Simple Payroll System with a Dynamic Tax Bracket in PHP and MySQL Database was mainly developed for educational purposes only. This will give an Idea to new programmers in PHP Language or students of how to create like the said project. The application stores the employees' information and can calculate their payroll for either Monthly or Semi-Monthly payroll. The payroll form does not support or doesn't include any attendance features. The employees' attendance, earnings, and deductions are only added manually upon creating the employee's payroll. This application Generates a Printable Payslip.
For more information about this simple PHP project or if you are interested in the SQLite version of this project, click here to redirect.
Features
- Secure Login/Logout
- Home Page
- Manage Department List (CRUD)
- Manage Designation List (CRUD)
- Manage Employees List (CRUD)
- Manage Withholding Tax Bracket Table (CRUD)
- Generate Employees Payroll
- Generate Printable Payslip
- Manage System Users
- Manage Account Credentials
System Snapshots of some Features
Payroll Form
Payslip
Tax Bracket Table
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
- Enable or Uncomment the GD Library on your php.ini file.
- Open your XAMPP/WAMP's Control Panel and start Apache and MySQL.
- Extract the downloaded source code zip file.
- 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.
- Browse the PHPMyAdmin in a browser. i.e. http://localhost/phpmyadmin
- Create a new database naming spms_db.
- Import the provided SQL file. The file is known as spms_db.sql located inside the db folder.
- Browse the Simple Payroll System with a Dynamic Tax Bracket in a browser. i.e. http://localhost/spms/.
Default Admin Access
Username: admin
Password: admin123
DEMO VIDEO
That's it. You can now explore the features and functionalities of this Simple Payroll System with a Dynamic Tax Bracket 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.
