public function add(Charge $charge) { $query = $this->_db->prepare(' INSERT INTO t_charge ( type, dateOperation, montant, societe, designation, idProjet, created, createdBy) VALUES (:type, :dateOperation, :montant, :societe, :designation, :idProjet, :created, :createdBy)') or die(print_r($this->_db->errorInfo())); $query->bindValue(':type', $charge->type()); $query->bindValue(':dateOperation', $charge->dateOperation()); $query->bindValue(':montant', $charge->montant()); $query->bindValue(':societe', $charge->societe()); $query->bindValue(':designation', $charge->designation()); $query->bindValue(':idProjet', $charge->idProjet()); $query->bindValue(':created', $charge->created()); $query->bindValue(':createdBy', $charge->createdBy()); $query->execute(); $query->closeCursor(); }