Can you help me with this problem Module 3 CPL Assignment Instructions In this exercise, you will create a Web page that allows visitors to your site to sign a guest book that is saved to a database 1 Create a new document in your text editor and type the declaration, element, document head, and element Use the strict DTD and Guest Book as the content of the element 2 Add the following text and elements to the document body Enter your name to sign our guest book First Name Last Name 3 Save the document as GuestBook html in the Projects directory for Chapter 8 4 Create a new document in your text editor and type the declaration, element, document head, and element Use the strict DTD and Sign Guest Book as the content of the element 5 Add the following script section to the document body 6 Add the following statements to the script section to ensure that visitors enter their first and last names if (empty($ POST 'fi rst name' ) empty($ POST 'last name' )) echo You must enter your fi rst and last name Click your browser's Back button to return to the Guest Book form 7 Add the following statement to the script section to connect to the database Replace host with the host name of your MySQL server, and user and password with the MySQL user name and password you created in Chapter 7 else $DBConnect mysql connect( host , user , password ) if ($DBConnect FALSE) echo Unable to connect to the database server Error code mysql errno() mysql error() 8 Add the following statements to the end of the script section to create a database named guestbook if it does not already exist else $DBName guestbook if ( mysql select db($DBName, $DBConnect)) $SQLstring CREATE DATABASE $DBName $QueryResult mysql query($SQLstring, $DBConnect) if ($QueryResult FALSE) echo Unable to execute the query Error code mysql errno($DBConnect) mysql error($DBConnect) else echo You are the fi rst visitor mysql select db($DBName, $DBConnect) 9 Add the following statements to the end of the script section to create a table named count if it does not already exist The table consists of a single auto incrementing primary key field named countID $TableName visitors $SQLstring SHOW TABLES LIKE '$TableName' $QueryResult mysql query($SQLstring, $DBConnect) if (mysql num rows($QueryResult) 0) $SQLstring CREATE TABLE $TableName (countID SMALLINT NOT NULL AUTO INCREMENT PRIMARY KEY, last name VARCHAR(40), fi rst name VARCHAR(40)) $QueryResult mysql query($SQLstring, $DBConnect) if ($QueryResult FALSE) echo Unable to create the table Error code mysql errno($DBConnect) mysql error($DBConnect) 10 Finally, add the following statements to the end of the script section These mysql query() statements add the visitor to the database The last statement closes the database connection $LastName stripslashes($ POST 'last name' ) $FirstName stripslashes($ POST 'fi rst name' ) $SQLstring INSERT INTO $TableName VALUES(NULL, '$LastName', '$FirstName') $QueryResult mysql query($SQLstring, $DBConnect) if ($QueryResult FALSE) echo Unable to execute the query Error code mysql errno($DBConnect) mysql error($DBConnect) else echo Thank you for signing our guest book mysql close($DBConnect) 11 Save the document as SignGuestBook php in the Projects directory for Chapter 8 Upload both SignGuestBook php and GuestBook html to the server 12 Open GuestBook html in your Web browser by entering the following URL http PHP Projects Chapter 08 Projects GuestBook html Test the form to see if you can add your name to the database 13 Add two more fake entries into the guest book 14 Login to MYSQL Monitor enter the following command to view all the records in the visitors table mysql SELECT FROM visitors ENTER 15 Take a screenshot of the table and save as YourName Visitors jpg 16 Upload the screenshot(s) to the assignment dropbox in Blackboard

Question

Can you help me with this problem  Module 3 CPL Assignment Instructions In this exercise, you will create a Web page that allows visitors to your site to sign a guest book that is saved to a database  1  Create a new document in your text editor and type the declaration, element, document head, and element  Use the strict DTD and Guest Book as the content of the element  2  Add the following text and elements to the document body  Enter your name to sign our guest book First Name Last Name 3  Save the document as GuestBook html in the Projects directory for Chapter 8  4  Create a new document in your text editor and type the declaration, element, document head, and element  Use the strict DTD and Sign Guest Book as the content of the element  5  Add the following script section to the document body  6  Add the following statements to the script section to ensure that visitors enter their first and last names  if (empty($ POST 'fi rst name' )    empty($  POST 'last name' )) echo   You must enter your fi rst and last name  Click your browser's Back button to return to the Guest Book form     7  Add the following statement to the script section to connect to the database  Replace host with the host name of your MySQL server, and user and password with the MySQL user name and password you created in Chapter 7  else   $DBConnect    mysql connect( host ,  user ,  password )  if ($DBConnect     FALSE) echo   Unable to connect to the database server        Error code     mysql errno()          mysql error()        8  Add the following statements to the end of the script section to create a database named guestbook if it does not already exist  else   $DBName    guestbook   if (  mysql select db($DBName, $DBConnect))   $SQLstring    CREATE DATABASE $DBName   $QueryResult    mysql query($SQLstring, $DBConnect)  if ($QueryResult     FALSE) echo   Unable to execute the query        Error code     mysql  errno($DBConnect)          mysql error($DBConnect)        else echo   You are the fi rst visitor       mysql select db($DBName, $DBConnect)  9  Add the following statements to the end of the script section to create a table named count if it does not already exist  The table consists of a single auto incrementing primary key field named countID $TableName    visitors   $SQLstring    SHOW TABLES LIKE '$TableName'   $QueryResult    mysql query($SQLstring, $DBConnect)  if (mysql num rows($QueryResult)    0)   $SQLstring    CREATE TABLE $TableName (countID SMALLINT NOT NULL AUTO INCREMENT PRIMARY KEY, last name VARCHAR(40), fi rst name VARCHAR(40))   $QueryResult    mysql query($SQLstring, $DBConnect)  if ($QueryResult     FALSE) echo   Unable to create the table        Error code     mysql  errno($DBConnect)          mysql error($DBConnect)        10  Finally, add the following statements to the end of the script section  These mysql query() statements add the visitor to the database  The last statement closes the database connection  $LastName   stripslashes($  POST 'last name' )  $FirstName   stripslashes($  POST 'fi rst name' )  $SQLstring    INSERT INTO $TableName VALUES(NULL, '$LastName', '$FirstName')   $QueryResult    mysql  query($SQLstring, $DBConnect)  if ($QueryResult     FALSE) echo   Unable to execute the query        Error code     mysql  errno($DBConnect)          mysql  error($DBConnect)        else echo   Thank you for signing our guest book       mysql close($DBConnect)      11  Save the document as SignGuestBook php in the Projects directory for Chapter 8  Upload both SignGuestBook php and GuestBook html to the server  12  Open GuestBook html in your Web browser by entering the following URL  http     PHP Projects  Chapter 08 Projects GuestBook html  Test the form to see if you can add your name to the database  13  Add two more fake entries into the guest book  14  Login to MYSQL Monitor enter the following command to view all the records in the visitors table  mysql  SELECT   FROM visitors  ENTER   15  Take a screenshot of the table and save as YourName Visitors jpg 16  Upload the screenshot(s) to the assignment dropbox in Blackboard

SolutionInn · Accepted Answer

The Answer is in the image, click to view ...

Question: Can you help me with this problem: Module 3 CPL Assignment Instructions In this exercise, you will create a Web page that allows visitors to