public function update(Charge $charge) { $query = $this->_db->prepare(' UPDATE t_charge SET type=:type, dateOperation=:dateOperation, montant=:montant, societe=:societe, designation=:designation, updated=:updated, updatedBy=:updatedBy WHERE id=:id') or die(print_r($this->_db->errorInfo())); $query->bindValue(':id', $charge->id()); $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(':updated', $charge->updated()); $query->bindValue(':updatedBy', $charge->updatedBy()); $query->execute(); $query->closeCursor(); }