public static function getAllSemester($semester_id)
{
$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,student.name,student.index_no FROM semester_results INNER JOIN student ON semester_results.stu_id = student.id WHERE sem_id = ? ORDER BY semester_results.rank');
//$stmt = $con->prepare('SELECT id,sem_id,stu_id,GPA,rank,name,index_no FROM semester_results,student WHERE semester_results.stu_id = student.id AND sem_id = ?');
//$stmt = $con->prepare('SELECT id,sem_id,stu_id,GPA,rank FROM semester_results WHERE sem_id = ?');
$stmt->bind_param("s", $semester_id);
$stmt->execute();
$stmt->bind_result($id, $semId, $stuId, $gPA, $rank, $name, $index);
// $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);
$result->setStudentName($name);
$result->setStudentIndex($index);
array_push($results, $result);
//Push one by one
}
$stmt->close();
return $results;
}
