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