public static function getAll()
{
$con = Connection::getConnectionObject()->getConnection();
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$students = array();
//Make an empty array
$stmt = $con->prepare('SELECT id,name,index_no,CGPA,rank FROM student ORDER BY rank');
$stmt->execute();
$stmt->bind_result($id, $name, $indexNo, $cGPA, $rank);
while ($stmt->fetch()) {
$student = new Student();
$student->id = $id;
$student->setName($name);
$student->setIndexNo($indexNo);
$student->setCGPA($cGPA);
$student->setRank($rank);
array_push($students, $student);
//Push one by one
}
$stmt->close();
return $students;
}
public static function getConnectionObject()
{
if (self::$conn === null) {
//self === Connection
Connection::$conn = new Connection();
}
return Connection::$conn;
}
public static function getAll()
{
$con = Connection::getConnectionObject()->getConnection();
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$semesters = array();
//Make an empty array
$stmt = $con->prepare('SELECT id,name FROM semester');
$stmt->execute();
$stmt->bind_result($id, $name);
while ($stmt->fetch()) {
$semester = new Semester();
$semester->id = $id;
$semester->setName($name);
array_push($semesters, $semester);
//Push one by one
}
$stmt->close();
return $semesters;
}
public static function getAll()
{
$con = Connection::getConnectionObject()->getConnection();
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$stmt = $con->prepare('SELECT id,name,username,password,email,is_active FROM admin');
$admins = array();
if ($stmt->execute()) {
$stmt->bind_result($id, $name, $username, $password, $email, $isActive);
while ($stmt->fetch()) {
$ad = new Admin();
$ad->id = $id;
$ad->name = $name;
$ad->username = $username;
$ad->password = $password;
$ad->email = $email;
$ad->isActive = $isActive;
$admins[] = $ad;
}
$stmt->close();
return $admins;
}
$stmt->close();
return false;
}
public static function getAll()
{
$con = Connection::getConnectionObject()->getConnection();
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$modules = array();
//Make an empty array
$stmt = $con->prepare('SELECT id,code,title,sem_id,credits,gpa FROM module');
$stmt->execute();
$stmt->bind_result($id, $code, $title, $semId, $credits, $gpa);
while ($stmt->fetch()) {
$module = new Module();
$module->id = $id;
$module->setTitle($title);
$module->setCode($code);
$module->setSemId($semId);
$module->setCredits($credits);
$module->setGpa($gpa);
array_push($modules, $module);
//Push one by one
}
$stmt->close();
return $modules;
}
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;
}
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;
}
