/PHP/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

1 vote161 views2 answers
Explode function in laravel
PHP Laravel
121 votes323 views6 answers
Check if a String Contains a Substring in PHP
PHP
0 vote137 views1 answer
How to exclude csrf in a route laravel
PHP Laravel
0 vote168 views1 answer
Imagefont.truetype python don't work
PHP
7 votes132 views2 answers
Laravel get session variable in controller
PHP
8 votes126 views2 answers
Laravel Edit
PHP
0 vote138 views1 answer
Datetime-local laravel migration data type
PHP
0 vote128 views1 answer
Menyimpan get di laravel
PHP
1 vote132 views1 answer
Clear cache using laravel controller
PHP
17 votes122 views3 answers
Debug wordpress
PHP