/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

12 votes346 views4 answers
Laravel return redirect to named route
PHP Laravel
0 vote332 views1 answer
Mysqldump is not recognized as an internal or external command laravel
PHP Laravel
5 votes396 views2 answers
Laravel groupby and latest
PHP Laravel
0 vote359 views1 answer
Laravel cookie (flash meesage for time)
PHP Laravel
0 vote334 views1 answer
Function inside model laravel
PHP Laravel
1 vote351 views1 answer
How to define variable as object in blade laravel
PHP Laravel
2 votes327 views3 answers
Laravel 8 404 status
PHP Laravel
2 votes376 views2 answers
Laravel 8 websockets
PHP Laravel
0 vote348 views1 answer
Rawbetween in laravel
PHP Laravel
0 vote336 views1 answer
Laravel vue build production
PHP Laravel