public function loadSubject($timeTableId) { $pdo = $this->dbConnManager->connect(); $pdo = $this->dbConnManager->connect(); try { $statement = $pdo->query("SELECT `Time`,`name` from subject where timeTableId='" . $timeTableId . "' Order By `Time`"); $statement->setFetchMode(PDO::FETCH_ASSOC); $result = $statement->fetch(); print_r($result); $myBigArray = array(); foreach ($result as &$value) { $createSubject = new subject(); $createSubject->setExamTime($result['Time']); $createSubject->setSubjectName($result['name']); array_push($myBigArray, $createSubject); } return $myBigArray; } catch (Exception $ex) { //print_r($ex); } finally { $this->dbConnManager->closeConnection($pdo); } }