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

Enter your name to sign our guest book

First Name

Last Name

-----------------------------------------------------------------------------------------

SignGuestBook.php

if (empty($_POST['first_name']) || empty($_POST['last_name']))

echo "

You must enter your first and last name! Click your

browser's Back button to return to the Guest Book form.

";

else {$DBConnect = @mysql_connect("localhost", "root","password");

if ($DBConnect === FALSE)

echo "

Unable to connect to the database server.

".

"

Error code " . mysql_errno(). ": " . mysql_error() . "

";

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 first visitor!

";

}

mysql_select_db($DBName, $DBConnect);

$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) ."

";

$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);

}

}

?>