Reference no: EM131877916

Assignment

1. Create a database (do NOT use designstudio1) for your individual project. Name your database as first initial+last name (e.g. John Dow should create database jdow).

2. Create a table called "services". Insert records to indicate what services are available. This table must be used to populate the checkbox group (or drop-down list) for services on your form.

The table must have at least the following columns:

• primary key - AUTO_INCREMENT
• service description

Create a database user (do NOT use proxy_user) that will have permissions to SELECT services from your table.

3. Add a table that will be used to keep profile information. The table must have at least the following columns:

• primary key - AUTO_INCREMENT
• first name
• last name
• email
• post date
• availability
• yes/no for notification email

Give the database user you just created (do not use proxy_user) permissions to insert and select records from profile table.

You can also add another table "services provided" that will map profiles to services. It is not required in this lab, but will be required in the individual project. Do not confuse this with the "services" table. The "services" table is only used to populate the services checkbox group on the registration page, whereas the "services provided" table is used to store the data user entered on the form.

4. Create user interface:

• Use the registration form you created for your individual project. Modify it to display services checkbox group from the "services" table (2 points).

• Modify php code you wrote in the previous module to collect information from the form and use mysqli to insert it in the profile table. (Note: if you created "services provided" table, you will have to run two insert statements.)

• After information is inserted, display a confirmation page that lists all submission details. You can either echo $_POST or select information from the database.

Use of mySQLi and prepared statements are required for all operations.

You php code has to be similar to the examples from this module.