Start the database: systemctl start mariadb

Login to the database: mysql $-$u root$$

Set a password for root: set password $=$ password$("$passw$0$rd$")$;$$

Create a database called addressbook: create database addressbook;$$

Make the addressbook database the current database: use addressbook;$$

Create a table called address: CREATE TABLE address $($id INT$(4)$ NOT NULL AUTO$\_$INCREMENT PRIMARY KEY, lastname VARCHAR$(30),$ firstname VARCHAR$(30),$ phone VARCHAR$(30),$ email VARCHAR$(30))$;

Create a user to be used from the web application and set the password: create user $\text{'}$www$\text{'}$@'localhost' identified by 'wwwUSERpass';$$

Give the www user permissions to the table: grant select, insert, delete, update on address to $\text{'}$www$\text{'}$@'localhost';$$

Type quit to get out of mysql$.$

Edit $/$var$/$www$/$html$/$rds$.$conf.php to set the connection to match the settings you just created. The database is on the local server so the $RDS$\_$URL variable should be set to localhost.$$ $RDS$\_$DB should be set to the name of the database you created.$$ $RDS$\_$user should be set to the name of the user you created to use from the web application.$$ $RDS$\_$pwd should be set to the password you gave the user when you created it$.$

Restart httpd$.$

Access the webapp by putting the IP address or dns name of your server followed by $/$addressbook$.$php in the browser. Did it work? It should show you a table and a link to add a contact.$$ If you just put your IP address or domain name it will likely show you the index.html from the earlier learning module.$$ If it did not work, check the troubleshooting steps below.

Once you get the Add Contact link test by adding a few records to your address book.$$

Make sure you have made the necessary modifications to have mariadb start at boot.

Edit $/$var$/$www$/$html$/$rds$.$conf.php to set the connection to match the settings you just created. The database is on the local server so the $RDS$\_$URL variable should be set to localhost.$$ $RDS$\_$DB should be set to the name of the database you created.$$ $RDS$\_$user should be set to the name of the user you created to use from the webapp.$$ $RDS$\_$pwd should be set to the password you gave the user when you created it$.$

There are the variables that need to be set:

$RDS$\_$URL

$RDS$\_$DB

$RDS$\_$user

$RDS$\_$pwd

$RDS$\_$URL is where the database is running and I told you what to set for that.

For the other $3$ I said to make sure they match what was configured in the database.$$ Here are the $2$ commands where you should get the needed information:

create database addressbook;

create user $\text{'}$www$\text{'}$@'localhost' identified by 'wwwUSERpass';$$

The user is www$,$ not www@localhost.

$\text{'}$;

$?>$

include$(\text{'}$rds$.$conf.php$\text{'})$;

$//$ Set address book variables

isset$($$$\_$REQUEST$[\text{'}$mode$\text{'}])?$ $mode$=$$$\_$REQUEST$[\text{'}$mode$\text{'}]$ : $mode$=""$;

isset$($$$\_$REQUEST$[\text{'}$id$\text{'}])?$ $id$=$$$\_$REQUEST$[\text{'}$id$\text{'}]$ : $id$=""$;

isset$($$$\_$REQUEST$[\text{'}$lastname$\text{'}])?$ $lastname$=$$$\_$REQUEST$[\text{'}$lastname$\text{'}]$ : $lastname$=""$; isset$($$$\_$REQUEST$[\text{'}$firstname$\text{'}])?$ $firstname$=$$$\_$REQUEST$[\text{'}$firstname$\text{'}]$ : $firstname$=""$; isset$($$$\_$REQUEST$[\text{'}$phone$\text{'}])?$ $phone$=$$$\_$REQUEST$[\text{'}$phone$\text{'}]$ : $phone$=""$;

isset$($$$\_$REQUEST$[\text{'}$email$\text{'}])?$ $email$=$$$\_$REQUEST$[\text{'}$email$\text{'}]$ : $email$=""$;

$//$ Connect to the RDS database

$connect$=$mysqli$\_$connect$($$RDS$\_$URL, $RDS$\_$user, $RDS$\_$pwd $)$ or die$($mysqli$\_$error$($$connect$))$;

mysqli$\_$select$\_$db$($$connect, $RDS$\_$DB $)$ or die$($mysqli$\_$error$($$connect$))$;

if $($ $mode$==$"add"$)$

$\{$

Print $\text{'}$