/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

17 votes323 views6 answers
Update query laravel
PHP Laravel
5 votes364 views2 answers
Laravel groupby and latest
PHP Laravel
0 vote332 views1 answer
How to create compomemt in laravel livewire
PHP Laravel
0 vote343 views1 answer
Laravel return view in web.php
PHP Laravel
0 vote336 views2 answers
Laravel: customize or extend notifications - database model
PHP Laravel
0 vote355 views1 answer
Add class to row laravel
PHP Laravel
1 vote345 views1 answer
Clear bootstrap cache laravel
PHP Laravel
0 vote295 views2 answers
Laravel db insert get last id
PHP Laravel
10 votes301 views4 answers
Import session laravel
PHP Laravel
2 votes336 views2 answers
Laravel simplexmlelement xml add attribute
PHP Laravel