/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 vote204 views1 answer
Laravel order by raw
PHP Laravel
8 votes142 views1 answer
Laravel get variable from url
PHP Laravel
5 votes177 views2 answers
Laravel chmod
PHP Laravel
32 votes229 views4 answers
Laravel seed fresh
PHP Laravel
0 vote198 views1 answer
Laravel collection max
PHP Laravel
6 votes228 views6 answers
Laravel get current route name
PHP Laravel
0 vote175 views1 answer
Composer new project laravel acl
PHP Laravel
1 vote193 views5 answers
Check if value change laravel
PHP Laravel
2 votes195 views2 answers
Laravel abort with message
PHP Laravel
0 vote182 views10 answers
Laravel relations find
PHP Laravel