/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

66 votes175 views6 answers
Php array length
PHP
0 vote148 views4 answers
Generate random number of 4 digit in php
PHP
7 votes192 views3 answers
Random digit with seed php
PHP
0 vote166 views1 answer
Invalid menu item in wordpress
PHP Wordpress
3 votes162 views2 answers
Get details of user using token in laravel passport
PHP Laravel
4 votes173 views2 answers
Laravel eloquent get data without duplicates
PHP
3 votes188 views1 answer
Date time laravel
PHP
0 vote145 views1 answer
Explicit Octal numeral notation - PHP 8.1
PHP
1 vote242 views1 answer
Add 2 hours to current time in cakephp
PHP CakePHP
12 votes146 views2 answers
Laravel update from query
PHP