public function getUnique($comment_id) { $sql = 'SELECT * FROM t_for_commentc INNER JOIN t_for_memberc ON FCC_fk_FMC = FMC_id WHERE FCC_id = :comment_id'; $requete = $this->dao->prepare($sql); $requete->bindValue('comment_id', $comment_id, \PDO::PARAM_INT); $requete->execute(); $Comment = new Comment(); while ($data = $requete->fetch()) { $Comment->setAuteurId($data['FCC_fk_FMC']); $Comment->setId($data['FCC_id']); $Comment->setContenu($data['FCC_content']); $Comment->setNewsId($data['FCC_fk_FNC']); $Comment->setDateAjout(new \DateTime($data['FCC_dateadd'])); $Comment->setDateModif(new \DateTime($data['FCC_dateupdate'])); $Comment->setMembre(new Member(array('login' => $data['FMC_login'], 'id' => $data['FMC_id']))); } if ($Comment->id()) { return $Comment; } return false; }