/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

16 votes151 views4 answers
Wherenotnull laravel
PHP Laravel
0 vote150 views2 answers
If condition in laravel blade in select option
PHP Laravel
0 vote247 views1 answer
Convert image to base64 in laravel
PHP Laravel
1 vote178 views1 answer
Do artisan laravel in code
PHP Laravel
2 votes154 views1 answer
Laravel instal
PHP Laravel
4 votes148 views2 answers
Laravel reduce
PHP Laravel
0 vote143 views1 answer
Laravel get current domain
PHP Laravel
4 votes155 views1 answer
Refresh a specific migration in laravel
PHP Laravel
1 vote152 views1 answer
Scedule work laravel
PHP Laravel
0 vote156 views1 answer
Laravel make directory if not exists
PHP Laravel