/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 vote259 views1 answer
Running a laravel app locally
PHP Laravel
26 votes241 views6 answers
Laravel validation integer
PHP Laravel
7 votes266 views1 answer
Laravel eloquent date range
PHP Laravel
23 votes253 views6 answers
Laravel 8 route
PHP Laravel
4 votes242 views2 answers
Duplicate record laravel
PHP Laravel
0 vote262 views1 answer
Laravel datepicker date format
PHP Laravel
7 votes266 views2 answers
Laravel get session variable in controller
PHP Laravel
0 vote207 views2 answers
Laravel restrict home route access
PHP Laravel
0 vote273 views1 answer
Laravel toastr option
PHP Laravel
5 votes241 views2 answers
Laravel collection chunk
PHP Laravel