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 printStartEnd($conn, $result) { $minStart = 99999; $minEnd = 99999; if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { if (handleDailyQuery($conn, $row) === FALSE) { continue; } $minTmpStart = round((strtotime($row["startTime"]) - strtotime(date("Y-m-d H:i:s"))) / 60); $minTMPEnd = round((strtotime($row["endTime"]) - strtotime(date("Y-m-d H:i:s"))) / 60); if ($minTmpStart > $minEnd || $minEnd < 99999 && $minTMPEnd < $minEnd) { break; } $minEnd = $minTMPEnd; if ($minStart == 99999) { $minStart = $minTmpStart; } } } echo 'NextStart:' . $minStart . "\r\n" . 'Next_End_:' . $minEnd; }