Please Help

[Anon]

I am trying to understand the new version of php and I am not having any luck. Why doesn't this work.

page ONE:
<FORM ACTION="test.php" METHOD="POST" NAME="TEST">
<input type="text name="test">
<input type="submit" value="test">
</form>

page TWO:
<?php
$which_db="beachbreeders";
if(!$link = mysql_connect("localhost", "test", "test"))
die("No Connect to DB");
if(!mysql_select_db($which_db,$link))
die("No Select DB");
$query = "INSERT into tblBreeder (Name) VALUES (\"$test\")";
$result = mysql_query($query,$link);
?>

Any help would be appreciated.
Thanks in advance

[interactive]

what errors do you get?

[Anon]

Notice: Undefined variable: test in c:\inetpub\wwwroot\beachbreeders\test.php on line 13

[interactive]

which line is line 13 sorry

[Anon]

$query = "INSERT into tblBreeder (Name) VALUES (\"$test\")";

[interactive]

hmm well first off try $query = "INSERT into tblBreeder (Name) VALUES ('$test')";
the page is submitting to the php file right?

[Anon]

I get the same error. Yep it is going to a php file. Someone earlier mentioned that I need to turn on Global Variables... Does that ring a bell to you.

[interactive]

ya in php.ini you do that...

[Anon]

I set it to Off so I could use the old code and not have to worry about it, and it is still not working.

[Anon]

Do I need to restart something after I set it?

[interactive]

i dont think yu have to but its worth a try...

[larry1301]

A couple of things may be causing your problem. The line

<input type="text name="test">

Should be

<input type="text" name="test">

Also you are using the name test for both the form and one of the fields. Try renaming one.

Also you can look at the HTTP_POST_VARS

reset($HTTP_POST_VARS);
while(list($key, $value) = each($HTTP_POST_VARS))
{
echo "$key = $value<br>";
}

to make sure that $test is being received.

[interactive]

lol thats the reason sorry i didn't see that earlier (starts seeing double of the screen i need a cup of coffee)...lol

[Anon]

page TWO:
<?php
$which_db="beachbreeders";
if(!$link = mysql_connect("localhost", "test", "test"))
die("No Connect to DB");
if(!mysql_select_db($which_db,$link))
die("No Select DB");
$query = "INSERT into tblBreeder (Name) VALUES (\"$test\")";
$result = mysql_query($query,$link);
?>

uhm..
replace $test with $HTTP_POST_VARS['test'] ?

[Anon]

RTFM. You'll see that PHP by default has register_globals turned off, and the error/warning/notice level cranked up to maximum. Both are related to patching security holes in previous default configurations.

[Anon]

Ahem... :

http://www.phpbuilder.com/forum/read.php3?num=1&id=139355&loc=0&thread=139355

I am thinking we will get another 20 or so more of these types of "problems".