/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

13 votes127 views3 answers
Laravel string
PHP Laravel
0 vote113 views1 answer
Configuration laravel dompdf
PHP Laravel
0 vote74 views1 answer
Laravel, if ->get() array is not emtpy
PHP Laravel
2 votes128 views4 answers
Failed to clear cache. make sure you have the appropriate permissions. laravel
PHP Laravel
0 vote146 views2 answers
Laravel Read CSV File
PHP Laravel
-1 vote140 views1 answer
Laravel edit form select don't repeat a selected value
PHP Laravel
1 vote142 views2 answers
Where clause with paginate laravel multiple column
PHP Laravel
0 vote132 views1 answer
Laravel chain query builder
PHP Laravel
0 vote132 views1 answer
Create symbolic in lumen laravel
PHP Laravel
0 vote141 views1 answer
Laravel 6 use username instead of id
PHP Laravel