I have a signup form that looks like this and also meet all validation and need PHP to saves and retrieves the database as required below. You don't need to do the javascript, I just need help with the database. Thank you
Sign up First Name:* Enter First Name Minimum 4 characters in length. Should not contains special character Last Name:* Enter Last Name Minimum 4 characters in length. Should not contains special character Phone:* Phone number Phone number must has format (xxx)-(xxx)-(xxxx) or xxx-XXX-XXXX email:* email must contain @ and .com Gender Male Female Other Date Of Birth Day v Month Year v Country Country Password:* Password must have at least 8 characters including 1 lowerletter, 1 upperletter, 1 number, and 1 special symbols Confirm password must be same as password Confirm Password:* I agree to the Terms of use Submit Query Cancel Cancel Task-1: Using PhP and MySQL (Total 10 Marks) 1. For the same form as in Task-1 of Assignment-2, you have to now create a Database and store the entered information into that. (3 marks) 2. For example, enter the information of at least 10 users to be stored into the DB. (2 marks) 3. Next step is to query from the database (i.e. record of a user) and display it in the same form fields. You can design another form for this purpose. (a) For example, you want to retrieve record of a user with First name asJohn. You enter the name "John" in the First Name of your text field. If that name exists in the data base then all of its other information (DoB, Gender, email, etc) shall be displayed in the respective fields else display the message "User with that name do not exist. Try again) (1 mark) (b) Repeat the same steps to find users who are from "Canada". (1 mark) (c) Repeat the same steps to find users who are "male". (1 mark) (d) Repeat the same steps to find users who are female. (1 mark) Note: When the search retrieves more than one records(e.g., users with same last name) then your form should have navigation buttons (Next) and (Previous) to view records from multiple users. (1 mark) Sign up First Name:* Enter First Name Minimum 4 characters in length. Should not contains special character Last Name:* Enter Last Name Minimum 4 characters in length. Should not contains special character Phone:* Phone number Phone number must has format (xxx)-(xxx)-(xxxx) or xxx-XXX-XXXX email:* email must contain @ and .com Gender Male Female Other Date Of Birth Day v Month Year v Country Country Password:* Password must have at least 8 characters including 1 lowerletter, 1 upperletter, 1 number, and 1 special symbols Confirm password must be same as password Confirm Password:* I agree to the Terms of use Submit Query Cancel Cancel Task-1: Using PhP and MySQL (Total 10 Marks) 1. For the same form as in Task-1 of Assignment-2, you have to now create a Database and store the entered information into that. (3 marks) 2. For example, enter the information of at least 10 users to be stored into the DB. (2 marks) 3. Next step is to query from the database (i.e. record of a user) and display it in the same form fields. You can design another form for this purpose. (a) For example, you want to retrieve record of a user with First name asJohn. You enter the name "John" in the First Name of your text field. If that name exists in the data base then all of its other information (DoB, Gender, email, etc) shall be displayed in the respective fields else display the message "User with that name do not exist. Try again) (1 mark) (b) Repeat the same steps to find users who are from "Canada". (1 mark) (c) Repeat the same steps to find users who are "male". (1 mark) (d) Repeat the same steps to find users who are female. (1 mark) Note: When the search retrieves more than one records(e.g., users with same last name) then your form should have navigation buttons (Next) and (Previous) to view records from multiple users. (1 mark)
