<?php class lmAnswerManager { private $db; // PDO Instance /** * Constructeur du manager de la class Users */ public function __construct(){ $this->db = DbConnect::GetInstance()->GetConnexion(); } /** * Méthode permettant de lister toutes les réponses aux questionnaires * @return Array */ public function ListAnswers(){ $tabResult = false; $query = $this->db->prepare('SELECT * FROM lime_survey_'.$_SESSION["CONFIG"]["LS_SURVEYID"]); $result = $query->execute(); $tabResult = array(); while($result = $query->fetch(PDO::FETCH_ASSOC)){ $tabResult[] = $result; } return $tabResult; } /** * Méthode permettant d'instancier une réponse * @param int $id * @return Array */ public function GetAnswer($id){ $tabResult = false; $query = $this->db->prepare('SELECT * FROM lime_survey_'.$_SESSION["CONFIG"]["LS_SURVEYID"].' WHERE id=:id '); $query->bindValue(':id',$id); $query->execute(); while($result = $query->fetch(PDO::FETCH_ASSOC)){ $tabResult[] = $result; } return $tabResult; } } ?>