public function getPointsByChallengeId($challengeId)
{
$sql = "SELECT pointID, challangeID, date, weight FROM weighpoints WHERE challangeID = :challengeId";
// $sql = "select pointID, challangeID, date, weight from weighpoints";
$dbh = new PDO(DBConfig::$DB_CONNSTRING, DBConfig::$DB_USERNAME, DBConfig::$DB_PASSWORD);
$stmt = $dbh->prepare($sql);
$stmt->execute(array(':challengeId' => $challengeId));
$resultList = $stmt->fetchAll(PDO::FETCH_ASSOC);
// $resultSet = $dbh->query($sql);
var_dump($resultList);
$lijst = array();
foreach ($resultList as $rij) {
$challengeDAO = new ChallengeDAO();
$challenge = $challengeDAO->getById($rij["challangeID"]);
$weighpoint = Weighpoint::create($rij["pointID"], $challenge, $rij["weight"], $rij["date"]);
var_dump($weighpoint);
array_push($lijst, $weighpoint);
}
$dbh = null;
return $lijst;
}
<body>
<?php
// var_dump($userLijst);
print "<pre>";
print_r($userLijst);
print "</pre>";
// var_dump($challengeLijst);
print "<pre>";
print_r($challengeLijst);
print "</pre>";
foreach ($challengeLijst as $challenge) {
$username = $challenge->getUser()->getUsername();
print $username;
}
$challengeDAO = new ChallengeDAO();
$challenge = $challengeDAO->getById(1);
// var_dump($challenge);
print "<pre>";
print_r($challenge);
print "</pre>";
// var_dump($weighpointLijst);
print "<pre>";
print_r($weighpointLijst);
print "</pre>";
foreach ($weighpointLijst as $weighpoint) {
$challengeId = $weighpoint->getChallenge()->getChallengeId();
echo $challengeId . "</br>";
}
print "<pre>";
print_r($viewerLijst);
print "</pre>";
