I'm using Slim framework
to create a REST API
. I'm trying to use two parameters in the url of the method but it gives to me a 404 Page Not Found
error.
Here it's my code:
$app->get("/getUser/:user/:password",function($user,$password) use($app)
{
try{
$connection = getConnection();
$dbh = $connection->prepare("SELECT idUser FROM users WHERE user = ? and password = ?");
$dbh->bindParam(1,$user);
$dbh->bindParam(2,$password);
$dbh->execute();
$user = $dbh->fetchObject();
$connection = null;
header("HTTP/1.1 200");
header("Content-Type:application/json; charset=utf-8");
echo json_encode($user,JSON_UNESCAPED_UNICODE );
}catch(PDOException $e)
{
echo "Error: " . $e->getMessage();
}
});
If I make the method with just one parameter it works but in the same moment I put two methods it doesn't found anything.
Is it possible to send two parameters in the url? How can I do that?
Thanks in advance!
Finally I got the solution to my problem. The problem was on the query. I translated the code to English (the parts that weren't on English before, like variables, etc) for a better comprehesion about my problem.
The problem was there, because the name of the variable password
got a character that I think MySQL
doesn't support and it's when I got the error. Now I changed the name of my variable to password
and it works properly!
I put as an answer because maybe someone has the same problem as me.
1) It is possible to send 2 params in Slim
. 2) Are you sure the value in password param is matching with any of the values in that field?