public static function createTeacherFromId($id)
{
$teacher = new self();
$query = "SELECT * FROM TUSERS U JOIN TSTAFF S ON U.`User ID` = S.`User ID` WHERE U.`User ID` = {$id}";
$user = db_select($query);
$teacher->setUserId($id);
$teacher->setFirstName($user[0]['First Name']);
$teacher->setSurname($user[0]['Surname']);
$teacher->setTitle($user[0]['Title']);
$teacher->setStaffId($user[0]['Staff ID']);
$teacher->setEmail($user[0]['Email']);
$teacher->setClassroom($user[0]['Classroom']);
$teacher->setPhoneNumber($user[0]['Phone Number']);
$teacher->setRole($user[0]['Role']);
$teacher->setInitials($user[0]['Initials']);
$teacher->setValidation($user[0]['Validation']);
return $teacher;
}
