function index($config, $parameters) { loadModel('models/Students'); $students = getAllStudents($config); if ($students['status']) { if (isset($_SESSION['uname'])) { $students['loggedIn'] = true; } if (isset($_SESSION['urole'])) { $students['role'] = $_SESSION['urole']; } if (isset($_SESSION['addStatus'])) { $students['addStatus'] = $_SESSION['addStatus']; $_SESSION['addStatus'] = null; unset($_SESSION['addStatus']); } if (isset($_SESSION['addStatusMessage'])) { $students['addStatusMessage'] = $_SESSION['addStatusMessage']; $_SESSION['addStatusMessage'] = null; unset($_SESSION['addStatusMessage']); } return $students; } return ['status' => false, 'message' => 'An error occured while trying to retrieve Students records.', 'code' => 500]; }
$role = validateRequest($userid, $userval, $external); if (!$role) { failRequest("There was a problem validating your request"); } switch ($requestType) { case "STUDENTSBYSET": if (!authoriseUserRoles($role, ["SUPER_USER", "STAFF"])) { failRequest("You are not authorised to complete that request"); } getStudentsForSet($setid, $orderby, $desc); break; case "ALLSTUDENTS": if (!authoriseUserRoles($role, ["SUPER_USER", "STAFF"])) { failRequest("You are not authorised to complete that request"); } getAllStudents($orderby, $desc); break; default: break; } function getStudentsForSet($setid, $orderby, $desc) { $query = "select U.`User ID` ID, U.`First Name` FName, U.`Surname` SName, S.`Preferred Name` PName from TUSERGROUPS UG\n join TSTUDENTS S ON S.`User ID` = UG.`User ID`\n join TUSERS U ON U.`User ID` = S.`User ID`"; $query .= filterBy(["UG.`Group ID`", "UG.`Archived`"], [$setid, "0"]); $query .= orderBy([$orderby], [$desc]); try { $students = db_select_exception($query); } catch (Exception $ex) { $message = "There was an error loading the students"; returnToPageError($ex, $message); }
<!-- Optional theme --> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap-theme.min.css"> <head> <body> <form method ="POST" action=""> <div class="row"> <div class="col-md-1"></div> <div class="col-lg-10"> <!-- creating registered Student list --> <?php require 'API.php'; /* adding API */ $registerStudent = getAllStudents(); $totalStudent = count($registerStudent); //print_r($registerStudent[0]);//testing ?> <h2> Registered Student <?php echo "[{$totalStudent}]"; ?> </h2> <table class="table table-striped"> <tr> <th>ID</th> <th></th> <th></th>
<?php require_once '../api/student.php'; include '../templates/includes/header.html'; ?> <style> body{margin-left:25px} </style> <h1>Students:</h1> <ul> <?php $listStudents = getAllStudents(); foreach ($listStudents as $student) { echo "<li><a href='metrics/userMetrics.php?type=Student&email=" . $student['email'] . "'>" . $student['name'] . "</a></li>"; } ?> </ul> <?php include '../templates/includes/footer.html';
break; case 3: echo json_encode(getAllGroups()); break; case 4: echo json_encode(getTasksFromClass($_POST['group'])); break; case 5: echo json_encode(getStudentsFromClass($_POST['group'])); break; case 6: echo json_encode(getAllGroupsReport()); break; case 7: echo json_encode(getTeacherUserGroupsReport($_POST['id'])); break; case 8: echo json_encode(getAllStudents()); break; case 9: if (isset($_POST['student'])) { echo json_encode(getStudent($_POST['student'])); } else { echo "No proper data"; } break; default: } } else { echo "No proper data"; }