Null array

[HighFlyerPL185]

Hi there, I'm trying to print the aircraft's full name, but the array comes out as NULL. Any ideas?

$aircraft = OperationsData::getAircraftInfo($pirep->aircraft);
<?php echo $aircraft->fullname; ?>

If I do var_dump($aircraft); it comes out as NULL. $pirep is taken from a foreach($pireps as $pirep).

I'm trying to parse it in frontpage_main.tpl.

[Sava]

It might be that $pirep->aircraft is empty. Try doing a var_dump on that.

[HighFlyerPL185]

It might be that $pirep->aircraft is empty. Try doing a var_dump on that.

Doesn't look like it's empty. It returned 'B738'. Bizarre.

[mseiwald]

$pirep->aircraft

Should return the aircraft ID.... not the aircraft ICAO.

[Sava]

Exactly.

[freshJet]

Yes this will return the ID, however it should still work.

[Sava]

The fact is that $pirep->aicraft contains the ICAO not the ID in the table so the end query looks smth like ".... WHERE `id`='B738'" which returns an empty object/array.

You need to pass the aircraft ID, not the ICAO.

[Parkho]

PIREPS report aircraft ID in the table, so add the following to your "OperationsData.class.php":

public function GetAircraftById($id)
{
$sql="SELECT * FROM phpvms_aircraft WHERE id='$id' ";
return DB::get_row($sql);
}

And:

$aircraft = OperationsData::GetAircraftById($pirep->aircraft);
<?php echo $aircraft->fullname; ?>

This will give you aircraft full name.