/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 vote292 views1 answer
Laravel query get big table records
PHP Laravel
1 vote300 views2 answers
Laravel route group middleware prefix
PHP Laravel
1 vote301 views5 answers
Jobs laravel
PHP Laravel
1 vote324 views1 answer
[InvalidArgumentException] Could not find package laravel/laravel with version 7.0 in a version installable using your PHP version, PHP extensions and Composer version.
PHP Laravel
7 votes309 views5 answers
Jetstream laravel
PHP Laravel
0 vote264 views1 answer
Laravel where search like with space
PHP Laravel
3 votes298 views3 answers
Laravel make view
PHP Laravel
0 vote271 views1 answer
Laravel find model inside the same model
PHP Laravel
1 vote307 views1 answer
Laravel command parameter optional
PHP Laravel
0 vote290 views1 answer
SoapClient Laravel 8
PHP Laravel