/home/techb158/workloadmatch.com/Manager
Edit: /home/techb158/workloadmatch.com/Manager/Preference_Accounting.php (9810B)
<?php echo $programName; ?> Teacher Preferences
Select a teacher, then check courses and choose First or Second priority. Preferences are saved automatically.
| Select | Course Name | Priority |
|---|
| Select a teacher to load courses |
| Teacher | Course | Priority | Date |
|---|
query("
SELECT t.First_Name, t.Last_Name, c.Course_Name, tcp.Priority, tcp.Date_Time
FROM teacher_course_preferences tcp
JOIN teacher_profile t ON tcp.Teacher_ID = t.Teacher_ID
JOIN Courses c ON tcp.Course_ID = c.Course_ID
WHERE tcp.Program_ID = $programID
ORDER BY t.First_Name, c.Course_Name");
while ($rs = $qs->fetch_assoc()) {
$p = $rs['Priority'] == 1 ? 'First' : 'Second';
echo "| {$rs['First_Name']} {$rs['Last_Name']} | {$rs['Course_Name']} | $p | {$rs['Date_Time']} |
";
}
?>