/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 vote211 views1 answer
Load differenet .env file in laravel
PHP Laravel
10 votes270 views4 answers
Laravel table data types
PHP Laravel
0 vote227 views1 answer
Laravel faker boolean
PHP Laravel
0 vote213 views1 answer
Laravel admin panel free package
PHP Laravel
2 votes223 views3 answers
Laravel model particular column
PHP Laravel
21 votes240 views5 answers
Laravel 7 auth command
PHP Laravel
32 votes220 views1 answer
How to count the characters in laravel
PHP Laravel
4 votes273 views3 answers
Laravel description substring
PHP Laravel
1 vote307 views1 answer
Mysqli_query insert in laravel
PHP Laravel
12 votes229 views2 answers
Laravel update from query
PHP Laravel