/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

0 vote349 views2 answers
Laravel collection collect
PHP Laravel
5 votes341 views2 answers
Laravel vue
PHP Laravel
6 votes491 views2 answers
Laravel migration integer
PHP Laravel
7 votes417 views5 answers
Laravel model update table
PHP Laravel
1 vote442 views2 answers
Laravel update only changed fields
PHP Laravel
7 votes393 views6 answers
Laravel get url path
PHP Laravel
13 votes367 views6 answers
Laravel route optional parameter
PHP Laravel
4 votes334 views4 answers
Laravel add request
PHP Laravel
0 vote388 views4 answers
Laravel get last created id
PHP Laravel
53 votes504 views6 answers
Laravel join
PHP Laravel