/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 vote154 views1 answer
Cloudinary laravel
PHP Laravel
4 votes143 views2 answers
Php $randomUA[rand(0, count($randomUA) 1)
PHP
1 vote167 views1 answer
$posts- links() laravel design error
PHP Laravel
18 votes147 views6 answers
Integer to string php
PHP
9 votes160 views1 answer
Get data in orderby in laravel
PHP Laravel
1 vote164 views2 answers
How to delete image from aws using laravel 8
PHP Laravel
0 vote117 views1 answer
How to login first before see index php
PHP
1 vote163 views2 answers
Redirect::route('profile') and with() in laravel
PHP Laravel
12 votes149 views3 answers
How to log object laravel logger
PHP Laravel
1 vote134 views2 answers
Php pointer function
PHP