/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 vote224 views1 answer
Delete Query with Where Condition in Codeigniter
PHP CodeIgniter
1 vote232 views2 answers
Wordpress get link to post by id
PHP
0 vote213 views1 answer
Remove rank math next prev canonical
PHP
2 votes181 views2 answers
Laravel now date
PHP
40 votes243 views6 answers
Laravel create migration
PHP Laravel
1 vote170 views1 answer
Laravel end date greater than start date validation
PHP
0 vote218 views1 answer
How to find number between different ranges in php
PHP
5 votes208 views3 answers
Laravel display error message
PHP Laravel
12 votes221 views6 answers
Set session data in laravel
PHP Laravel
2 votes246 views1 answer
How to use join query in codeigniter
PHP CodeIgniter