/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

1 vote158 views2 answers
Php preg_match special characters
PHP
0 vote184 views1 answer
Howw to see if a value is posted laravel
PHP
0 vote206 views1 answer
Wordpress deactivate widgets gutenberg
PHP Wordpress
5 votes157 views3 answers
Laravel destroy session
PHP
6 votes169 views4 answers
Laravel spatie asigne role
PHP
-1 vote156 views2 answers
West african timezone in php
PHP
0 vote206 views1 answer
Laravel blade variable isset, empty or optional
PHP Laravel
1 vote189 views1 answer
How to find mysql server name in php
PHP
0 vote199 views1 answer
Laravel eloquent hasmany select
PHP Laravel
0 vote194 views1 answer
Server error in laravel
PHP Laravel