$general->loggedOutProtect(); $pageTitle = "Personnel"; $section = "staff"; try { // protect again any sql injections on url if (isset($_GET['id']) && preg_match("/^[0-9]+\$/", $_GET['id'])) { $userId = $_GET['id']; $pageTitle = "Profile"; if (($data = User::getSingle($userId)) === false) { header('Location: ' . BASE_URL . 'error-404'); exit; } if (strcmp($data['type'], 'tutor') === 0) { $tutor = TutorFetcher::retrieveSingle($userId); $curUser = new Tutor($data['id'], $data['f_name'], $data['l_name'], $data['email'], $data['mobile'], $data['img_loc'], $data['profile_description'], $data['date'], $data['type'], $data['active'], $tutor[MajorFetcher::DB_COLUMN_NAME]); $schedules = ScheduleFetcher::retrieveCurrWorkingHours($curUser->getId()); $teachingCourses = TutorFetcher::retrieveCurrTermTeachingCourses($curUser->getId()); } else { if (strcmp($data['type'], 'secretary') === 0) { $curUser = new Secretary($data['id'], $data['f_name'], $data['l_name'], $data['email'], $data['mobile'], $data['img_loc'], $data['profile_description'], $data['date'], $data['type'], $data['active']); } else { if (strcmp($data['type'], 'admin') === 0) { $curUser = new Admin($data['id'], $data['f_name'], $data['l_name'], $data['email'], $data['mobile'], $data['img_loc'], $data['profile_description'], $data['date'], $data['type'], $data['active']); } else { throw new Exception("Something terrible has happened with the database. <br/>The software developers will tremble with fear."); } } } } else { if (isBtnInactivePrsd()) { $users = User::retrieveAllInactive();
* the following tutor details (as elements of an array named $jobs): * * * Created by PhpStorm. * Date: 4/1/14 * Time: 3:24 AM * */ $id = $curUser[UserFetcher::DB_COLUMN_ID]; $first_name = $curUser[UserFetcher::DB_COLUMN_FIRST_NAME]; $last_name = $curUser[UserFetcher::DB_COLUMN_LAST_NAME]; $email = $curUser[UserFetcher::DB_COLUMN_EMAIL]; $position = $curUser[UserTypesFetcher::DB_COLUMN_TYPE]; if (User::isUserTypeTutor($position)) { $courses = TutorFetcher::retrieveCurrTermTeachingCourses($id); $schedules = ScheduleFetcher::retrieveCurrWorkingHours($id); } $mobile = $curUser[UserFetcher::DB_COLUMN_MOBILE]; ?> <tr> <td class="text-center"><?php echo $first_name . " " . $last_name; ?> </td> <td class="text-center"><?php echo $email; ?> </td> <td class="text-center"><?php echo $position; ?>