<?php


class BannerTeste extends Model
{
    public $table = 'BannerTeste1';

    public function Cadastrar($data)
    {
        $query = "INSERT INTO " . $this->table . " VALUES (null,'".$data['Url']."', '".$data['Descricao']."')";
        return $this->execute($query,$erro);
    }

    public function listar()
    {
        $query = "SELECT * FROM " . $this->table;
        return $this->getResult($query);
    }

    public function Excluir($id)
    {
        $query = "DELETE FROM " . $this->table . " WHERE id = $id";
        return $this->execute($query, $erro);
    }

    public function Alterar($data)
    {
        $query = "UPDATE " . $this->table . " SET url = '" . $data['url'] . "', descricao = '" . $data['descricao'] . "' WHERE id = " . $data['id'];
        return $this->execute($query, $erro);
    }
}