include "app/views/teacher/header.php"; include_once "app/models/TeachingTask.php"; // make sure we have a registered TA if (!(isTeacher() || isMaster())) { exitAccessError(); } print '<article class="page">' . "\n"; print '<h1>Select the TA</h1>' . "\n"; print ' ' . "\n"; // connect to our database $link = getLink(); // find the active table $active = findActiveTable($link, 'Evaluations'); print "Active evaluations table: {$active['0']}</p>"; $term = substr($active[0], -5, 5); $options = findTaNames($link, 'Assignments' . $term); // start the form print '<p>'; print '<form action="/enterEvaluation" method="post">' . "\n"; // Select TA print 'Select the student to evaluate.'; print ' <select class="ta" name="ta">' . "\n"; print ' <option value="">Select student to evaluate</option>' . "\n"; foreach ($options as $key => $option) { print "<option value=\"" . $key . "\"> {$option} </option>"; } print ' </select>' . "\n"; print ' <input type="submit" value="select this student" />' . "\n"; print '</form>' . "\n"; print '</p>' . "\n"; print '</article>' . "\n";
} print ' Term valid.<br>'; // find the tables $evaluationsTable = 'Evaluations' . $term; //print " Evaluations from $evaluationsTable.<br>"; $assignmentsTable = 'Assignments' . $term; //print " Assignments from $assignmentsTable.<br>"; // find teacher and TA $teachers = findTeacherNames($link); if (!isset($teachers[$teacherEmail])) { // check if this is a valid teacher (Faculties table) print ' EXIT - teacher email is not valid.'; exitParameterError($teacherMail); } print ' Teacher valid.<br>'; $tas = findTaNames($link, $assignmentsTable); if (!isset($tas[$taEmail])) { print ' EXIT - ta email is not valid.'; exitParameterError($taMail); } print ' TA valid.<br>'; // test whether evaluation is valid if ($teacherEmail != "" && $taEmail != "" && $evaluation != "") { print '<p>Evaluation is valid.<br>'; // do we update or is it a new entry $query = "select TeacherEmail,TaEmail from {$evaluationsTable} " . "where TeacherEmail='{$teacherEmail}' and TaEmail='{$taEmail}'"; $statement = $link->prepare($query); $rc = $statement->execute(); if (!$rc) { $errNum = mysqli_errno($link); $errMsg = mysqli_error($link);