function showAssignment($link, $table, $option = "ALL") { // show all assignments $query = "select * from {$table} order by Task"; $statement = $link->prepare($query); $rc = $statement->execute(); if (!$rc) { $errNum = mysqli_errno($link); $errMsg = mysqli_error($link); print " ERROR - could not register selection: ErrNo=" . mysqli_errno($link) . ": " . mysqli_error($link) . "\n"; exit; } $statement->bind_result($task, $person); print "<table>\n"; print "<tr><th> Course </th><th> Type </th><th> Effort </th>"; print "<th> TA type </th><th> Person </th><th> Id </th></tr>\n"; $iF = 0; $iP = 0; while ($statement->fetch()) { $myTask = new TeachingTask($task); $display = 0; if ($option == "ALL") { $display = 1; } else { if ($option == "TA" && $myTask->isTa() && $person != "" && $person != "*****@*****.**") { $display = 1; } else { if ($option == "Unassigned" && ($person == "" || $person == "*****@*****.**")) { $display = 1; } } } if ($display) { print "<tr><td> " . "<a href=\"/showTaskSummary?number=" . $myTask->getCourse() . "\">" . $myTask->getCourse() . "</a>" . " </td><td>" . $myTask->getType() . " </td><td>" . $myTask->getEffort() . " </td><td>" . $myTask->getTaType() . " </td><td>" . "<a href=\"/showTaSummary?email=" . $person . "\">" . $person . "</a>" . " </td><td>" . $myTask->generateId() . " </td></tr>\n"; if ($myTask->isTa() && $myTask->getEffort() == 'full') { $iF = $iF + 1; } if ($myTask->isTa() && $myTask->getEffort() == 'half') { $iF = $iF + 0.5; } if ($myTask->isTa() && $myTask->getEffort() == 'part') { $iP = $iP + 1; } } } print "</table>"; print "<p> TA openings ({$option}): <b>{$iF}</b> (full time) <b>{$iP}</b> (part time).</p><br> \n"; }