/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 votes336 views2 answers
Datetime blade laravel
PHP Laravel
0 vote376 views1 answer
Laravel model relationships with two columns match
PHP Laravel
15 votes332 views3 answers
Laravel date set timezone
PHP
18 votes345 views4 answers
God
PHP
0 vote370 views1 answer
Trying to get property 'headers' of non-object Middleware\VerifyCsrfToken.php
PHP
0 vote388 views1 answer
Foreign key cosntraint laravel
PHP Laravel
0 vote345 views1 answer
Clear from faild_jobs laravel
PHP Laravel
0 vote306 views1 answer
Php preplace
PHP
4 votes337 views2 answers
Php numeric array
PHP
0 vote343 views1 answer
Wc php free shipping function
PHP