/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

4 votes257 views1 answer
Php reading a file line by line
PHP
0 vote255 views1 answer
Migration status php
PHP
0 vote310 views1 answer
Wordpress add sitemap.xml to robots.txt dynamically
PHP Wordpress
0 vote284 views1 answer
Laravel creating_table_name
PHP Laravel
14 votes280 views3 answers
Unset php return array
PHP
0 vote251 views1 answer
See all php version debian
PHP
0 vote242 views1 answer
Non static method 'loadView' should not be called statically.intelephense(1036)
PHP
0 vote239 views1 answer
Php return new object
PHP
2 votes218 views1 answer
Php variable in alert box
PHP
0 vote240 views1 answer
How to get yearly chart in laravel
PHP