Probably a dumb problem

kfalise

I am trying to insert data in through a html form and it creates a row in the database but the data is blank

$desimp=implode($design_array, ",");
$desarray=array($desimp,$desother);
$finarray=implode($desarray,"");
$design=str_replace("Other","",$finarray);

if($remedy =='Other'){
        $remedyreturn=$remother;
}
else{
        $remedyreturn=$remedy;
}

$sql="INSERT INTO test(firstname,lastname) VALUES ('$firstname','$lastname')";

$result=mysql_query($sql);

mysql_close();

and the html

<p><font size="5">Welcome to the Employee</font></p>
<p><font size="5">Check-In Page</font></p>
<p> </p>
<p align="left"><font size="3">Please Enter Personnel Information:</font></p>
<form method="post" action="name.php">
<p align="center"><font size="3">First Name:
<input name="f_name" type="text" size="20">
Last Name:
<input name="l_name" type="text" size="20">
</font></p>
<p align="center"> </p>
<p align="right"><font size="3">
<input type="Submit" value="Submit">
</font></p>
</form>

Any help will be greatly appreciated.

Pig

You have different names for your variables in the process page...

this produces varaiables: $f_name and $l_name not $firstname, $lastname.

Your sql should be:
$sql="INSERT INTO test(firstname,lastname) VALUES ('$f_name','$l_name')";

kfalise

oh i caught that, and changed it. it still is giving me o values

<p><font size="5">Welcome to the Employee</font></p>
<p><font size="5">Check-In Page</font></p>
<p> </p>
<p align="left"><font size="3">Please Enter Personnel Information:</font></p>
<form method="post" action="name.php">
<p align="center"><font size="3">First Name:
<input name="firstname" type="text" size="20">
Last Name:
<input name="lastname" type="text" size="20">
</font></p>
<p align="center"> </p>
<p align="right"><font size="3">
<input type="Submit" value="Submit">
</font></p>

Pig

Have you had other forms work succesfully? You might have autoglobals turned off. Test to see if your vars are getting transferred. Put this at the top of your process page:

echo("if you see this: $firstname, then autoglobals are on.<br>");

you can always access a var without autoglobals being by accessing the POST array: $_POST['firstname']

You should always try echoing out your vars before the $sql when you are debugging, to see where the failure is.

kfalise

Thats it. Is there an easy way to turn on the autoglobals?

Pig

You have to edit your php.ini. Check with your host.

superwormy

You shouldn't be using the register_globals stuff, you should be using $GET and $POST variables instead. See the PHP manual under 'predefined variables'

$GET['f_name'] ( somethign passed through URL )
$POST['f_name'] ( somethign posted through a form )
$_REQUEST['f_name'] ( something from somewhere... cookie, get or post )

$_COOKIE['f_name'] ( value from a client-side cookie )

kfalise

i am my own host, this is a test project for the university i am at. i turned on the register_globals on is there anyother settings i need

kfalise

figured it out thanks for all the help. i need to restart my server after the php.ini changes

Pig

glad it worked out.