connect_error) {
die("Connection failed: " . $conn->connect_error);
}
function SelectResult($sql, $conn) {
$result = $conn->query($sql);
return $result;
}
function secondsToTime($seconds) {
if ($seconds == 0) {return 0;}
$dtF = new \DateTime('@0');
$dtT = new \DateTime("@$seconds");
return $dtF->diff($dtT)->format('%a days, %h hours, %i minutes and %s seconds');
}
function table( $result ) {
$result->fetch_array( MYSQLI_ASSOC );
echo '';
tableHead( $result );
tableBody( $result );
echo '
';
}
function tableHead( $result ) {
echo '';
foreach ( $result as $x ) {
echo '';
foreach ( $x as $k => $y ) {
echo '| ' . ucfirst( $k ) . ' | ';
}
echo '
';
break;
}
echo '';
}
function tableBody( $result ) {
echo '';
foreach ( $result as $x ) {
echo '';
foreach ( $x as $y ) {
$pos = strrpos($y, "STEAM");
if ($pos === false) {
echo '| ' . $y . ' | ';
}
else
{
echo '' . $y . ' | ';
}
}
echo '
';
}
echo '';
}
?>
close(); ?>