/**
* @Route("/student/view/{id}", name="student_view")
*/
public function viewAction($id, Request $request)
{
$student = Student::getOne($id);
//get module results of the student
$results = student_module_grade::getStudentModuleResults($id);
//get semester results of the student
$semResults = Semester_results::getSemesterResults($id);
return $this->render('student/view.html.twig', array('student' => $student, 'results' => $results, 'semResults' => $semResults));
}
/**
* @Route("/semester/view", name="semester_viewAll")
*/
public function viewallAction(Request $request)
{
$semesters = Semester::getAll();
$semResults = Semester_results::getAll();
return $this->render('semester/viewall.html.twig', array('semesters' => $semesters, 'results' => $semResults));
}
public static function getSemesterResults($stuId)
{
$con = Connection::getConnectionObject()->getConnection();
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$results = array();
//Make an empty array
$stmt = $con->prepare('SELECT semester_results.id, semester_results.sem_id, semester_results.stu_id, semester_results.GPA, semester_results.rank FROM semester_results WHERE stu_id = ?');
$stmt->bind_param("s", $stuId);
$stmt->execute();
$stmt->bind_result($id, $semId, $stuId, $gPA, $rank);
while ($stmt->fetch()) {
$result = new Semester_results();
$result->id = $id;
$result->setSemId($semId);
$result->setStuId($stuId);
$result->setGPA($gPA);
$result->setRank($rank);
array_push($results, $result);
//Push one by one
}
$stmt->close();
return $results;
}
