protected function add(Comment $comment) { if ($comment->email() != null) { $q = $this->dao->prepare('INSERT INTO T_NEW_commentc SET NCC_fk_NNC = :news, NCC_auteur = :auteur, NCC_email = :email, NCC_content = :contenu, NCC_date = NOW()'); $q->bindValue(':email', $comment->email()); } else { $q = $this->dao->prepare('INSERT INTO T_NEW_commentc SET NCC_fk_NNC = :news, NCC_fk_NMC = :auteur, NCC_content = :contenu, NCC_date = NOW()'); } $q->bindValue(':news', $comment->news(), \PDO::PARAM_INT); $q->bindValue(':auteur', $comment->auteur()); $q->bindValue(':contenu', $comment->contenu()); $q->execute(); $comment->setId($this->dao->lastInsertId()); }