Beispiel #1
0
 function _getAirportsByCity($c, $s)
 {
     list($lat, $lng) = $this->_getCoordinates($c, $s);
     $airports = new Airport();
     $airports->query("SELECT *, ( 3959 * acos( cos( radians(" . $this->db->escape_str($lat) . ") ) * cos( radians( lat ) ) * cos( radians(lng) - radians(" . $this->db->escape_str($lng) . ") ) + sin( radians(" . $this->db->escape_str($lat) . ") ) * sin( radians( lat ) ) ) ) AS\n\tdistance FROM (`airports`) HAVING `distance` < " . $this->db->escape_str($this->radius) . " LIMIT 0,3");
     return $airports->all;
 }