Question: You are required to develop a registration form so users can input their username, email and password for registration. You need to use four input

 You are required to develop a registration form so users can

You are required to develop a registration form so users can input their username, email and password for registration. You need to use four input fields to create this registration form and save the file as exercise 1.html in week 10 folder. Layout and style of the web page is up to your discretion. The form should include a text input for username, a text input for password and a text input for email with a submission button. The method for form submission is POST and action is 'exercise 1.php'. 'exercise1.php' will process the form fields and will check for basic validation and insert the new account into your database. . . . add basic server-side validation to make sure the user submitted his details (posted from exercise1.html) and check for empty fields protection against SQL injection should be used through escape_string() when you retrieve username, password and email fields from posted form you need to check if the account already exists, you can check this by selecting a record from the account table with the same username that the user has entered in the form, you can also check the email field so the user cannot register with same email address multiple times. If the username or email is already registered, an error message should be displayed and a redirect to exercise 1.html should be included If the account doesn't exist, you should include some SQL insert statement in the script to add a new record to account table and display a confirmation message on exercise1.php

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!