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