public static function getUserById($user_id) { return DAL::getUserById($user_id); }
static function getCommentsAdventure($id) { $req = 'SELECT * FROM comment WHERE adventure_id=?'; $param = array(0 => array($id, PDO::PARAM_INT)); $res = DB::getInstance()->prepareAndExecuteQueryWithResult($req, $param); $comments = array(); foreach ($res as $data) { $text = $data["content"]; $user = DAL::getUserById($data["user_id"]); $comments[] = new Comment($user->getUsername(), $text); } return $comments; }
public static function getUserAdventures($user_id) { $adventures = DAL::getUserAdventures($user_id); $photos = array(); $tags = array(); $comments = array(); $nAdventures = array(); $i = 0; foreach ($adventures as $adventure) { $nbVotes = DAL::countVotesForAdventure($adventure->getId()); $photos = DAL::getPhotosAdventure($adventure->getId()); $tags = DAL::getTagsAdventure($adventure->getId()); $comments = DAL::getCommentsAdventure($adventure->getId()); $author = DAL::getUserById($adventure->getUser_id()); $adventure->setNumberOfVotes($nbVotes); $adventure->setTags($tags); $adventure->setPhotos($photos); $adventure->setComments($comments); $adventure->setAuthor($author->getUsername()); $nAdventures[] = $adventure; } return $nAdventures; }