예제 #1
0
    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();
    }