<?php
require_once "pass.php";
require_once "lib/safemysql.class.php";
$tableName = "tickets";
echo "Log in MySQL<br>\n";
$db = new SafeMySQL(['host' => $loginData['mysql_host'], 'user' => $loginData['mysql_username'], 'pass' => $loginData['mysql_password'], 'db' => $loginData['mysql_db']]);
echo "<br>List fields in table:<br>\n";
$sql = "SHOW COLUMNS FROM {$tableName}";
$fields = $db->getCol($sql);
//Print table to HTML
?>
<table border="1">
<thead>
<tr>
<?
foreach($fields as $fieldname) {
echo "<td>$fieldname</td>\n";
}
echo "</tr></thead><tbody>";
$data=$db->getAll("SELECT * FROM $tableName ORDER BY dtime DESC LIMIT 100");
foreach($data as $row=>$cols) {
echo"<tr>";
foreach($cols as $col) {
echo " <td>$col</td>\n";
}
echo "</tr>\n";
}
echo "</tbody></table>";
?>
