I try to get data from mysql table using php and alamofire in swift, but i can't, this is my code:
guard
let useremail = emailTextField.text,
let password = passWordTestField.text
else { return }
let parameters: Parameters = [
"useremail": useremail,
"password": password
]
let api = URL(string: "anyurl/Authentication.php")
AF.request(api!, method:.get, parameters: parameters).responseDecodable(of: SignIn.self) { response in
print(response.data as Any)
if let data = response.data {
guard let dataDecoded = try? JSONDecoder().decode(Reponse.self, from: data) else {
print("An error taked place")
return
}
if dataDecoded.error == false {
print("it is done")
}else {
print("it isn't done")
}
}
}
SignIn:
struct SignIn: Codable {
let useremail: String
let password: String
}
Reponse:
struct Reponse: Codable {
let error: Bool
let message: String
}
PHP:
<?php
include_once ('Connection.php');
$name = $_POST['username'];
$password = $_POST['password'];
$sql = "SELECT username, password from user where useremail = '$useremail' AND password ='$password'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$response['error']=false;
$response['message']="New record created successfully";
} else {
$response['error']=true;
$response['message']="Error: " . $sql . "<br>" . mysqli_error($conn);
}
echo json_encode($response);
$conn->close();
?>
note, that i use the same code for INSERT and it is done successfully. in previous code, I always get (An error taked place)