Simple Payroll System with Dynamic Tax Bracket in PHP/OOP and MySQL Free Source Code

Language

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
Simple Payroll System with a Dynamic Tax Bracket
Payslip
Simple Payroll System with a Dynamic Tax Bracket
Tax Bracket Table
Simple Payroll System with a Dynamic Tax Bracket

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. Enable or Uncomment the GD Library on your php.ini file.
  2. Open your XAMPP/WAMP's Control Panel and start Apache and MySQL.
  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 PHPMyAdmin in a browser. i.e. http://localhost/phpmyadmin
  6. Create a new database naming spms_db.
  7. Import the provided SQL file. The file is known as spms_db.sql located inside the db folder.
  8. 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.

Comments

Submitted byMirza Baig (not verified)on Thu, 02/10/2022 - 18:59

Hello, Thank you for this beautiful projects but I am afraid I was not able to run it. When I browse it through http://localhost/spms/admin/login.php, it gives the following error:
  1. Fatal error: Uncaught Error: Class "SQLite3" not found in C:\xampp\htdocs\spms\DBConnection.php:3 Stack trace: #0 C:\xampp\htdocs\spms\admin\login.php(7): require_once() #1 {main} thrown in C:\xampp\htdocs\spms\DBConnection.php on line 3
Can you please help with that ? Many thanks
Submitted byoretnom23on Fri, 02/11/2022 - 09:20

In reply to by Mirza Baig (not verified)

Hi, I am sorry for the inconvenience. I have fixed the source code and updated it on this article. Kindly re-download it. Thanks

Submitted byMirza Baig (not verified)on Fri, 02/11/2022 - 21:29

@oretnom23 Thank you for your reply. Yes, its working, another beautiful project, a million thanks :)
Submitted byGrai (not verified)on Mon, 03/20/2023 - 21:05

Fatal error: Uncaught mysqli_sql_exception: Unknown database 'spms_db' in C:\xampp\htdocs\spms\DBConnection.php:6 Stack trace: #0 C:\xampp\htdocs\spms\DBConnection.php(6): mysqli->__construct('localhost', 'root', Object(SensitiveParameterValue), 'spms_db') #1 C:\xampp\htdocs\spms\DBConnection.php(20): DBConnection->__construct() #2 C:\xampp\htdocs\spms\admin\login.php(7): require_once('C:\\xampp\\htdocs...') #3 {main} thrown in C:\xampp\htdocs\spms\DBConnection.php on line 6

Add new comment