<?php
$servername = "localhost";
$username = "mosha_rust";
$password = "pazz";
$dbname = "mosha_rust";

function Query($query){
$mysqli = new mysqli($servername, $username, $password, $dbname);
if ($mysqli->connect_errno) {
     die("Connection failed: " . $conn->connect_error);
}
$mysqli->set_charset("utf8");
$result = $mysqli->query($query) or die("Invalid query".$mysqli->error);
$myslqi->close();
return $result;
}


#TOP15 Plaers by Time
$query = "SELECT name,id,online_seconds FROM stats_player ORDER BY online_seconds DESC LIMIT 15";
$res = $this->Query($query);
$table = "<table >";
$table .= "<tr><th>ID</th><th>Player NAME</th><th>Online time (sec)</th>";
while ($row = $res->fetch_array(MYSQLI_ASSOC)){
    $table .= "<tr><td>".$row['id']."</td>".$row['name']."<td></td><td>".$row['online_seconds']."</td></tr>";
}
$table .= "</table>";

echo $table;
?>