/**
* @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("/result/view", name="result_viewAll")
*/
public function viewallAction(Request $request)
{
$results = student_module_grade::getAll();
return $this->render('result/viewall.html.twig', array('results' => $results));
}
/**
* @Route("/module/viewmoduleresults/{mod_code}", name="module_results")
*/
public function viewmoduleresultsAction($mod_code, Request $request)
{
$results = student_module_grade::getModuleResults($mod_code);
return $this->render('module/viewmoduleresults.html.twig', array('results' => $results, 'code' => $mod_code));
}
public static function getStudentModuleResults($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 smg.id, smg.s_id, smg.m_code, m.title, m.sem_id, smg.grade FROM student_module_grade smg INNER JOIN module m ON smg.m_code = m.code INNER JOIN student s ON smg.s_id = s.index_no WHERE s.id = ?');
$stmt->bind_param("s", $stuId);
$stmt->execute();
$stmt->bind_result($id, $sId, $mCode, $title, $sem, $grade);
while ($stmt->fetch()) {
$result = new student_module_grade();
$result->id = $id;
$result->setSId($sId);
$result->setMCode($mCode);
$result->mTitle = $title;
$result->setSemId($sem);
$result->setGrade($grade);
array_push($results, $result);
//Push one by one
}
$stmt->close();
return $results;
}