/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

9 votes217 views3 answers
Php string ends with
PHP
10 votes247 views2 answers
Laravel array to string conversion
PHP Laravel
0 vote246 views1 answer
Wordpress get post body
PHP Wordpress
0 vote226 views4 answers
Laravel old value for select option
PHP
6 votes210 views4 answers
Enset laravel session
PHP
12 votes261 views4 answers
Count in laravel'
PHP Laravel
0 vote202 views1 answer
Array of dates laravel
PHP
2 votes233 views1 answer
Img upload in php
PHP
1 vote215 views1 answer
Fopen(F:\xampp\htdocs\Escubydu\storage\fonts//themify_normal_f60486608aadd4e36c92c9895f99838f.ufm): failed to open stream: No such file or directory
PHP
3 votes212 views2 answers
Tests\Feature\BlogTest > user can delete post 162 Illuminate\Encryption\MissingAppKeyException No application encryption key has been specified.
PHP