Skip to main content

Task Management System using PHP/MySQLi with Source Code

Language

Project: Task Management System using PHP/MySQLi

About The Project

The Task Management System is a simple project that can help a certain company manage its project task progress. The system has 3 types of system users which are the Admin, Project Manager, and the Regular Employee. The Admin user is those users that has an access to all of the data stored in the database of the system especially on creating and managing system users. The Project Managers are those users that manage the project details and progress under her/his management. The Regular Employees will submit their work productivity in each task of the project which makes the system requires the employee to submit their start and end time range of their work on a certain task and this data will be calculated in the report as project members' work duration.

How the System Works

The Task Management System users can be only created by admin users. The admin user or the Project Managers will create a new project at first along with some important details and references of the users. When creating a project, the admin or project managers must list all the employees that will handle the project's tasks. After the creation of the project, the regular employees are limited only to adding their work progress for the task of the project that they are assigned. They are also allowed to edit the data of the progress that they only submitted. Then, as the employees regularly updating the system about the progress they have done the project managers will read or scan their activities so the project manager can check or decide if the certain task is done and need to update the task status in the system. For the printable report of the system, only the admin users and project managers has an access to this function or feature of the system.

Features:

  • Login Page
  • Home Page
  • Project (CRUD Features)
  • Task List Page
  • Progress Form
  • Report Generation
  • User (CRUD Features)
  • etc.

The Task Management 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 "tms_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/task_management_system]

Admin Access

Email: [email protected]
Password: admin123

I hope this Task Management System will help you with what you are looking for, feel free to download and modify the source code.

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

Submitted byengmohdon Thu, 12/03/2020 - 20:33

Hi Does you Database incomplete? please response

My Dear

Check the database
can't login to system 
database not work

also show me error when import database
 

Error

SQL query:

 

  1. -- --------------------------------------------------------
  2.  
  3. --
  4. -- Table structure for table `users`
  5. --
  6.  
  7. CREATE TABLE `users` (
  8. `id` int(30) NOT NULL,
  9. `firstname` varchar(200) NOT NULL,
  10. `lastname` varchar(200) NOT NULL,
  11. `email` varchar(200) NOT NULL,
  12. `password` text NOT NULL,
  13. `type` tinyint(1) NOT NULL DEFAULT 2 COMMENT '1 = admin, 2 = staff',
  14. `avatar` text NOT NULL DEFAULT 'no-image-available.png',
  15. `date_created` datetime NOT NULL DEFAULT current_timestamp()
  16. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

 

MySQL said: Image removed.

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

Submitted byAndrex (not verified)on Thu, 02/11/2021 - 05:11

Hi, On Ubuntu when i insert a user productivity don't work...
Submitted byMubarak Khamis (not verified)on Thu, 02/11/2021 - 18:48

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

Hi, sorry for that. First of all, drop the tables in the database. Then to fix the problem, open the SQL file in a text editor then search the "avatar" keyword and remove the default value. If the avatar keyword has multiple results upon searching please make sure these don't have a default value. After that save the SQL file and import it again to the database. If the import was successful you can now try to browse the web application and log in again. Also make sure that the admin user is existing in the database, in that case, you should log in successfully.

Submitted byakzboot (not verified)on Fri, 03/05/2021 - 16:39

I want to attach files at the end of the task. Can you guide me to edit the source code? Please
Submitted byOmar_64 (not verified)on Wed, 03/24/2021 - 19:25

This is the error we have when the aplli is online server, but in local server there is no probleme. Can you fix this please ? session_start(): Cannot start session when headers already sent in index.php on line 3 PHP Warning: Cannot modify header information - headers already sent by (output started at index.php:1) in index.php on line 6
Submitted bysethomaz (not verified)on Sun, 04/04/2021 - 01:32

hello good job the administrator login is not bringing the User Role option in the user registration, nor the user menu on the side, even if logging in as an administrator, and the other users are able to edit the other accounts and some menus are not appearing in the menu side, could you help me solve this?
Submitted bySET777 (not verified)on Tue, 04/06/2021 - 03:03

Hello, this is a good job but it is not working ... the admin connecting with the correct credentials but cannot add a user and does not have the admin privileges .. among other errors, please review the code and post again. thanks
Submitted bynim (not verified)on Sun, 05/02/2021 - 18:41

hey admin i am not able to create correct ER diagram of database can you help me with this?

Add new comment