Ysurac / FlightAirMap

	* @return Array aircraft information

	*

	*/

	public function getAircraftInfoByRegistration($registration)

	{

		$registration = filter_var($registration,FILTER_SANITIZE_STRING);

		$query  = "SELECT spotter_output.aircraft_icao, spotter_output.aircraft_name, spotter_output.aircraft_manufacturer, spotter_output.airline_icao FROM spotter_output WHERE spotter_output.registration = :registration";

		$sth = $this->db->prepare($query);

		$sth->execute(array(':registration' => $registration));

		$aircraft_array = array();

		$temp_array = array();

		while($row = $sth->fetch(PDO::FETCH_ASSOC))

		{

			$temp_array['airline_icao'] = $row['airline_icao'];

			$temp_array['aircraft_icao'] = $row['aircraft_icao'];

			$temp_array['aircraft_name'] = $row['aircraft_name'];

			$temp_array['aircraft_manufacturer'] = $row['aircraft_manufacturer'];

			$aircraft_array[] = $temp_array;

		}

		return $aircraft_array;

	}

	/**

	* Gets the aircraft owner & base based on the aircraft registration

	* @return Array the airline list

	*

	*/

	public function countAllAirlinesByAircraft($aircraft_icao)

	{

		$aircraft_icao = filter_var($aircraft_icao,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.airline_name, spotter_output.airline_icao, spotter_output.airline_country, COUNT(spotter_output.airline_name) AS airline_count

		 			FROM spotter_output

					WHERE spotter_output.airline_name <> '' AND spotter_output.aircraft_icao = :aircraft_icao 

                    GROUP BY spotter_output.airline_name

					ORDER BY airline_count DESC";

		$sth = $this->db->prepare($query);

		$sth->execute(array(':aircraft_icao' => $aircraft_icao));

		$airline_array = array();

		$temp_array = array();

		while($row = $sth->fetch(PDO::FETCH_ASSOC))

		{

			$temp_array['airline_name'] = $row['airline_name'];

			$temp_array['airline_icao'] = $row['airline_icao'];

			$temp_array['airline_count'] = $row['airline_count'];

			$temp_array['airline_country'] = $row['airline_country'];

			$airline_array[] = $temp_array;

		}

		return $airline_array;

	}

	/**

	* @return Array the airline list

	*

	*/

	public function countAllAirlinesByAirport($airport_icao)

	{

		$airport_icao = filter_var($airport_icao,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.airline_name, spotter_output.airline_icao, spotter_output.airline_country, COUNT(spotter_output.airline_name) AS airline_count

		 			FROM spotter_output

					WHERE spotter_output.airline_name <> '' AND (spotter_output.departure_airport_icao = :airport_icao OR spotter_output.arrival_airport_icao = :airport_icao ) 

                    GROUP BY spotter_output.airline_name

					ORDER BY airline_count DESC";

		$sth = $this->db->prepare($query);

		$sth->execute(array(':airport_icao' => $airport_icao));

		$airline_array = array();

		$temp_array = array();

		while($row = $sth->fetch(PDO::FETCH_ASSOC))

		{

			$temp_array['airline_name'] = $row['airline_name'];

			$temp_array['airline_icao'] = $row['airline_icao'];

			$temp_array['airline_count'] = $row['airline_count'];

			$temp_array['airline_country'] = $row['airline_country'];

			$airline_array[] = $temp_array;

		}

		return $airline_array;

	}

	/**

	* @return Array the airline list

	*

	*/

	public function countAllAirlinesByManufacturer($aircraft_manufacturer)

	{

		$aircraft_manufacturer = filter_var($aircraft_manufacturer,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.airline_name, spotter_output.airline_icao, spotter_output.airline_country, COUNT(spotter_output.airline_name) AS airline_count

		 			FROM spotter_output

					WHERE spotter_output.aircraft_manufacturer = :aircraft_manufacturer 

					GROUP BY spotter_output.airline_name

					ORDER BY airline_count DESC";

		$sth = $this->db->prepare($query);

		$sth->execute(array(':aircraft_manufacturer' => $aircraft_manufacturer));

		$airline_array = array();

		$temp_array = array();

		while($row = $sth->fetch(PDO::FETCH_ASSOC))

		{

			$temp_array['airline_name'] = $row['airline_name'];

			$temp_array['airline_icao'] = $row['airline_icao'];

			$temp_array['airline_count'] = $row['airline_count'];

			$temp_array['airline_country'] = $row['airline_country'];

			$airline_array[] = $temp_array;

		}

		return $airline_array;

	}

	* @return Array the airline list

	*

	*/

	public function countAllAirlinesByIdent($ident)

	{

		$ident = filter_var($ident,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.airline_name, spotter_output.airline_icao, spotter_output.airline_country, COUNT(spotter_output.airline_name) AS airline_count

		 		FROM spotter_output

				WHERE spotter_output.ident = :ident  

				GROUP BY spotter_output.airline_name

				ORDER BY airline_count DESC";

		$sth = $this->db->prepare($query);

		$sth->execute(array(':ident' => $ident));

		$airline_array = array();

		$temp_array = array();

		while($row = $sth->fetch(PDO::FETCH_ASSOC))

		{

			$temp_array['airline_name'] = $row['airline_name'];

			$temp_array['airline_icao'] = $row['airline_icao'];

			$temp_array['airline_count'] = $row['airline_count'];

			$temp_array['airline_country'] = $row['airline_country'];

			$airline_array[] = $temp_array;

		}

		return $airline_array;

	}

	/**

	* Gets all airlines that have flown over by route

	* @return Array the airline list

	*

	*/

	public function countAllAirlinesByCountry($country)

	{

		$country = filter_var($country,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.airline_name, spotter_output.airline_icao, spotter_output.airline_country, COUNT(spotter_output.airline_name) AS airline_count

		 		FROM spotter_output

				WHERE ((spotter_output.departure_airport_country = :country) OR (spotter_output.arrival_airport_country = :country)) OR spotter_output.airline_country = :country  

				GROUP BY spotter_output.airline_name

				ORDER BY airline_count DESC";

		$sth = $this->db->prepare($query);

		$sth->execute(array(':country' => $country));

		$airline_array = array();

		$temp_array = array();

		while($row = $sth->fetch(PDO::FETCH_ASSOC))

		{

			$temp_array['airline_name'] = $row['airline_name'];

			$temp_array['airline_icao'] = $row['airline_icao'];

			$temp_array['airline_count'] = $row['airline_count'];

			$temp_array['airline_country'] = $row['airline_country'];

			$airline_array[] = $temp_array;

		}

		return $airline_array;

	}

	/**