Description of the problem
(2 marks)
Your outline should identify the Advanced Higher concepts and the integration with one other technology that will be used in your project.
(150-300 words)
A swimming club organises an annual competition for its members. The club requires a website that allows members to register online. The system must let members submit their details through a form, view a summary of their submission, and prevent multiple submissions during the same session.
How my project will meet the Advanced Higher concepts
Form elements (action, method, and name)
The registration page will use an HTML form with an action pointing to a PHP script. It will use the POST method for secure submission, and use name attributes in the registration form so PHP can retrieve the values for processing.
External CSS
Styling will be in an external CSS file linked to each page.
Multiple layouts using a media query
A CSS media query will adjust the layout for both phones and desktop.
Use of session variables
A PHP session variable will be set after successful registration. If the member revisits during the same session, the homepage will display a personalised “You have already registered” message instead of the form.
Server-side processing (PHP)
PHP will assign variables from the registration form data, create an SQL query using those variables, and insert the data as a new record in the database.
How my project will meet the integration requirements
Create a database with at least one table
A MySQL table named registrations will store each member’s name, email, age group, and chosen event.
Open or close the database connection to execute an SQL query
PHP will open a connection to the database using mysqli, run an INSERT query, and close the connection.