Event Registration and Attendance System using PHP/MySQLi
The Event Registration and Attendance System is a simple PHP/MySQLi project that can help an organization or business that needed an online or automated event registration and attendance system. This system has 2 sides of User Interface which is the admin side and the registrar's side. Use case diagrams are used at the development of software and systems for definition of functional system requirements or system of systems. A Use case diagram presents the consecution of object’s actions (user’s or system’s) which are executed for reaching the definite result.
System Functionality and Management
This system stores multiple upcoming events along with the event's schedule, venue, and details. The events registration and attendance will be automatically open for the registrar's access when the current date is equal to the event schedule. The admin must assign 1 or more registrar user to access the event to register and manage the attendance of the attendees of the event until the admin will close the registration and attendance of the event.
Core Admin Features
- Login Page: The page where the admin user submits their system credentials to access the admin side of the system.
- New Event Page: The page where the admin user creates a new event.
- Event List Page: The page where all the events are listed and navigate to edit, view, and delete an event.
- Attendance Page: The page where the attendance report per event is being displayed.
- User List Page: The page where the system users are listed and navigate to edit, view, and delete users.
Core Registrar Features
- Events Page: The page where the events assigned to the logged-in registrar.
- Event's Attendees List Page: This is the page where the registrar toggle the switch button on updating the attendees' attendance.
- Event Attendees Registration Modal: The popup modal where the registrar submits the new event attendee's details.
- Registrar's Manage Account Page: The page where the registrars manage his/her system credentials.
Technical Specifications
The Event Registration and Attendance System was developed using HTML, PHP/MySQLi, CSS, JavaScript (jQuery/Ajax), and Bootstrap for the design. The source code is fully functional and easy to modify or enhance.
| System Data Feature | Description |
|---|---|
| Event Storage | Stores upcoming events with schedule, venue, and details. |
| Access Roles | Dual interface: Admin side and Registrar side. |
| Reporting | Generates an attendance report for each event (ready to print). |
| Database | Utilizes PHP/MySQLi with eras_db. |
System Implementation and Setup
A New Member Registration Data Flow Diagram illustrates the flow of information and processes involved in registering new members within a system, including data inputs, processing steps, and outputs. It provides a visual representation of the registration workflow, facilitating the understanding of how data moves through the system. For the installation, follow the instruction below to have an actual experience using this simple project:
- Download the source code and extract the zip file.
- Download or set up any local web server that runs PHP script.
- Open the web-server database and create a new database name it eras_db.
- Import the SQL file located in the database folder of the source code.
- Copy and paste the source code to the location where your local web server accessing your local projects.
Default Admin Access credentials are provided as follows: Email: [email protected] and Password: admin123.
