A piece of PHP code that I developed successfully registers user details from my iPhone app and returns JSON output. Here is the code snippet:
header('Content-type: application/json');
include 'connection.php';
$response = array();
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
if($username == NULL || $password == NULL || $email == NULL ){
$response["success"] = 0;
$response["message"] = "Something Empty";
}else{
$sql = "INSERT INTO User (username, password, email)
VALUES ('".$username."', '".$password."', '".$email."')";
if ($conn->query($sql) === TRUE) {
$response["success"] = 1;
$response["message"] = "Done";
} else {
$response["success"] = 0;
$response["message"] = "Error";
}
}
echo json_encode($response);
$conn->close();
However, when attempting to check if a username already exists before adding it to the database table, an error occurs as indicated in the Xcode Log.
JSON text did not start with array or object and option to allow fragments not set.if($username == NULL || $password == NULL || $email == NULL ){
$response["success"] = 0;
$response["message"] = "Something Empty";
}else{
$query = mysql_query("SELECT * FROM User WHERE username='".$username."'");
if (mysql_num_rows($query) != 0)
{
$response["success"] = 0;
$response["message"] = "Username Already Exists";
}else{
$response["success"] = 1;
$response["message"] = "That Name Fine";
}
}