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