/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

6 votes202 views2 answers
Laravel migration integer
PHP Laravel
0 vote130 views1 answer
Use app http models in laravel 8
PHP Laravel
6 votes141 views1 answer
Laravel bootstrap ui
PHP Laravel
0 vote144 views1 answer
Href in laravel view
PHP Laravel
0 vote135 views2 answers
Customize laravel pagination links
PHP Laravel
-1 vote147 views1 answer
Echo in console command laravel
PHP Laravel
1 vote177 views2 answers
Return response at failedValidation() in request laravel
PHP Laravel
0 vote140 views1 answer
Laravel: Session message exist while click on browser back button
PHP Laravel
6 votes165 views2 answers
Laravel migrations generator laravel
PHP Laravel
0 vote143 views2 answers
Laravel: customize or extend notifications - database model
PHP Laravel