/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 vote352 views1 answer
Php pdo check if execution worked
PHP
0 vote344 views1 answer
Php class comment
PHP
0 vote334 views1 answer
Root composer.json requires PHP extension ext-gmp * but it is missing from your system. Install or enable PHP's gmp extension.
PHP
0 vote387 views1 answer
Set default value for column in laravel model
PHP Laravel
-2 votes324 views5 answers
Www.roblox.com
PHP
0 vote372 views1 answer
Get object tyhpe php
PHP
21 votes336 views5 answers
Laravel 7 auth command
PHP Laravel
0 vote353 views2 answers
Maatwebsite/excel package 5.2 laravel
PHP
0 vote360 views2 answers
X-Frame-Options may only be set via an HTTP header sent along with a document. It may not be set inside <meta>.
PHP
0 vote377 views1 answer
Détecter les utilisateurs mobiles
PHP