/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 vote200 views1 answer
Composer new project laravel acl
PHP Laravel
22 votes204 views6 answers
Php artisan make:auth laravel 8
PHP Laravel
31 votes216 views6 answers
Update or create laravel
PHP Laravel
0 vote205 views4 answers
How to redirect to another page after login in laravel
PHP Laravel
0 vote216 views4 answers
How to host laravel project on local server
PHP Laravel
0 vote195 views1 answer
Show user only those products which he hasn't buyed laravel eloquent
PHP Laravel
1 vote297 views1 answer
?? ' ' operator in php laravel
PHP Laravel
0 vote225 views1 answer
Laravelda urlga requestlarni cheklash
PHP Laravel
0 vote211 views1 answer
Id type laravel
PHP Laravel
0 vote255 views2 answers
How do we calculate average in laravel 8
PHP Laravel