Complete Employee Task Management System using PHP and MySQL

Introduction

This tutorial will guide you through creating a complete Employee Task Management System using PHP, MySQL, HTML, CSS, and JavaScript. You will learn to set up your development environment, design a database, implement user authentication, and manage tasks effectively. This project is ideal for beginners looking to enhance their web development skills.

Step 1: Setting Up the Project Environment

• Install XAMPP: Download and install XAMPP, which provides an Apache server, MySQL database, and PHP.
• Start Services: Open the XAMPP Control Panel and start the Apache and MySQL services.
• Create Project Folder: Navigate to the htdocs folder in your XAMPP installation directory and create a new folder for your project (e.g., EmployeeTaskManagement).

Step 2: Designing the Database in MySQL

• Access phpMyAdmin: Open your web browser and go to http://localhost/phpmyadmin.
• Create Database:
  • Click on "Databases" and create a new database (e.g., task_management).
• Create Tables:
  • Users Table:

    CREATE TABLE users (
        id INT AUTO_INCREMENT PRIMARY KEY,
        username VARCHAR(50) NOT NULL,
        password VARCHAR(255) NOT NULL,
        role ENUM('admin', 'employee') NOT NULL
    );
    

  • Tasks Table:

    CREATE TABLE tasks (
        id INT AUTO_INCREMENT PRIMARY KEY,
        user_id INT NOT NULL,
        title VARCHAR(100) NOT NULL,
        description TEXT,
        status ENUM('pending', 'in progress', 'completed') NOT NULL,
        due_date DATE,
        FOREIGN KEY (user_id) REFERENCES users(id)
    );
    

Step 3: Creating the User Interface

• HTML Structure: Create HTML files for the user interface (e.g., index.html, login.html, dashboard.html).
• CSS Styling: Use CSS to style your application. Make sure to include styles for different user roles.
• JavaScript Functions: Implement JavaScript for dynamic content and form validation.

Step 4: Implementing Authentication

• Login Page: Create a login form in login.html with fields for username and password.
• PHP Login Script:

  <?php
  session_start();
  $conn = new mysqli('localhost', 'username', 'password', 'task_management');
  if ($_SERVER["REQUEST_METHOD"] == "POST") {
      $username = $_POST['username'];
      $password = $_POST['password'];
      $query = $conn->prepare("SELECT * FROM users WHERE username=?");
      $query->bind_param("s", $username);
      $query->execute();
      $result = $query->get_result();
      if ($result->num_rows > 0) {
          $user = $result->fetch_assoc();
          if (password_verify($password, $user['password'])) {
              $_SESSION['user_id'] = $user['id'];
              $_SESSION['role'] = $user['role'];
              header("Location: dashboard.php");
          }
      }
  }
  ?>
  

Step 5: User Role Management

• Admin and Employee Roles: Set up role-based access control. Use conditional statements in PHP to manage user capabilities.
• CRUD Operations: Enable admins to create, read, update, and delete users and tasks.

Step 6: Managing Tasks

• Create Tasks: Allow admins to create tasks and assign them to employees.
• View All Tasks: Admins should have the ability to view all tasks and their statuses.
• Edit and Delete Tasks: Provide options for admins to edit or delete tasks.

Step 7: Employee Task Management

• View Employee Tasks: Employees should be able to view their assigned tasks.
• Update Task Status: Implement functionality for employees to update the status of their tasks (pending, in progress, completed).

Step 8: Enhancing Features

• Due Dates and Snooze: Add due dates to tasks and a snooze feature for task reminders.
• Task Filtering: Implement filtering options for tasks based on status, deadlines, and priority.
• Dashboard Creation: Design separate dashboards for admins and employees that display relevant data.

Step 9: Adding Notifications

• Real-time Notifications: Implement a notification system to alert users of task updates and deadlines.

Conclusion

You have now created a fully functional Employee Task Management System using PHP and MySQL. This project not only enhances your coding skills but also gives you practical experience in user authentication and task management. For further enhancement, consider adding more features or integrating third-party APIs. Check the source code on GitHub for reference and continue exploring web development projects!