last_login

<?php

/*include this page where you want in your page */

/*  COPIE (include) CODE   */
/* include('last_login.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 name, surname,callsign, last_visit_date FROM gvausers WHERE last_visit_date >= date_sub(NOW(), INTERVAL 15 MINUTE)";
    if (!$resultUsers = $db->query($sql)) {
        die('There was an error running the query [' . $db->error . ']');
    }
?>
<div class="row">
    <div class="col-md-12">
        <div class="panel panel-default">
            <div class="panel-heading"><?php echo 'Users Login last time'; ?></div>
                <table class="table table-hover">
                <?php
                    echo "<thead><tr><th> Pilot</th><th>Connected</th></tr></thead>";
                    while ($row = $resultUsers->fetch_assoc()) {
                        echo "<td>";
                        echo $row["name"].' ('. $row["callsign"].')</td><td>';
                        echo substr($row["last_visit_date"], 11,5). '</td></tr>';
                    }
                $db->close();
                ?>
                </table>
        </div>
    </div>
</div>