Include distance in search form

Question

I would like to implement a search by distance on a website. There must be a user in a living city can find all users living within 100 or 200 km for example.

I have a table in my database that stores all the cities and their coordinates.

I thought to create another table that would store the distance between all cities but my data base contains 36,000 cities and it may make a lot of records ...

How could I make this search more simply knowing that my project will be developed with Symfony and Doctrine?

Thank you beforehand

score 2 · Answer 1 · edited May 23 '17 at 12:25

2

You can use the correct answer here to determine the distance between co-ordinates.

Measuring the distance between two coordinates in PHP

edited May 23 '17 at 12:25

Community

1
1

answered Jan 14 '14 at 13:34

lal_bosdi

163
3
13

score 1 · Accepted Answer · edited May 23 '17 at 12:17

1

For performance reasons you need to use geospatial index to efficiently query such a database. For example MongoDB has a feature for this.

If performance is not an issue you can simply store locations in relational database table and calculate distances in SQL. See this question for some information about this solution: Geo-Search (Distance) in PHP/MySQL (Performance)

edited May 23 '17 at 12:17

Community

1
1

answered Jan 14 '14 at 13:37

vbo

13,583
1
25
33

Include distance in search form

2 Answers2