Simple Code Help

Mr_Chew

I run php from localhost...

test.html

<html>
<form action= "test.php" method="GET">
<TABLE BORDER=1 align="center" CELLPADDING=2 CELLSPACING=2>
<tr>
<td> First name:<input type=text name= "first_name" size=25 maxlength=25</td>
<tr>
<td> Last name:<input type=text name= "last_name" size=25 maxlength=25</td>
<p>
<input type=submit value=send>
</TABLE>
</form>
</html>

test.php

<html>
<?
mysql_connect("localhost", "root", "mypass") or die(mysql_error());
mysql_select_db("test");
$first_name=$_GET['first_name'];
$last_name=$_GET['last_name'];
mysql_query("INSERT INTO 'names' ('first_name','last_name')
	VALUES ('$first_name', '$last_name')");
print ($first_name);
print ($last_name);
print ("Thanks for submitting your info to our database.");
?>
</html>

When I go to http://localhost/test.html and try to submit, i'm taken to a blank white page as if nothing happened.

shaneH

As no one as answered your question yet, I will take a stab at trying to help.

It looks as if you have a couple problems;

First, from my experience it is best to use POST when submiting a form instead of GET.

Second, your submit button needs a name

<input type=submit value=send name=Submit>

Third, you need to have your test.php look for that name.

if(isset($_POST['Submit'])) {   //set variables, run a function, send to database, dispaly to user, ect.

}

If all that fails, I like the term K.I.S.S. (Keep It Simple Stupid) (no insult intended 😃 )

Simply strip out everything from your test.php and do something like this

if(isset($_POST['Submit'])) {
echo "{$_POST['first_name']} {$_POST['last_name']}";
}

If that works slowly build on it. If it doesn't the info isn't getting to the test.php for some reason.

abc123

I agree with what shaneH has said. I'd also mention a couple of things though.

First check that you have error display enabled in you php.ini. If you don't ,and there is an error, it will simply display a blank screen. (Like you are seeing).

Second thing I've noticed is with test.html. Have you forgotted to close your input tags? You've closed the <td> but are missing the final ">" to close off the input tag.

Hope this helps.

jazz_snob

Mr Chew I recommend checking that you actually got a result set from your query. Also, I think there might be problems w/ your SQL. Finally, get into the habit of properly escaping any strings going into the database.


// I write my SQL statements out like this...it makes it easier to quickly see
// what might be missing or to make changes in the future
// but I'm having a hard time getting the text to line up...
// it lines up really nice in my editor  :D 
$sql = "INSERT INTO names(first_name, last_name)
             VALUES('".mysql_real_escape_string($first_name)."',
             '".mysql_real_escape_string($last_name)."')";


if( !( $res = mysql_query($sql) ) ) {
    die( mysql_error());
}

// replaces
//mysql_query("INSERT INTO 'names' ('first_name','last_name')
//    VALUES ('$first_name', '$last_name')");

Mr_Chew

I just realized that I don't think the code is the problem. I took almost all of the code out and did this:

<html>
<form action= "test.php" method="POST">
First name:<input type=text name= "first_name" size=25 maxlength=25>
Last name:<input type=text name= "last_name" size=25 maxlength=25>
<input name=send type=submit id="send" value=send>
</form>
</html>

With the PHP code I did this:

<?
if(isset($_POST['send'])) {
echo "{$_POST['first_name']} {$_POST['last_name']}";
}
?>

When I type anything in the text boxes for first and last name and click submit i am still taken to a blank page. I am using an installation of Apache, MySQl, & PHP called WAMP which is free for download. I went to php.ini and under the Error Handling section I saw display_errors = On... I'm not sure what to do anymore...can someone help?

Houdini

Is you WAMP server running? In you systray there should be a little cloud looking icon if it is yellow one or both services are not running, or if there is a little red ball on a white cloud looking icon then for fure no services are running, left click the icon and make sure to restart all services, then try it again, you should also be able to turn the WAMP server on by start-> WampServer->start Wamp Server.