Submitted by oretnom23 on Thursday, December 3, 2020 - 17:05.

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

Download the source code and extract the zip file.
Download or set up any local web server that runs PHP script.
Open the web-server database and create a new database name it "tms_db".
Import the SQL file located in the database folder of the source code.
Copy and paste the source code to the location where your local web server accessing your local projects. Example for XAMPP('C:\xampp\htdocs')
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

Check the database

Hi Does you Database incomplete? please response

My Dear

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

Hi, I have checked the…

Hi, I have checked the source code and it's working fine. Try watching the Installation Demo of this article. Thank you

error when import database

also show me error when import database

Error

SQL query:

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(30) NOT NULL,
  `firstname` varchar(200) NOT NULL,
  `lastname` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `password` text NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT 2 COMMENT '1 = admin, 2 = staff',
  `avatar` text NOT NULL DEFAULT 'no-image-available.png',
  `date_created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

MySQL said:

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

Don't work on xampp Ubuntu

Hi, On Ubuntu when i insert a user productivity don't work...

i have same problem

Can’t Login

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

Hi, sorry for that. First of…

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.

Thanks !

check task_db.sql open…

check task_db.sql open notepad remove deafault 'no image.jpg'

attack file

I want to attach files at the end of the task. Can you guide me to edit the source code? Please

Probleme of session start at online server

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

Problem of session_start(); at online server

I have the same problem

User menu does not appear

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?

Error login admin

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

hey admin i am not able to…

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

hey admin i am not able to…

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

ER diagram

not able to create ER diagram out of database pls help