Problem inserting Data into Mysql via Php form

[keroleen]

Im trying to insert data into MySql database but it inserts blank fields.

This is the code i am using <br><br>

<?PHP
$connection=mysql_connect("localhost","root") or die('Could not connect to the database server');

$db = mysql_select_db("test", $connection) or die ("Unable to select database.");

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

mysql_query($sql,$connection) or die ('Could not insert data');

mysql_close($connection);

?>

Thanks in advance

[packland]

this should work

$firstname = "atrax";
$lastname = "robustus";
$sql = "INSERT INTO user (firstname,lastname) VALUES (".$firstname.",".$lastname.")";
print $sql;

the dots that separate the fragments of text simply join the bits together.

try printing the sql to see what you have?

[cahva]

I think you have register_globals turned off(like it should be)

Use $_POST when making that query:

<?PHP 
$connection=mysql_connect("localhost","root") or die('Could not connect to the database server'); 

$db = mysql_select_db("test", $connection) or die ("Unable to select database."); 

$sql = "INSERT INTO user (firstname,lastname) VALUES ('".$_POST['firstname']."','".$_POST['lastname']."')"; 

mysql_query($sql,$connection) or die ('Could not insert data'); 


mysql_close($connection); 

?> 

[keroleen]

Thanks everyone for your help.

You are right, I had to use the $POST method. But actually post didnt work so i used $GET.
Just wondering tho, why doesnt this variable method work? But $_POST will work?

[cahva]

Forms are send using method 'get' by default. If you used METHOD=POST in your form, it would work using $_POST

[cahva]

BTW, you should use post in your form if you are inserting users and their passwords to your db