/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

0 vote345 views1 answer
Laravel telescope redirect to localhost
PHP Laravel
1 vote345 views1 answer
Date casting from datetime to d-m-Y laravel using cast
PHP Laravel
0 vote336 views1 answer
How to find the name of login user in laravel
PHP Laravel
1 vote340 views2 answers
Laravel 8
PHP Laravel
0 vote252 views1 answer
Laravel eloquent mass assignments
PHP Laravel
12 votes328 views5 answers
Laravel run single migration
PHP Laravel
0 vote363 views1 answer
Laravel blade get array count in Blade
PHP Laravel
3 votes359 views2 answers
Laravel request integer
PHP Laravel
3 votes329 views2 answers
Order number generate laravel
PHP Laravel
0 vote307 views2 answers
Laravel run schedule only on production
PHP Laravel