Support the ongoing development of Laravel.io →
boyjk23
posted 8 years ago
Database
Last updated 2 years ago.
0
softwaredeveloperca
replied 8 years ago

'SELECT *, ( 6371 * acos( cos( radians(' . $lat . ') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(' . $lng . ') ) + sin( radians(' . $lat .') ) * sin( radians(lat) ) ) ) AS distance FROM users WHERE profileStatus LIKE 'PUBLIC' HAVING distance < ' . $distance

0

Sign in to participate in this thread!

Eventy

Your banner here too?

boyjk23 boyjk23 Joined 4 Jan 2016

Moderators

We'd like to thank these amazing companies for supporting us

Eventy
Fathom
Forge
Envoyer
Beyond Code
BairesDev
N-iX

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Forum Articles Pastebin

Socials

X (Twitter) Bluesky Bluesky GitHub

The community

Laravel Laravel Laravel News Laravel News
Laracasts Laracasts Laravel Podcast Laravel Podcast
© 2024 Laravel.io - All rights reserved.
Terms of service Privacy policy Advertise