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