Question: I am having an issue. When i press submit to test the code, it goes to a blank screen. Please, will some one assist me?

I am having an issue. When i press submit to test the code, it goes to a blank screen. Please, will some one assist me? Thanks!

Sign Guest Book

if (empty($_POST['?rst_name']) || empty($_POST['last_name'])) echo "

You must enter your ?rst and last name! Click your browser's Back button to return to the Guest Book form.

"; else { $DBConnect = @mysql_connect("localhost", "root", ""); 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 ?rst visitor!

"; } mysql_select_db($DBName, $DBConnect);

$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), first_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['?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); } }

?>

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!