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