/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

3 votes322 views1 answer
Laravel use relations in where
PHP Laravel
0 vote363 views1 answer
How to validate email or phone number single parameter request in laravel
PHP Laravel
0 vote323 views1 answer
Check if config exist laravel
PHP Laravel
-1 vote352 views4 answers
Adminlte in laravel 8
PHP Laravel
14 votes334 views6 answers
Redirect back laravel
PHP Laravel
2 votes357 views3 answers
Laravel get query result as array
PHP Laravel
0 vote371 views1 answer
Laravel load models by id array
PHP Laravel
0 vote397 views1 answer
How to index column in laravel
PHP Laravel
1 vote374 views1 answer
Laravel set config value runtime
PHP Laravel
2 votes374 views3 answers
Laravel auth check login
PHP Laravel