The website was developed to manage staff profiles. Users can add, modify, and delete records from a web-accessible database table.
Operating System: Microsoft Windows 11
Web Server: XAMPP
Front-End Tech: HTML, CSS, JavaScript
Back-End Tech: PHP 8.2.12, SQL 5.2.1
XAMPP Web Server
XAMPP is a cross-platform web server package that contains Apache, MySQL, PHP, and Perl. As a result, it combines all these technologies in one place for website development. The XAMPP Control Panel provides a user-friendly and comprehensive interface for managing all XAMPP services. It enables users to initiate or terminate services efficiently, monitor logs and security controls, and modify settings.
I performed the following:
Built a responsive front-end using HTML, CSS, and JavaScript, ensuring a clean and intuitive user experience.
Implemented a PHP 8.2.12 back-end to handle form submissions, process CRUD operations, and validate user inputs securely.
Designed and optimized a MySQL 5.2.1 database to efficiently store and manage staff profiles, including names, roles, and contact details.
Integrated role-based access control (RBAC) to ensure only authorized users can modify records.
Hosted the system locally using XAMPP, providing a seamless development and testing environment.
Output Design
The following are the specifications of the system output.
This is used to register new staff members in the system. It contains details about the staff, such as their name, email, and position.
All staff members can be viewed by clicking on the View List button.
A filter is available for conducting specific searches.
Edit:
Use for editing or modification of staff information.
Update Button:
Users can confirm the changes made after editing by clicking the Update button; the staff database will automatically update the current information.
There is a filter to view the staffs that has the same role.
The staff SQL database on XAMPP
The staff SQL database on XAMPP.