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
