/PHP/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

10 votes318 views4 answers
Is users logged in laravel blade
PHP Laravel
0 vote299 views2 answers
Default language laravel
PHP Laravel
0 vote291 views1 answer
Php calculate age as float
PHP
0 vote358 views2 answers
Save big data with laravel
PHP Laravel
13 votes262 views4 answers
Laravel hash
PHP
1 vote271 views2 answers
How to pass parameter in routes of laravel
PHP
0 vote273 views1 answer
Php remove dashes from string
PHP
43 votes265 views2 answers
Array count items
PHP
0 vote258 views1 answer
Wp+get tags for custom post type
PHP
1 vote425 views1 answer
Wordpress image text acf
PHP Wordpress