/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 vote234 views1 answer
Url decode function in php
PHP
39 votes241 views6 answers
Foreign key laravel migration
PHP Laravel
1 vote223 views2 answers
Teaching php in interactive mode
PHP
0 vote295 views2 answers
Reload page laravel
PHP Laravel
14 votes219 views3 answers
Log facade laravel
PHP Laravel
7 votes257 views3 answers
Laravel where has
PHP Laravel
0 vote260 views2 answers
Laravel file upload
PHP
4 votes226 views2 answers
Php convert words with spaces to camelcase
PHP
18 votes223 views4 answers
List all files in directory php
PHP
1 vote182 views1 answer
Wp query search
PHP