<?php // test access rights include "app/views/admin/header.php"; if (!isMaster()) { exitAccessError(); } // connect to our database $link = getLink(); // find the active tables and the last non active table $tables = findTables($link, 'Evaluations'); print '<article class="page">' . "\n"; print '<h1>Show All TA Evaluations</h1>'; print ' '; print "<table>\n"; print "<tr><th>Term</th><th>Actions</th>\n"; foreach ($tables as $key => $table) { $term = substr($table, -5, 5); print " <tr><td> {$term}\n"; print " </td><td> <a href=\"/showEvaluations?term={$term}\">show</a></td></tr>\n"; } print '</table>' . "\n"; print '</article>' . "\n"; include "app/views/admin/footer.php";
<?php include "app/views/admin/header.php"; // make sure we are dealing with a registered TA if (!isMaster()) { exitAccessError(); } print '<article class="page">' . "\n"; print '<h1>Show All TA Assignments</h1>'; print ' '; // connect to our database $link = getLink(); // find the active tables and the last non active table $tables = findTables($link, 'Assignments'); print "<table>\n"; print "<tr><th>Term</th><th>Actions</th>\n"; foreach ($tables as $key => $table) { $term = substr($table, -5, 5); print " <tr><td> {$term}\n"; print " </td><td> <a href=\"/showAssignments?term={$term}\">show</a>,"; print " <a href=\"/updateAssignments?term={$term}\">update</a></td></tr>\n"; } print "</table>\n"; print '</article>' . "\n"; include "app/views/admin/footer.php";
function copyAssignment($link, $source, $target) { // copy the last assignment to the active one print "<h2> copy {$source} to {$target}</h2><hr>\n"; // Check if target exists $tables = findTables($link, $target); if (sizeof($tables) == 0) { $query = "create table {$target} like {$source}"; $statement = $link->prepare($query); $rc = $statement->execute(); if (!$rc) { $errNum = mysqli_errno($link); $errMsg = mysqli_error($link); print " ERROR - could not read source ErrNo=" . mysqli_errno($link) . ": " . mysqli_error($link) . "\n"; exit; } } // collect all inserts $query = "select * from {$source}"; $statement = $link->prepare($query); $rc = $statement->execute(); if (!$rc) { $errNum = mysqli_errno($link); $errMsg = mysqli_error($link); print " ERROR - could not read source ErrNo=" . mysqli_errno($link) . ": " . mysqli_error($link) . "\n"; exit; } $statement->bind_result($task, $person); $inserts = ''; $i = 0; while ($statement->fetch()) { $myTask = new TeachingTask($task); $inserts[$i] = "insert into {$target} (Task) values ('{$task}')"; print " {$inserts[$i]}<br>"; $i = $i + 1; } // Now perform the inserts foreach ($inserts as $key => $insert) { print " execute update: {$insert} <br>\n"; $statement = $link->prepare($insert); $rc = $statement->execute(); if (!$rc) { $errNum = mysqli_errno($link); $errMsg = mysqli_error($link); print " ERROR - could not insert assignment: ErrNo=" . mysqli_errno($link) . ": " . mysqli_error($link) . "\n"; exit; } else { print " INFO - entry inserted.<br>\n"; } } }