/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

10 votes177 views3 answers
Php get domain name with https
PHP
5 votes178 views2 answers
Array prepend php
PHP
0 vote256 views2 answers
Laravel collection keys
PHP
23 votes184 views6 answers
Php to string
PHP
0 vote167 views2 answers
How to structure database in laravel
PHP Laravel
2 votes214 views2 answers
Laravel validation unique email except self
PHP
0 vote185 views1 answer
Single row in codeigniter
PHP CodeIgniter
1 vote171 views1 answer
How to request user input in php
PHP
0 vote196 views1 answer
Php createFromFormat day of week
PHP
-1 vote172 views1 answer
Php lowercase assoc array
PHP