Aircraft Developer Registry
Sign Up
Statistics
connect_error)
{
$fetch_failed = true;
}
else
{
// Aircraft stats
echo('| Aircraft | Developers |
|---|
');
$sql = "SELECT acid, COUNT(user) AS ucount FROM `aircraft-devs` GROUP BY acid;";
$result = $con->query($sql);
while ($row = $result->fetch_assoc())
{
echo('| ' . $row["acid"] . ' | ' . $row["ucount"] . ' |
');
}
echo('
');
// User stats
$sql = "SELECT COUNT(DISTINCT user) AS ucount FROM `aircraft-devs`;";
$result = $con->query($sql);
$row = $result->fetch_assoc();
echo('There are ' . $row["ucount"] . ' developers registered');
}
if ($fetch_failed)
{
echo("Unable to get complete statistics");
}
?>