/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

9 votes196 views6 answers
Pluck laravel
PHP Laravel
0 vote189 views1 answer
How to exclude csrf in a route laravel
PHP Laravel
10 votes227 views3 answers
Check count in laravel
PHP Laravel
0 vote212 views2 answers
Laravel get request in blade
PHP Laravel
3 votes284 views2 answers
Valdidate laravel if falid
PHP Laravel
0 vote182 views2 answers
Laravel blade components
PHP Laravel
0 vote186 views1 answer
Laravel eloquent many to many query using whereHas
PHP Laravel
1 vote187 views1 answer
Laravel Eager Loading
PHP Laravel
11 votes200 views2 answers
Select distinct laravel
PHP Laravel
5 votes209 views2 answers
Laravel print exception message
PHP Laravel