public function add(Commission $commission){ $query = $this->_db->prepare(' INSERT INTO t_commission ( titre, commissionnaire, montant, codeContrat, date, etat, created, createdBy) VALUES (:titre, :commissionnaire, :montant, :codeContrat, :date, :etat, :created, :createdBy)') or die (print_r($this->_db->errorInfo())); $query->bindValue(':titre', $commission->titre()); $query->bindValue(':commissionnaire', $commission->commissionnaire()); $query->bindValue(':montant', $commission->montant()); $query->bindValue(':codeContrat', $commission->codeContrat()); $query->bindValue(':date', $commission->date()); $query->bindValue(':etat', $commission->etat()); $query->bindValue(':created', $commission->created()); $query->bindValue(':createdBy', $commission->createdBy()); $query->execute(); $query->closeCursor(); }