Employee Daily Task Management System in PHP and SQLite with Source Code

Language

This is a Simple PHP Project entitled Employee Daily Task Management System. This is a web-based application that provides an online platform for companies employees to manage their daily tasks. This simple application is a sort of tasks feeder to the employees/staff in each department. This was developed using PHP and SQLite3 Database. The project can be accessed by the system admin users and registered employees. It has a simple user interface using Bootstrap (a CSS Framework) and also has user-friendly functionalities.

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
  • SQLite Database
  • HTML
  • CSS
  • JavaScript
  • jQuery
  • Ajax
  • Bootstrap
  • and more...

About the Employee Daily Task Management System

This Employee Daily Task Management System project can be useful to the company when it comes to managing tasks of the employees and monitoring the productivity of the staff. As I have said above, this system can be accessed by the system administrator which are the ones who are in charge of managing the main list of the system. They have also permission to overwrite data for some features such as deleting the employees' comments. The employees are divided into 2 types of user roles in this system which are the Manager and the Staff. The Manager user is the one who can create/manage tasks, assign tasks to the staff, and update the task status. The staff users can only view the task that is assigned to them. They can also leave a comment on each task assigned to them for any queries or to report their progress.

Project Features

Admin Side

  • Secure Login/Logout
  • Home Page
  • Manage Employee
    • Add New Employee
    • List Employees
    • Edit Employee's Details
    • Update Employee's Status
    • Delete Employee
  • Manage Tasks
    • View Tasks
    • Delete Tasks
    • Manage Comments each task (Overwrite/Delete)
  • Manage Department List (CRUD)
  • Manage Admin List (CRUD)
  • Manage Account Credentials

Employee-Side (Manager)

  • Secure Login/Logout
  • Home Page
  • List All Tasks under his/her Department
  • Create New Tasks
  • Assign Tasks to staffs
  • Update Tasks Details
  • Delete Tasks
  • Add Comment in Each Task
  • Read Comments each Tasks
  • Update his/her submitted comment
  • Delete his/her submitted comment
  • Manage Account's Information/Credentials

Employee-Side (Staff)

  • Secure Login/Logout
  • Home Page
  • List All Tasks Assigned to him/her
  • Add Comment in Each Task
  • Read Comments each Tasks
  • Update his/her submitted comment
  • Delete his/her submitted comment
  • Manage Account's Information/Credentials

Some of the System Snapshots

Employee-Side Home Page

Employee Daily Task Management System

Task List

Employee Daily Task Management System

Task Form Modal

Employee Daily Task Management System

Task View Page

Employee Daily Task Management System

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. Open your XAMPP/WAMP's php.ini file and uncomment the sqlite3 and gd extension. Then, save the file.
  2. Open your XAMPP/WAMP's Control Panel and start Apache.
  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 Employee Daily Task Management System in a browser. i.e. http://localhost/edtms/ for the public and user-side, http://localhost/edtms/admin for the admin side.

Default Admin Access

Username: admin
Password: admin123

DEMO VIDEO

That's it! You can now explore the features and functionalities of this Employee Daily Task Management System project in PHP and SQLite Database. I hope this will help you with what you are looking for and you'll find something useful for your future PHP 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 byMD Touhid (not verified)on Mon, 11/29/2021 - 17:05

I have download this code and move to my html folder But it showing nothing in browser. have anyone tested this code If its running?
Submitted byVen. Deiyandar… (not verified)on Fri, 06/03/2022 - 10:45

I have downloaded this code and moved it to my HTML folder But it showing nothing in the browser. has anyone tested this code If it's running? same problem.
Submitted byjohn kesh mahugu (not verified)on Tue, 07/09/2024 - 22:47

In reply to by Ven. Deiyandar… (not verified)

yes its running, but a lot of tweaking required.
Submitted byjohn kesh mahugu (not verified)on Tue, 07/09/2024 - 22:45

works fine but i had to change the connectivity and database class to PDO and sqlite, i like the interface, good work.

Add new comment