Submit not working

Anon

Anyone can help me, why this code works like if the submit button is not working?.

Thanks for your help:

<?php;
if ($acepta)
{
$db = mysql_connect("localhost","root","");
mysql_select_db("learndb",$db);
$sql = "insert into personnel (firstname,lastname,nick,email,salary)";
$sql = $sql ." values ($first,$last,$nickname,$email,$salary);";
echo $sql ;
echo "<br><br>";
echo '$first';

$result = mysql_query($sql) ;
echo "Informacion ha sido guardada." ;
}

else
{
?>
<form method="post" action="input.php">
Nombre: <input type= "Text" name="first"><br>
Apellido: <input type="Text" name="last"><br>
Nickname: <input type="Text" name="nickname"><br>
E-Mail:<input type="text" name="email"><br>
Sueldo:<input type="text"name="salary"><br>
<input type="SUBMIT" name="acepta" value="Enter Info">
</form>
<?}

crusty_php

try

$sql = $sql ." values ('$first','$last','$nickname','$email','$salary');";

Anon

Thanks Martin, I know that.

However the point is never get into the if, in other words like never push the submit button.

Try the code and you'll see, omitt the data input just test printing the content of any var.

Thank you anyway.

Anon

$acepta is a pushbutton, therefore it will be submitted, but it won't have a value (it will have a value of NULL). And in the context of conditional statements, NULL is considered "false" so your IF statement is always false. Try this instead:

if (isset($acepta)) {

Diego

crusty_php

Sorry Josue, try this

<?php;
if ($acepta)
{
$db = mysql_connect("localhost","root","");
mysql_select_db("learndb",$db);
$sql = "insert into personnel (firstname,lastname,nick,email,salary)";
$sql.=" values ('$first','$last','$nickname','$email','$salary')";
echo $sql ;
echo "<br><br>";
echo $first;

//$result = mysql_query($sql) ;
echo " Informacion ha sido guardada." ;
}
else
{
?>
<form method="post" action="<? echo $PHP_SELF;?>">
Nombre: <input type= "Text" name="first"><br>
Apellido: <input type="Text" name="last"><br>
Nickname: <input type="Text" name="nickname"><br>
E-Mail:<input type="text" name="email"><br>
Sueldo:<input type="text"name="salary"><br>
<input type="SUBMIT" name="acepta" value="Enter Info">
</form>
<?}