Nickolas Patino

PHP • MySQL • PDO • CRUD • Admin Interface

Employee Manager

A database-backed employee management application for creating, viewing, searching, editing, and deleting employee records.

Live Demo GitHub Back to Projects
Employee Manager application screenshot

Overview

Employee Manager is a small administrative web application for maintaining employee records. It includes a searchable employee list, individual detail views, add/edit forms, delete actions, and manager relationships between employees.

Employee Directory

The main screen displays employee records with names, email addresses, positions, teams, managers, hire dates, termination dates, and record actions.

Search and Sorting

The list supports text search across employee fields and sortable table headers for reviewing records in different orders.

Record Management

Create, read, update, and delete screens provide the core administrative workflow for employee data.

Application Features

The application is organized around common employee-record workflows used in administrative tools.

Employee List

The index page lists employee records and provides direct links to view, edit, and delete each record.

Search

The search form filters employee records by name, email, position, team, manager, hire date, and termination date.

Sortable Columns

Table headers support sorting by employee fields, with direction toggling between ascending and descending order.

Add Employee

The create form collects employee details and inserts a new record into the database.

Edit Employee

The update form loads an existing employee record, allows changes, and saves the updated data.

Responsive Views

Desktop users receive a table layout, while smaller screens receive stacked employee cards.

Technical Implementation

The project uses PHP pages connected to a MySQL database through a shared database configuration. Employee records are queried with PDO, and the interface is split across list, create, read, update, and delete screens.

PHP and PDO

The application uses prepared PDO statements for insert, update, read, and delete operations.

Manager Relationship

Employee records can reference another employee as a manager, and list/detail views join employee records back to manager names.

Responsive Interface

The demo uses a desktop table for larger screens and a card-based layout for mobile screens.

Project Scope

This project is a focused CRUD application. It is designed around employee data entry, review, search, sorting, and record maintenance rather than a full HR platform.