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; }