/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 vote309 views2 answers
Iframe site bi link laravel
PHP Laravel
1 vote350 views1 answer
Default index page for laravel in cpanel
PHP Laravel
9 votes348 views3 answers
Image validate in laravel validater
PHP Laravel
53 votes410 views6 answers
Laravel join
PHP Laravel
19 votes280 views6 answers
Laravel Route Group
PHP Laravel
4 votes336 views1 answer
Bcript laravel
PHP Laravel
0 vote305 views2 answers
DB::raw update query in laravel
PHP Laravel
3 votes329 views2 answers
Laravel image max size validation
PHP Laravel
0 vote312 views1 answer
Laravel array in lang
PHP Laravel
0 vote319 views1 answer
How to use attempt in laravel
PHP Laravel