Level 51
Try with this ...
$app->get('/{paramX}/{paramY}', function ($paramX, $paramY) use ($app) { ...
1 like
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;
});
...
Please or to participate in this conversation.