quick question

[Txmmy83]

have question don't know if it was already asked by someone and answered

is there a a possibility (function) to count all enabled aircraft by ICAO type and is there a possibility to output all registrations of the same?

best regards,

Thomas

[freshJet]

function countAircraftByICAO($icao){
$sql = "SELECT COUNT(id) AS count FROM phpvms_aircraft WHERE icao='$icao' AND enabled='1'";
$result = DB::get_row($sql);
return $result->count;
}

You can put that in OperationsData.class.php. That will get the count. If you want to display any fields then use this:

function getAircraftByICAO($icao){
$sql = "SELECT * FROM phpvms_aircraft WHERE icao='$icao' AND enabled='1'";
return DB::get_results($sql);
}

Example usage:

<?php
$icao = 'A320';
$count = countAircraftByICAO($icao);
$aircraft = getAircraftByICAO($icao);

echo "There are $count aircraft <br/>";

foreach($aircraft as $item){
echo $item->registration.'<br />';
}
?>

[Txmmy83]

where in the OperationsData.class.php should I post that?

[freshJet]

core/common. Be aware though that this will be overwritten in updates, you're probably best creating a new class file first, even if it is messy and annoying.

[Sava]

<?php
$icao = 'A320';
$count = countAircraftByICAO($icao);
$aircraft = getAircraftByICAO($icao);
....

Actually, you'll be calling the method like this: OperationsData::countAircraftByICAO($icao) - note the OperationsData:: part.

[freshJet]

What Sava said. Have been doing non-phpVMS stuff lately without the use of classes.