public function update(Client $client) { $query = $this->_db->prepare('UPDATE t_client SET nom=:nom, nomArabe=:nomArabe, adresse=:adresse, adresseArabe=:adresseArabe, telephone1=:telephone1, telephone2=:telephone2, cin=:cin, email=:email, updated=:updated, updatedBy=:updatedBy WHERE id=:id') or die(print_r($this->_db->errorInfo())); $query->bindValue(':id', $client->id()); $query->bindValue(':nom', $client->nom()); $query->bindValue(':nomArabe', $client->nomArabe()); $query->bindValue(':adresse', $client->adresse()); $query->bindValue(':adresseArabe', $client->adresseArabe()); $query->bindValue(':telephone1', $client->telephone1()); $query->bindValue(':telephone2', $client->telephone2()); $query->bindValue(':cin', $client->cin()); $query->bindValue(':email', $client->email()); $query->bindValue(':updated', $client->updated()); $query->bindValue(':updatedBy', $client->updatedBy()); $query->execute(); $query->closeCursor(); }