Skip to main content

Employee Performance Evaluation System in PHP/MySQLi with Source Code - Updated

Language

Project: Simple Employee Performance Evaluation System using PHP/MySQLi

About The Project

The Employee Performance Evaluation System is a simple project that can help a certain company evaluate the performance of their employees based on their task accomplishments. This system has 3 types of users which are the Admin, Employee, and Evaluator. The Admin Side is the system user that in-charge to manage the important data of the system such as the department, designation, employee list, and list of evaluators. The admin has access to all of the data stored and the database. The Employee side is the system users that can only access the tasks where they are assigned and submit their progress. The submitted progress of the employee in each task will be the reference of the evaluators on how they will rate the employees. The Evaluator side is the system user side that evaluates the performance of the employees' every task. They will evaluate the employees' by their efficiency, timeliness, quality, and employees' accuracy to accomplish a certain task.

How the System Works

The Employee Performance Evaluation System users can be only created by admin users. The first thing that the admin should do in the system is to populate the department, designation, and the evaluators' list. After that, they will store the details of the employees and along with the employees' system credentials. Then, the admin will create a task and assigned this to an employee. When the employee has already assigned a task, the employee will log in to the system each time they have progressed for a certain task and submit their progress details to store in the system database. When the employee finally completed the task they must check the "Task Completed" check box so that the evaluator can start to evaluate their accomplishment and rate their performance. After the employee marks the task assigned to them as "Completed Task", the evaluator can now begin to evaluate the performance of the employee.

Features

  • Login Page
  • Home Page
  • Department List
  • Designation List
  • Employees List
  • Evaluators List
  • Users List
  • Task List
  • Evaluation List

The Employee Performance Evaluation System was developed using HTML, PHP/MySQLi, CSS, JavaScript (jQuery/Ajax), and Bootstrap for the design. The source code is fully functional and easy to modify or enhance. Follow the instruction below to have an actual experience using this simple project.

How to Run

  1. Download the source code and extract the zip file.
  2. Download or set up any local web server that runs PHP script.
  3. Open the web-server database and create a new database name it "epes_db".
  4. Import the SQL file located in the database folder of the source code.
  5. Copy and paste the source code to the location where your local web server accessing your local projects. Example for XAMPP('C:\xampp\htdocs')
  6. Open a web browser and browse the project. E.g [http://localhost/epes]

Admin Access

Email: [email protected]
Password: admin123

Installation Demo

I hope this Simple Employee Performance Evaluation System will help you with what you are looking for, feel free to download and modify the source code.

 

*Updates:

  • Fixed database error about 'about avatar' due to default value

Explore more on this website for more 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

I have re-tested the source code using the downloadable zip file in this article and it is working. Please make sure that you have already imported the "SQL" file and if ever local server has a password please configure also the "db_connect.php" file in the source code. You can also check the Installation Demo Video.

when I import sql database on phpmyadmin

Show me this message

SQL query-- -------------------------------------------------------- -- -- Table structure for table `employee_list` -- CREATE TABLE `employee_list` ( `id` int(30) NOT NULL, `employee_id` varchar(50) NOT NULL, `firstname` varchar(200) NOT NULL, `middlename` varchar(200) NOT NULL, `lastname` varchar(200) NOT NULL, `email` varchar(200) NOT NULL, `password` text NOT NULL, `department_id` int(30) NOT NULL, `designation_id` int(30) NOT NULL, `evaluator_id` int(30) NOT NULL, `avatar` text NOT NULL DEFAULT 'no-image-available.png', `date_created` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

 

MySQL said: Image removed.

#1101 - BLOB/TEXT column 'avatar' can't have a default value

Submitted byphilip.kiwese (not verified)on Sun, 12/13/2020 - 17:18

am getting empty response when trying to view or add progress on task starting #11......but task #1 up to 10 works fine ...any help plz
Submitted bymk0123 (not verified)on Sat, 01/09/2021 - 16:16

Hi, I did included the db file in phpmyadmin. but localhost/epes is failed to load. getting 404 only
Submitted byji (not verified)on Fri, 02/12/2021 - 04:37

hi, so i try to change the employee into student as im making student evaluation system, but add new student doesnt work. ive change all related things in database but still doesnt work. after fill in the new students form, the page just loading (buffering). idk what to do. help me
Submitted byoretnom23on Tue, 03/02/2021 - 14:09

Hi guys,

The Source Code File is now updated. You can now download the updated file and feel free to leave a comment if ever you may encounter other bugs/errors. Thank you

Add new comment