/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 vote279 views1 answer
Laravel 8 model filter
PHP Laravel
0 vote315 views3 answers
Email or phone required in laravel
PHP
0 vote157 views1 answer
Laravel chain query builder
PHP
11 votes172 views2 answers
How login one user with id in laravel
PHP Laravel
0 vote190 views1 answer
Php check if variable is true or false
PHP
0 vote172 views1 answer
Wp ajax error handling
PHP Wordpress
1 vote196 views1 answer
Fecade Artisan:call laravel
PHP Laravel
6 votes197 views2 answers
Dump all variables twig
PHP
15 votes228 views3 answers
Php inline if
PHP
0 vote151 views1 answer
Base url in php
PHP