Instructions (1) Create an empty folder in the root directory [c: wamp64 wwwand name it as YourFirstName_IDNumber_SetE" (Eg. Muncer_16J123_SetE). This will be your web application project folder 2) Download setErar resource file from the E-Learning portal and directly save it into your project folder in the wamp server root directory (3) Extract the file seth.rar and the set folder contains the following supporting files dbconnection.php dbscript sol (4) Use dbscript.php and execute the script using phpMyAdmin in order to create the database and its associated tables. (5) Use dbconnection.sql to connect your front-end and back-end applications (6) Design the PHP Forms using Microsoft Web Expression and write the PHP Script according to the tasks given in various sections below. Section A: Registration 19 Marks No Design a form (regcust.php) which allows a new customer to register with the application Use appropriate controls to accept the following inputs from the user Customer Code Customer Name Email (Use Email as the User Name) Password 2 Write PHP scripts to save the new Customer details in the table once the form is submitted. as per the following criteria 2.1 Use the appropriate PHP form to connect with MySQL database 2.2 The input to Customer code must have only 5 digits, otherwise show a warning message to the user. The message should be shown near to the Customer Code textbox. 2.3 The input to the Email (Validate the Email Address) must be in the proper email format; otherwise show a waming message to the uset. The message should be shown near to the Email textbox 2.4 After successful registration, the Customer must be redirected to the login page. Page of 14 Marks Section B: Login No Task | Design a form (login.php) which allows a registered customer to login to the application with User Name and Password. Use Email as the User Name. 2. Write PHP scripts to allow the customer to login with the User Name and Password once the form is submitted. 2.1 Use the appropriate PHP form to connect with MySQL Database. 2.2 Validate the User Name and Password of the customer. Display appropriate error message within the form surface, if the User Name Password is invalid. If the User Name Password is valid, the customer must be redirected to displaycustomer page 2.3 If the User Name Password is empty, display appropriate error messages within the form surface. 2.4 Add a button in the login form and write PHP scripts to redirect to customer registration page. Task Section C: View 13 Marks No Create a form displaycustomer.php and write PHP scripts to view the registered customers in a table. Display all the data in any format in the web page except password. 1.1 Use the appropriate PHP form to connect with MySQL Database. 1.2 Display a hyperlink in cach row of the table to delete the records and label it as DELETE'. When the DELETE link is clicked, the corresponding record must be deleted. NOTE: Write the PHP script of DELETE function in a separate page (customerdelete.php). 1.3 Display an alert before performing the deletion of a record. Section D: Delete 4 Marks No Task | Create a form customerdelete.php and write PHP scripts to delete the record selected in the display customer.php page. LI Use the appropriate PHP form to connect with MySQL Database 1.2 The deletion process must be done based on the primary key of the concemed table. 1.3 Redirect the user to displayeustomer.php page after the deletion of the record. Note Compress the solution folder and upload it in the e-leaming page without delay
