/PHP/Laravel/Laravel count distance lat/longtidue

Laravel count distance lat/longtidue

$lat = 41.118491 // user's latitude
$lng = 25.404509 // user's longitude

SELECT *, 
( 6371 * acos( cos( radians($lat) ) 
* cos( radians( latitude ) ) 
* cos( radians( longitude ) - radians($lng) ) + sin( radians($lat) ) 
* sin( radians( latitude ) ) ) ) 
AS calculated_distance 
FROM settings as T 
HAVING calculated_distance <= (SELECT distance FROM settings WHERE sid=T.sid) 
ORDER BY distance_calc

Source: stackoverflow.com

Similar codes

0 vote207 views1 answer
Laravel where on relationsship column
PHP Laravel
0 vote218 views1 answer
Laravel extends if
PHP Laravel
5 votes225 views2 answers
Laravel migration price
PHP Laravel
1 vote222 views1 answer
$posts- links() laravel design error
PHP Laravel
0 vote241 views2 answers
Sweet alert confirm box laravel
PHP Laravel
1 vote204 views1 answer
Laravel get first letter of each word
PHP Laravel
19 votes212 views6 answers
Laravel Route Group
PHP Laravel
0 vote223 views2 answers
Laravel collection search
PHP Laravel
11 votes210 views3 answers
Laravel auth 6
PHP Laravel
13 votes223 views6 answers
Laravel migration change column type
PHP Laravel