/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

9 votes296 views3 answers
Make controller laravel 8 with resource
PHP Laravel
10 votes262 views2 answers
Laravel migration default value not working
PHP Laravel
0 vote321 views1 answer
How can we send attached file with notification in gmail in laravel 8
PHP Laravel
0 vote391 views1 answer
Laravel npm run deve error mix
PHP Laravel
7 votes320 views3 answers
Laravel migration seed fresh
PHP Laravel
0 vote316 views1 answer
How to develop package beside laravel project
PHP Laravel
0 vote336 views1 answer
Get basename without extension Laravel
PHP Laravel
49 votes370 views6 answers
Laravel add column to existing table
PHP Laravel
31 votes300 views5 answers
How to make db seeder in laravel
PHP Laravel
2 votes328 views2 answers
Laravel custom model primary Key
PHP Laravel