/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

0 vote302 views1 answer
Php artisan spark not working in codeigniter
PHP
-1 vote343 views2 answers
Show date php
PHP
0 vote322 views1 answer
Wordpress global variable not working
PHP
0 vote304 views1 answer
Ussd php
PHP
2 votes377 views3 answers
Spartie all user with role get laravel
PHP Laravel
0 vote326 views2 answers
Php curl ssl verify
PHP
10 votes329 views6 answers
Laravel Pagination
PHP Laravel
20 votes321 views6 answers
How to use javascript variable in php
PHP
0 vote408 views1 answer
How run job laravel in cpanel host
PHP Laravel
2 votes313 views2 answers
Laravel now date
PHP