/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 vote257 views1 answer
Laravel Dropzone Attachment Required is not working as expected
PHP Laravel
0 vote265 views1 answer
Laravel collection times
PHP Laravel
0 vote295 views1 answer
Laravel app running in console
PHP Laravel
1 vote307 views1 answer
Datediff in hour query builder laravel
PHP Laravel
24 votes280 views4 answers
Clear cache command in laravel controller
PHP Laravel
1 vote269 views2 answers
Get ip address in laravel
PHP Laravel
19 votes259 views6 answers
Laravel updateOrCreate
PHP Laravel
0 vote272 views1 answer
String length laravel validation
PHP Laravel
13 votes266 views5 answers
Zsh: command not found: laravel
PHP Laravel
0 vote265 views1 answer
Laravel doesn't work update
PHP Laravel