I have to make a website where user can look for the stores closest to their address.
So I have a database with all the store addresses and I need to find the 3 closest matches to the clients home address. What would be the best approach?
I was thinking :
- get all latitude and longitude coordinates of the stores and store them locally in a database.
- get the latitude and longitude coordinates of the home address of the client
- find the 3 nearest matches in the database.
Am I thinking in the right way?
Thanks for replying!