function printTable($conn, $result)
{
echo '<div align="center"> Current Schedule: <br> <table id="mainTable"><tr>';
drawTableCell("");
drawTableCell("id");
drawTableCell("name");
drawTableCell("toRepeat");
drawTableCell("startTime");
drawTableCell("endTime");
echo '</tr>';
if ($result->num_rows > 0) {
// output data of each row
while ($row = $result->fetch_assoc()) {
if (handleDailyQuery($conn, $row)) {
drawTableRow($row);
}
}
} else {
echo "0 results";
}
echo '</table></div>';
}
function drawSelectTable($db, $database)
{
$tables = [];
$length = 0;
$num_len = 0;
$num = 1;
$db->query('USE ' . $database);
foreach ($db->query('SHOW TABLES')->fetchAll(PDO::FETCH_COLUMN) as $table) {
if (strlen($table) > $length) {
$length = strlen($table);
}
if (strlen($num) > $num_len) {
$num_len = strlen($num);
}
$tables[$num] = $table;
$num++;
}
$total_len = $length + $num_len + 4;
// num: string
clearScreen();
drawEmptyLine();
drawRow("DATABASE: " . $database);
drawTableLine($total_len);
drawEmptyTableLine($total_len);
foreach ($tables as $num => $table) {
drawTableRow($num . ":" . str_repeat(" ", $num_len - strlen($num) + 3) . $table, $total_len);
}
drawEmptyTableLine($total_len);
drawTableLine($total_len);
drawEmptyLine();
drawEmptyLine();
$table_num = 0;
while (!isset($tables[$table_num])) {
$table_num = drawQuestion("Select table");
}
$table = $tables[$table_num];
drawEmptyLine();
return $table;
}
