/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

1 vote149 views1 answer
Check if input file is set codeigniter
PHP CodeIgniter
2 votes120 views1 answer
Php make array to certain length
PHP
19 votes116 views6 answers
Array_search in php
PHP
3 votes111 views2 answers
Refresh seeder laravel
PHP
16 votes127 views4 answers
Wherenotnull laravel
PHP Laravel
1 vote114 views2 answers
Php validate date format
PHP
2 votes123 views2 answers
Laravel throw exception with status code
PHP Laravel
1 vote134 views1 answer
Insert data using model in laravel 8
PHP Laravel
0 vote102 views1 answer
Drupal 8 $_GET
PHP
0 vote112 views1 answer
How to restrict user to some pages using php
PHP