public function findLikeAtrr($cadena) { $this->conexion->conectar(); $query = "SELECT * FROM banner WHERE upper(idImagen) LIKE upper(" . $cadena . ") OR upper(nombre) LIKE upper('" . $cadena . "') OR upper(ruta) LIKE upper('" . $cadena . "') OR upper(detalle) LIKE upper('" . $cadena . "') "; $result = $this->conexion->ejecutar($query); $i = 0; $banners = array(); while ($fila = mysql_fetch_assoc($result)) { $banner = new BannerDTO(); $banner->setIdImagen($fila['idImagen']); $banner->setNombre($fila['nombre']); $banner->setRuta($fila['ruta']); $banner->setTamanio($fila['tamanio']); $banner->setDetalle($fila['detalle']); $banners[$i] = $banner; $i++; } $this->conexion->desconectar(); return $banners; }
include_once '../../Controlador/Sistema.php'; $control = Sistema::getInstancia(); $accion = htmlspecialchars($_REQUEST['accion']); if ($accion != null) { if ($accion == "LISTADO") { $banners = $control->getAllBanners(); $json = json_encode($banners); echo $json; } else { if ($accion == "AGREGAR") { include_once "../../util/UpdateImagen.php"; $tamanio = htmlspecialchars($_REQUEST['tamañoDetalle']) . ""; $banner = new BannerDTO(); $banner->setNombre($_FILES['imagen']['name']); $banner->setRuta("Files/img/banner/" . $_FILES['imagen']['name']); $banner->setTamanio($tamanio . ""); $banner->setDetalle(""); $subir = new UpdateImagen($banner->getNombre(), $_FILES['imagen'], 2000000, "../../Files/img/banner/", 1400, 600, true); $result = $subir->update(); if ($result == true) { $result = $control->addBanner($banner); //Registramos la imagen en la BD if ($result) { echo json_encode(array('success' => true, 'mensaje' => "Imagen subida correctamente")); } else { echo json_encode(array('errorMsg' => 'Ha ocurrido un error.')); } } else { echo json_encode(array('errorMsg' => $result)); } /* if ($_FILES['imagen']['type'] == "image/jpg" || $_FILES['imagen']['type'] == "image/jpeg" || $_FILES['imagen']['type'] == "image/png") {//Validamos que sea una imagen