Web-Based Employee Onboarding System Using HTML, PHP, and MySQL
Question 1 (70 marks)
A mid-sized company has hired you to develop an internal web-based Employee Onboarding System. The HR department needs a tool to manage employee information efficiently. The system should have the following features:
- Employee Registration:
- A form that collects employee details such as name, email, position, department, and start date. The form should use HTML and PHP for form handling.
- After submission, the form data should be stored in a MySQL database.
- Employee List:
- A page that lists all registered employees, pulling data from the MySQL database. Use arrays to process and display the data.
- Include options to view, update, and delete individual employee records.
- Employee Profile:
- A detailed view of each employee’s information. This page should be accessible from the employee list and display all stored details of a selected employee.
- Update Employee Information:
- A form to update an employee’s details. Upon submission, the changes should be saved to the MySQL database.
- Delete Employee:
- A feature that allows the deletion of an employee’s record from the database.
- Security Considerations:
- Implement measures to prevent SQL injection attacks. This may include using prepared statements in PHP.
Requirements:
- HTML: Design a user-friendly interface using HTML forms to collect and display data.
- PHP: Use PHP for form handling, processing data, and interacting with the MySQL database.
- Arrays: Utilize arrays in PHP to manage and display data retrieved from the database.
- MySQL CRUD Operations: Implement Create, Read, Update, and Delete operations using MySQL.
- SQL Injection Prevention: Demonstrate understanding of security by protecting the application against SQL injection attacks.
Rubric
| Criteria | Description | Marks |
| HTML Forms and Interface Design | User-friendly and intuitive form design. 5 Marks Use HTML elements for input validation (e.g., required fields, appropriate input types). 5 Marks | 10 |
| PHP Form Handling | Correct handling of form submissions, including data validation and error handling. 10 marks Proper use of arrays for data processing. 5 marks | 15 |
| MySQL CRUD Operations | Correct implementation of the Create operation (inserting data into the database). 5 marks | 20 |
| Correct implementation of the Read operation (retrieving and displaying data from the database). 5 marks Correct implementation of the Update operation (modifying existing records). 5 marks Correct implementation of the Delete operation (removing records from the database). 5 marks | ||
| SQL Injection Prevention | Implementation of prepared statements or other security measures to prevent SQL injection. 15 marks | 15 |
| Code Quality and Documentation | Code readability and organisation (e.g., use of comments, indentation, naming conventions). 5 marks Adequate documentation of the project 5 marks | 10 |
Sample Programming Answers: Web-Based Employee Onboarding System
This project provides an end to end development of a secure internal HR tool using core web technologies. The application is aimed at solving the problems of data management, usability and security.
HTML: Forms and Interface Design
The form that is considered is a user friendly form in the sense that it is very clean and it allows for employee registration. It is developed using HTML5. The fields included are Name, Email, Position, Department and Start Date. The HTML utilised is semantic structure to allow for better accessibility.
| Disclaimer: This answer is a model for study and reference purposes only. Please do not submit it as your own work. |
