/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 vote131 views1 answer
Laravel check if form has errors
PHP
0 vote81 views1 answer
Laravel many to many same model
PHP
0 vote142 views1 answer
Check if the link is image or url php
PHP
55 votes105 views18 answers
Php generate random number string
PHP
0 vote118 views2 answers
Show all terms of a custom taxonomy
PHP
1 vote157 views1 answer
Php abstract class static method
PHP
0 vote111 views1 answer
Php date with out 0
PHP
4 votes147 views1 answer
Laravel install production
PHP Laravel
1 vote150 views2 answers
Page expire in laravel
PHP Laravel
2 votes138 views3 answers
Wordpress is home page
PHP