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!
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
Get step-by-step solutions from verified subject matter experts
