/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 vote150 views1 answer
Laravel Google Line Chart
PHP Laravel
15 votes157 views6 answers
Laravel migration default value
PHP Laravel
7 votes147 views3 answers
Laravel 8 validation unique 2 columns
PHP Laravel
1 vote146 views1 answer
Laravel http retry
PHP Laravel
18 votes170 views4 answers
Laravel create model controller and migration on line
PHP Laravel
6 votes151 views1 answer
Laravel bootstrap ui
PHP Laravel
2 votes201 views1 answer
Laravel how to test email testing
PHP Laravel
0 vote294 views1 answer
Create model for existing table in laravel
PHP Laravel
5 votes152 views3 answers
Crrate model in laravel
PHP Laravel
-1 vote150 views1 answer
Clear Caching of Queries Laravel Specific Model Cache
PHP Laravel