Bariseray's avatar

Passing 2 parameters from a route to a raw sql query

I'm trying to pass 2 parameters from a route to an sql query but can't seem to be able to do it. The query itself works with hardcoded values but can't seem to be able to pass the parameters to it.

...

$app->get('/{paramX}-{paramY}', function ($paramX, $paramY) use ($app) {

$results = DB::select("SELECT *, ( 3959 * acos( cos( radians(paramX) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-paramY) ) + sin( radians(paramX) ) * sin( radians( latitude ) ) ) ) AS distance FROM properties HAVING distance < 80 ORDER BY distance LIMIT 0 , 20");

return $results;

});

...

0 likes
2 replies
tomopongrac's avatar

Try with this ...

$app->get('/{paramX}/{paramY}', function ($paramX, $paramY) use ($app) { ...
1 like
Bariseray's avatar

Thanks, that worked after adding them as $paramX to the sql too

Please or to participate in this conversation.