将数据添加到数据库

Question

When I try to add a user to the database with POST a new user is added but all fields are Null.
Any help guys ? Thank you in advance.This is my source code:

if($_SERVER['REQUEST_METHOD'] == "POST")                    
{
 // Get data

$name = isset($_POST['name']) ;

 $email = isset($_POST['email']);

 $password = isset($_POST['password']);

 $status = isset($_POST['status']);

 // Insert data into data base

 $sql = "INSERT INTO users (`name`, `email`, `password`, `status`) VALUES     ('$name', '$email', '$password', '$status')";

 $qur = mysql_query($sql);

if($qur){

$json = array("status" => 1, "msg" => "Done User added!");

}else{

 $json = array("status" => 0, "msg" => "Error adding user!");

 }

}else{

$json = array("status" => 0, "msg" => "Request method not accepted");

}


@mysql_close($conn);

/* Output header */

header('Content-type: application/json');

echo json_encode($json);

**

Answer 1

isset return only true or false so if you want to insert value you can check it with if condition replace your code with above it will be work fine

    if($_SERVER['REQUEST_METHOD'] == "POST"){
$name = (isset($_POST['name']))?$_POST['name']:'' ;
$email = (isset($_POST['email']))?$_POST['email']:'';
$password = (isset($_POST['password']))?$_POST['password']:'';
$status = (isset($_POST['status']))?$_POST['status']:'';
$sql = "INSERT INTO users (`name`, `email`, `password`, `status`) VALUES     ('$name', '$email', '$password', '$status')";
$qur = mysql_query($sql);
if($qur){
$json = array("status" => 1, "msg" => "Done User added!");
}else{
 $json = array("status" => 0, "msg" => "Error adding user!");
}
}else{
$json = array("status" => 0, "msg" => "Request method not accepted");
}
@mysql_close($conn);
header('Content-type: application/json');
echo json_encode($json);

save this form in html file and check it with this edited example

    <form method="post">
<input type="text" name="name" value="Red Symbol" />
<input type="text" name="email" value="[e-mail]" />
<input type="text" name="password" value="chock" />
<input type="text" name="status" value="1" />
<input type="submit" name="submit" value="Submit" />
</form>