Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
I need to query nearby restaurants which are 10 metres away how do i go about it?am a beginner using google maps API.Do i need to save the longitude and latitude in their restaurants table?Anyone with a tutorial on that or who will guide me will really appreciate
10 metres?
You could use the Haversine formula to calculate the distance between two sets of coordinates.
https://thisinterestsme.com/php-haversine-formula-function/
or use geospatial features of your database to search by proximity
https://dba.stackexchange.com/questions/4214/how-to-best-implement-nearest-neighbour-search-in-mysql
I hope OP means 10 kilometers.
But I guess 10 meters would be very handy.
Please or to participate in this conversation.