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; }