I have a mysql Database and 2 tables let's say clients and schools. Now each table has columns latitude and longitude. And I need do make a SELECT for example from second table where schools are in a given radius of one record from first table. Calculations should be made based on latitude and longitude. PS: I am using PHP.
Вы можете вычислить расстояние, используя Сферический закон косинусов:
SELECT DEGREES(ACOS(SIN(RADIANS(clients.latitude)) * SIN(RADIANS(schools.latitude)) +
COS(RADIANS(clients.latitude)) * COS(RADIANS(schools.latitude))
* COS(RADIANS(clients.longitude
– schools.longitude))))
* 60 * 1.1515 * 1.609344 AS distance
FROM clients, schools HAVING distance < $radius
RADIANS(X) - градусы в радианы
ACOS(X) - косинус дуги X, то есть величина, косинус которой равен X
DEGREES(X) - радианы в градусы
60 - минуты в градусе
1.1515 - миля в морской миле
1.609344 - километр в миле