Employee Task Management System PHP MySQL

Demo Video
The Online Project Task Management System is a web-based platform developed using PHP and MySQL. It is designed to streamline project and task management for organizations, offering distinct functionalities for Admin and Employee roles, accessible via a common login panel.
Admin Panel Features
Dashboard
- A central page displaying key metrics and options for navigation.2. Left-Side Panel
- Project Management: View and manage projects with details such as:
- Project name
- Assigned employee name
- Assignment date and time
- Submission date and time
- Work progress (Incomplete, In Progress, Completed)
- Update project status
- Employee Attendance: Manage and track employee check-ins and check-outs, including total working hours.
- Administration: Edit admin information, add new employees (name, email, username), and edit existing employee details.
- Logout: Securely log out from the system.
Employee Panel Features
Dashboard
- Displays assigned project details, including:
- Project name
- Description
- Starting date and time
- Submission date and time2. Left-Side Panel
- Project Information: View and update project progress (Incomplete, In Progress, Completed), with updates reflecting in the admin panel.
- Employee Attendance: Record check-in and check-out times and view total working hours.
- Logout: Securely log out from the system.
Technical Stack
- Front-End: HTML, CSS, JavaScript, and Bootstrap
- Back-End: PHP
- Database: MySQL
System Highlights
- Role-based access with tailored dashboards for Admin and Employee.
- Real-time synchronization of project progress between Admin and Employee panels.
- Comprehensive employee management with attendance tracking.
- Easy-to-use interface for efficient task handling and monitoring.
Login Credentials
Database Name - project_tms
Admin Username - admin
Admin Password - admin123
Employee Username
Employee Password - ram1

Detailed Project Description

Employee Task Management System PHP MySQL digitises the day-to-day records and workflows of an organisation so data is stored once, retrieved instantly and reported accurately.

How It Works
1. Role-based login separates admin, staff and end users.
2. Each module (records, bookings, transactions, reports) provides full CRUD operations with validation.
3. Data lives in a relational database with proper relationships between entities.
4. Reports and search views summarise the stored information.

Technology Roles
- BLE
- Java
- PHP
- JavaScript
- MySQL
- Bootstrap
- HTML
- CSS

Implementation Steps
1. Define requirements and draw the ER / class diagram and screen flow.
2. Set up the environment (Arduino IDE) and create the project skeleton.
3. Design the database schema / data model and seed it with sample data.
4. Implement the core modules with validation and role-based access where needed.
5. Build the user interface and connect it to the backend / data layer.
6. Test each module (unit + manual), fix edge cases and secure inputs (SQL injection, XSS, auth).
7. Prepare documentation, screenshots and a demo build.

Key Features
- Role-based access
- CRUD modules
- Search and filters
- Reports / export
- Validation and error handling

Expected Output
On completion the student will have a multi-user application with organised records and printable/exportable reports.

Deliverables
- Complete source code with comments
- Database schema / data model and screen flow
- Project report with screenshots and results
- Demonstration-ready build