![](https://i.imgur.com/9UQ54uc.gif"){kind=small}
I didn't know how to structure the title, but let me explain: I am creating a website where you can find specific tourist services in different cities. For example, if you are going to Cancun, you can search for those services on my website and see a list of agencies. The same goes for Miami and other cities.
I have seen some websites that work similarly, where instead of selecting the city from a checkbox, the user types in the city name (such as Cancun) and it is automatically populated thanks to the Google API.
The question I have is how to store this data in my database and how to perform the search. For example, when a user searches for something, only Cancun, Mexico appears, and upon clicking "search," all the registered agencies offering services in that area are displayed. How should I store this information? Should I store GPS coordinates?
I have seen some websites that work similarly, where instead of selecting the city from a checkbox, the user types in the city name (such as Cancun) and it is automatically populated thanks to the Google API.
The question I have is how to store this data in my database and how to perform the search. For example, when a user searches for something, only Cancun, Mexico appears, and upon clicking "search," all the registered agencies offering services in that area are displayed. How should I store this information? Should I store GPS coordinates?