How to get aircraft icao knowing it's name

[artem]

On my briefing page I have the following code which gives me aircraft's name from schedules:

<?php echo "{$schedule->aircraft}"; ?>

Which outputs something like this: A320-214

I can also use:

<?php echo "{$schedule->aircraftid}"; ?>

Which gives me an ID of an aircraft from *aircraft* table.

 

Knowing aircraft's name and id, how can I get aircraft icao code from *aircraft* database?

(In aircraft database there are fields *id*, *icao*, *name* etc)

Thanks!

[web541]

Is this what you're looking for?

<?php echo OperationsData::getAircraftInfo($schedules->aircraftid); ?>
<?php echo OperationsData::getAircraftByName($schedules->aircraft); ?>

 

[artem]

@web541 I'm looking for a script which will give me ICAO code of an aircraft from *aircraft* table knowing it's *id* from a different table

[web541]

<?php
$aircraft = OperationsData::getAircraftInfo($schedules->aircraftid);
echo $aircraft->icao;
?>

Change $schedules->aircraftid to the aircraft id of your table, provided the id's match between the aircraft table and your table then it should work.

[artem]

That's awesome! Thanks a lot!!!