public function update(Terrain $terrain) { $query = $this->_db->prepare(' UPDATE t_terrain SET numeroTitre=:numeroTitre,nom=:nom,superficie=:superficie,surplan=:surplan,emplacement=:emplacement,prix=:prix WHERE id=:id') or die(print_r($this->_db->errorInfo())); $query->bindValue(':id', $terrain->id()); $query->bindValue(':numeroTitre', $terrain->numeroTitre()); $query->bindValue(':nom', $terrain->nom()); $query->bindValue(':superficie', $terrain->superficie()); $query->bindValue(':surplan', $terrain->surplan()); $query->bindValue(':emplacement', $terrain->emplacement()); $query->bindValue(':prix', $terrain->prix()); $query->execute(); $query->closeCursor(); }
public function update(Terrain $terrain) { $query = $this->_db->prepare(' UPDATE t_terrain SET prix=:prix, vendeur=:vendeur, fraisAchat=:fraisAchat, superficie=:superficie, emplacement=:emplacement, updated=:updated, updatedBy=:updatedBy WHERE id=:idTerrain') or die(print_r($this->_db->errorInfo())); $query->bindValue(':idTerrain', $terrain->id()); $query->bindValue(':prix', $terrain->prix()); $query->bindValue(':vendeur', $terrain->vendeur()); $query->bindValue(':fraisAchat', $terrain->fraisAchat()); $query->bindValue(':superficie', $terrain->superficie()); $query->bindValue(':emplacement', $terrain->emplacement()); $query->bindValue(':updated', $terrain->updated()); $query->bindValue(':updatedBy', $terrain->updatedBy()); $query->execute(); $query->closeCursor(); }