Error in database

[udaikr]

hello friends i am new in php ,want to add form with database ,but a error appeared ,

( ! ) Notice: Undefined variable: name in C:wampwwwyour_mailregister.php on line 26 Call Stack # Time Memory Function Location 1 0.0521 142664 {main}( ) ..register.php:0 ( ! ) Notice: Undefined variable: email in C:wampwwwyour_mailregister.php on line 26 Call Stack # Time Memory Function Location 1 0.0521 142664 {main}( ) ..register.php:0

this is my code can anyone help me.

if(isset($_POST['name'])){

$name = $_POST['name'];

$email = $_POST['email'];

$password = $_POST['password'];

}

$query = "INSERT INTO users

(id,name,email,password,added_date,modified_date,status)

VALUES

('','$name','$email','$password','NOW()','','0') ";

[Ingolme]

The variables are only being set if $_POST['name'] is set. Since $_POST['name'] isn't set, there's an error when trying to use those variables.

[udaikr]

I used isset in this code but it appears ,why ,i am confused with the use of isset can you please explain.

[justsomeguy]

You get the variables only if they are set in $_POST. You always run the query though. So if the variables are not set then you will run the query with missing variables. Either put the query inside the if statement also so that you only run the query if the variables are set, or if you want to run the query even when the variables are not in $_POST then give $name, $email, and $password default values if they aren't in $_POST.

[Sora]

Put the query within the curly brackets.

It would work without isset by the way.

[udaikr]

thanks

[es131245]

offtopic but no need in empty brakets

$query = "INSERT INTO users

(name,email,password,added_date,status)

VALUES

('$name','$email','$password','NOW()',,'0');

$query = "INSERT INTO users

(id,name,email,password,added_date,modified_date,status)

VALUES

('','$name','$email','$password','NOW()','','0') "

 

Edited November 14, 2013 by es131245