top_five_vs.php

<?php
    /**
     * @Project: Virtual Airlines Manager (VAM)
     * @Author: Alejandro Garcia
     * @Web http://virtualairlinesmanager.net
     * Copyright (c) 2013 - 2016 Alejandro Garcia
     * VAM is licensed under the following license:
     *   Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0)
     *   View license.txt in the root, or visit http://creativecommons.org/licenses/by-nc-sa/4.0/
     */
?>
<?php
    $db = new mysqli($db_host , $db_username , $db_password , $db_database);
    $db->set_charset("utf8");
    if ($db->connect_errno > 0) {
        die('Unable to connect to database [' . $db->connect_error . ']');
    }
    $sql = "SELECT g.name, g.surname, g.callsign, v.landing_vs as vtouch, v.created_at FROM vampireps v
        INNER JOIN gvausers g on g.gvauser_id = v.gvauser_id
        WHERE  v.created_at >= (CURDATE() - INTERVAL 7 DAY)
        GROUP BY g.name,  g.surname, g.callsign ORDER BY v.landing_vs DESC LIMIT 5";
    if (!$result = $db->query($sql)) {
        die('There was an error running the query [' . $db->error . ']');
    }
    echo '<table class="table table-hover">';
    echo '<tr><th>' . STATISTICS_CALLSIGN . '</th><th>' . STATISTICS_PILOT . '</th><th>' . STATISTICS_TOUCH . '</th></tr>';
    while ($row = $result->fetch_assoc()) {
        echo "<tr><td>";
        echo $row["callsign"] . '</td><td>';
        echo $row["name"] . ' ' . $row["surname"] . '</td><td>';
        echo number_format($row["vtouch"],2) . ' ft/min </td>';
        echo "</tr>";
    }
    echo "</table></br>";
    $db->close();
?>