Example #1
0
 public static function createStudentFromId($id)
 {
     $student = new self();
     $query = "SELECT * FROM TUSERS U JOIN TSTUDENTS S ON U.`User ID` = S.`User ID` WHERE U.`User ID` = {$id}";
     $user = db_select($query);
     $student->setUserId($id);
     $student->setFirstName($user[0]['First Name']);
     $student->setSurname($user[0]['Surname']);
     $student->setPrefferedName($user[0]['Preferred Name']);
     $student->setStudentId($user[0]['Student ID']);
     $student->setEmail($user[0]['Email']);
     $student->setRole($user[0]['Role']);
     $student->setGender($user[0]['Gender']);
     $student->setDateOfBirth($user[0]['DOB']);
     $student->setValidation($user[0]['Validation']);
     return $student;
 }