public function getAll() { $sql = "SELECT viewerID, username, viewer FROM viewers"; $dbh = new PDO(DBConfig::$DB_CONNSTRING, DBConfig::$DB_USERNAME, DBConfig::$DB_PASSWORD); $resultSet = $dbh->query($sql); $lijst = array(); foreach ($resultSet as $rij) { $userDAO = new UserDAO(); $user = $userDAO->getByUsername($rij["username"]); // var_dump($user); $viewer = $userDAO->getByUsername($rij["viewer"]); // var_dump($viewer); $viewerLijst = Viewer::create($rij["viewerID"], $user, $viewer); array_push($lijst, $viewerLijst); } $dbh = null; return $lijst; }