/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 vote180 views1 answer
Laravel multiple group by
PHP Laravel
3 votes169 views1 answer
How to named route resource laravel
PHP Laravel
39 votes235 views3 answers
Add new column to existing table laravel
PHP Laravel
0 vote166 views2 answers
What is composer in laravel
PHP Laravel
9 votes166 views6 answers
Get raw query laravel
PHP Laravel
0 vote163 views1 answer
Laravel return view with multiple variable
PHP Laravel
0 vote163 views1 answer
Laravel eloquent set timestamps values upon seed
PHP Laravel
0 vote260 views1 answer
Users not having any role laravel spatie
PHP Laravel
6 votes189 views3 answers
Laravel route namespace
PHP Laravel
4 votes167 views2 answers
Numbric validate laravel
PHP Laravel