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; }