/PHP/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

42 votes200 views6 answers
Php generate random string
PHP
91 votes173 views5 answers
Php check if string contains a char
PHP
0 vote181 views1 answer
How to fetch google reviews and data in php URl
PHP
2 votes264 views1 answer
Create laravel project old version
PHP Laravel
0 vote212 views2 answers
Share to facebook from website laravel
PHP Laravel
0 vote194 views1 answer
Cloudinary laravel
PHP Laravel
4 votes162 views3 answers
How to hide .php in url
PHP
1 vote179 views1 answer
Laravel export make comman
PHP
0 vote196 views1 answer
Twig for loop key
PHP
0 vote179 views1 answer
New DateInterval 1 hour
PHP