/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 vote283 views1 answer
Install pusher package in laravel
PHP
0 vote339 views1 answer
Cakephp 2.x join
PHP CakePHP
0 vote252 views3 answers
Fetch data url php
PHP
4 votes325 views2 answers
How validate hash string in laravel
PHP
0 vote295 views1 answer
Laravel count soft delete data
PHP Laravel
6 votes317 views4 answers
Insert data using seeder in laravel
PHP Laravel
0 vote344 views1 answer
Laravel timestamps on pivot table
PHP Laravel
40 votes312 views4 answers
First character uppercase php
PHP
12 votes280 views6 answers
Laravel where and where
PHP
0 vote300 views1 answer
Php get first last loop
PHP