/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 vote340 views1 answer
Case inside laravel query
PHP Laravel
0 vote366 views2 answers
Laravel collection keys
PHP Laravel
1 vote358 views2 answers
Get the value without setter method laravel
PHP Laravel
10 votes366 views2 answers
Create model in laravel command line
PHP Laravel
0 vote355 views2 answers
Maatwebsite/excel package 5.2 laravel
PHP Laravel
1 vote338 views1 answer
Check if delete query was successful laravel
PHP Laravel
5 votes346 views2 answers
Remove “/public” from Laravel route
PHP Laravel
9 votes349 views2 answers
Laravel query count raw
PHP Laravel
0 vote357 views1 answer
Laravel import xml to database
PHP Laravel
0 vote351 views1 answer
How to pluck fullname database laravel
PHP Laravel