public function Lista() {
$sql = "SELECT * FROM banners";
$stmt = $this->conexao->prepare($sql);
$stmt->execute();
$searchResults = array();
while ($rs = $stmt->fetch(PDO::FETCH_OBJ)) {
$temp = new Banner();
$temp->setIdbanner($rs->idbanner);
$temp->setIdDepartamento($rs->iddepartamento);
$temp->setLado($rs->lado);
$temp->setNumero($rs->numero);
$temp->setBanner($rs->banner);
$temp->setDescricao($rs->descricao);
$temp->setWidth($rs->width);
$temp->setHeight($rs->height);
$temp->setUrl($rs->url);
$temp->setTarget($rs->target);
$temp->setClick($rs->click);
$temp->setData($rs->data);
$temp->setExtensao($rs->banner);
array_push($searchResults, $temp);
}
if(count($searchResults) > 1) {
return $searchResults;
} else {
return $temp;
}
}
$tmp_name = $_FILES["banner"]["tmp_name"];
$size = $_FILES["banner"]["size"];
$tamanho = 1000000;
list($largura, $altura) = getimagesize($_FILES["banner"]["tmp_name"]);
$setBanner = $name;
$setUrl = $_POST["url"];
$setTarget = $_POST["target"];
$setData = $tempo;
$setIddepartamento = $_POST["iddep"];
$setLado = $_POST["lado"];
$setNumero = $_POST["numero"];
$setWidth = $largura;
$setHeight = $altura;
$banner->setLado($setLado);
$banner->setIddepartamento($setIddepartamento);
$banner->setNumero($setNumero);
$banner->setBanner($setBanner);
$banner->setWidth($setWidth);
$banner->setHeight($setHeight);
$banner->setUrl($setUrl);
$banner->setTarget($setTarget);
$banner->setData($setData);
$ok = $banner->upload_banners($name, $type, $tmp_name, $size, $tamanho, $banner->getWidth(), $banner->getHeight());
if ($ok == true) {
$iddep = $banner->getIddepartamento();
$bannerDAO->Insere($banner);
header("location: ../principal.php?menu={$idmenu}&act={$act}&iddep={$iddep}");
} else {
header("location: ../principal.php?menu={$idmenu}&act={$act}");
}
break;