/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

2 votes180 views2 answers
Laravel show table columns
PHP Laravel
7 votes191 views5 answers
Laravel remove public from url
PHP Laravel
2 votes190 views1 answer
Laravel abort
PHP Laravel
3 votes177 views1 answer
Laravel eloquent increment
PHP Laravel
0 vote225 views1 answer
Spatie laravel pdf image
PHP Laravel
3 votes150 views1 answer
Eloquent first
PHP Laravel
0 vote190 views1 answer
Laravel post request search query
PHP Laravel
1 vote187 views1 answer
Laravel get first letter of each word
PHP Laravel
0 vote175 views1 answer
Laravel model insert multiple
PHP Laravel
15 votes200 views6 answers
Confirm password validation in laravel
PHP Laravel