예제 #1
0
파일: db.php 프로젝트: cpausmit/Tapas
function printTeachers($link, $table, $courses)
{
    // show all assignments
    $query = "select Person,Task from {$table} where Task like '%-Lec-%' 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($email, $task);
    $list = "";
    while ($statement->fetch()) {
        $myTask = new TeachingTask($task);
        $number = $myTask->getCourse();
        foreach ($courses as $key => $course) {
            if ($course == $number) {
                print " {$course} --> {$email}<br>\n";
                if ($list == "") {
                    $list = "{$email}";
                } else {
                    $list = "{$list},{$email}";
                }
                break;
            }
            //else
            //  print " NO MATCH -- Course: $course --> $email<br>\n";
        }
    }
    print " ALL: {$list}<br>\n";
    return;
}