/PHP/Laravel/Get nearby from longitude and latitude in laravel

Get nearby from longitude and latitude in laravel

\DB::table("users")
     ->select("users.id", \DB::raw("6371 * acos(cos(radians(" . $this->lat . "))
     * cos(radians(users.latitude)) 
     * cos(radians(users.longitude) - radians(" . $this->lng . ")) 
     + sin(radians(" .$this->lat. ")) 
     * sin(radians(users.latitude))) AS distance"))
     ->having('distance', '<', $this->rad)
     ->first();

Source: stackoverflow.com

Similar codes

1 vote375 views2 answers
Get the value without setter method laravel
PHP Laravel
0 vote331 views1 answer
Laravel mix build as umd
PHP Laravel
1 vote403 views1 answer
$posts- links() laravel design error
PHP Laravel
0 vote405 views1 answer
Laravel reload relationship
PHP Laravel
3 votes385 views2 answers
Clear log file laravel command
PHP Laravel
0 vote337 views1 answer
Laravel disable config cache
PHP Laravel
0 vote341 views6 answers
Sanctum laravel
PHP Laravel
0 vote349 views1 answer
Publish Spatie Laravel Permission
PHP Laravel
0 vote324 views1 answer
Get random post laravel
PHP Laravel
0 vote350 views1 answer
Laravel php 8 ububtu
PHP Laravel