/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 vote175 views1 answer
Explicit Octal numeral notation - PHP 8.1
PHP
3 votes176 views3 answers
Clone array php
PHP
1 vote184 views1 answer
Wordpress display post comment number
PHP
15 votes216 views6 answers
Wordpress create shortcode
PHP Wordpress
0 vote208 views1 answer
Curl_setopt_array php
PHP
1 vote182 views4 answers
Get month name php
PHP
1 vote174 views2 answers
Htaccess redirect https laravel
PHP
0 vote199 views1 answer
How to share count of things to sidebar in laravel
PHP Laravel
0 vote203 views1 answer
Add like and equal in same query in laravel
PHP Laravel
0 vote199 views1 answer
Add multi product at the same time using repearter default view laravel
PHP Laravel