<?php include 'connection.php'; include 'funciones.php'; error_reporting(E_ERROR | E_WARNING | E_PARSE); date_default_timezone_set('America/El_Salvador'); $ediinfo = mysql_query("SELECT idArticulo as id,titulo, fecha, preview\n\t\t\t\t\t\tFROM articulo\n\t\t\t\t\t\tWHERE idSubseccion = 1 and activo = 1\n\t\t\t\t\t\tORDER BY fecha desc, hora desc\n\t\t\t\t\t\tlimit 3"); $triinfo = mysql_query("SELECT a.idArticulo as id, a.titulo, CONCAT(c.nombres, ' ', c.apellidos) as autor, a.fecha, c.idPersonal\n\t\t\t\t\t\tfrom personal as c, articulo as a\n\t\t\t\t\t\twhere c.idPersonal = a.idPersonal and a.idSubseccion = 3 and a.activo = 1\n\t\t\t\t\t\tORDER BY a.fecha desc, a.hora desc\n\t\t\t\t\t\tlimit 3"); $libinfo = mysql_query("SELECT a.idArticulo as id, a.titulo, c.rutaFoto as foto, CONCAT(c.nombres, ' ', c.apellidos) as autor, a.fecha, c.idPersonal\n\t\t\t\t\t\tfrom articulo as a, personal as c\n\t\t\t\t\t\twhere a.idSubseccion = 4 and a.idPersonal=c.idPersonal and a.activo = 1\n\t\t\t\t\t\tORDER BY a.fecha desc, a.hora desc\n\t\t\t\t\t\tlimit 3"); $acainfo = mysql_query("SELECT a.idArticulo as id, a.titulo, CONCAT(c.nombres, ' ', c.apellidos) as autor, a.fecha, c.idPersonal\n\t\t\t\t\t\tfrom articulo as a, personal as c\n\t\t\t\t\t\twhere a.idSubseccion = 6 and a.idPersonal=c.idPersonal and a.activo = 1\n\t\t\t\t\t\tORDER BY a.fecha desc, a.hora desc\n\t\t\t\t\t\tlimit 3"); $colinfo = mysql_query("SELECT CONCAT(nombres, ' ', apellidos) as nombre, idPersonal as id from personal where cargo='columnista'"); while ($edipreview = mysql_fetch_array($ediinfo)) { $editorial[] = array('id' => $edipreview['id'], 'titulo' => $edipreview['titulo'], 'fecha' => formatoFecha($edipreview['fecha']), 'preview' => $edipreview['preview']); } while ($colpreview = mysql_fetch_array($colinfo)) { $columnista[] = array('id' => $colpreview['id'], 'nombre' => $colpreview['nombre']); } while ($tripreview = mysql_fetch_array($triinfo)) { $tribuna[] = array('id' => $tripreview['id'], 'idPersonal' => $tripreview['idPersonal'], 'autor' => $tripreview['autor'], 'fecha' => formatoFecha($tripreview['fecha']), 'titulo' => $tripreview['titulo']); } while ($libpreview = mysql_fetch_array($libinfo)) { $libertad[] = array('id' => $libpreview['id'], 'idPersonal' => $libpreview['idPersonal'], 'foto' => $libpreview['foto'], 'fecha' => formatoFecha($libpreview['fecha']), 'titulo' => $libpreview['titulo'], 'autor' => $libpreview['autor']); } while ($acapreview = mysql_fetch_array($acainfo)) { $academia[] = array('id' => $acapreview['id'], 'idPersonal' => $acapreview['idPersonal'], 'titulo' => $acapreview['titulo'], 'autor' => $acapreview['autor'], 'fecha' => formatoFecha($acapreview['fecha'])); } echo json_encode(array('editoriales' => $editorial, 'caricaturas' => caricatura(), 'tribunas' => $tribuna, 'libertades' => $libertad, 'columnistas' => columna(), 'academias' => $academia, 'politicas' => dropdown(2), 'economias' => dropdown(5), 'sociedades' => dropdown(4), 'internacionales' => dropdown(3), 'subsecciones' => subseccion(1), 'culturas' => dropdown(6), 'autores' => $columnista, 'banner1' => banner(1, 1), 'banner2' => banner(1, 2), 'banner3' => banner(1, 3), 'banner4' => banner(1, 4), 'bannerMovil' => banner(1, 'movil'), 'leidos' => leidos(1), 'sondeo' => primerSondeo()));
$periodismo[] = array('id' => $id = $perpreview['id'], 'idPersonal' => $idPersonal = $perpreview['idPersonal'], 'foto' => $foto = $perpreview['foto'], 'titulo' => $titulo = $perpreview['titulo'], 'autor' => $autor = $perpreview['autor'], 'preview' => $preview = $perpreview['preview'], 'fecha' => $fecha = formatoFecha($perpreview['fecha']), 'subseccion' => $subseccion = $perpreview['subseccion'], 'fotografo' => $fotografo = $perpreview['fotografo']); } while ($intpreview = mysql_fetch_array($intinfo)) { $internacional[] = array('id' => $id = $intpreview['id'], 'idPersonal' => $idPersonal = $intpreview['idPersonal'], 'url' => $url = $intpreview['url'], 'foto' => $foto = $intpreview['foto'], 'titulo' => $titulo = $intpreview['titulo'], 'autor' => $autor = $intpreview['autor'], 'preview' => $preview = $intpreview['preview'], 'fecha' => $fecha = formatoFecha($intpreview['fecha']), 'subseccion' => $subseccion = $intpreview['subseccion'], 'fotografo' => $fotografo = $intpreview['fotografo']); } while ($culpreview = mysql_fetch_array($culinfo)) { $cultura[] = array('id' => $id = $culpreview['id'], 'idPersonal' => $idPersonal = $culpreview['idPersonal'], 'url' => $url = $culpreview['url'], 'foto' => $foto = $culpreview['foto'], 'titulo' => $titulo = $culpreview['titulo'], 'autor' => $autor = $culpreview['autor'], 'preview' => $preview = $culpreview['preview'], 'fecha' => $fecha = formatoFecha($culpreview['fecha']), 'subseccion' => $subseccion = $culpreview['subseccion'], 'fotografo' => $fotografo = $culpreview['fotografo']); } while ($polpreview = mysql_fetch_array($polinfo)) { $politica[] = array('id' => $id = $polpreview['id'], 'idPersonal' => $idPersonal = $polpreview['idPersonal'], 'url' => $url = $polpreview['url'], 'foto' => $foto = $polpreview['foto'], 'titulo' => $titulo = $polpreview['titulo'], 'autor' => $autor = $polpreview['autor'], 'preview' => $preview = $polpreview['preview'], 'fecha' => $fecha = formatoFecha($polpreview['fecha']), 'subseccion' => $subseccion = $polpreview['subseccion'], 'fotografo' => $fotografo = $polpreview['fotografo']); } while ($anepreview = mysql_fetch_array($aneinfo)) { $anecdota[] = array('id' => $id = $anepreview['id'], 'idPersonal' => $idPersonal = $anepreview['idPersonal'], 'foto' => $foto = $anepreview['foto'], 'titulo' => $titulo = $anepreview['titulo'], 'autor' => $autor = $anepreview['autor'], 'preview' => $preview = $anepreview['preview'], 'fecha' => $fecha = formatoFecha($anepreview['fecha']), 'subseccion' => $subseccion = $anepreview['subseccion'], 'fotografo' => $fotografo = $anepreview['fotografo']); } while ($entpreview = mysql_fetch_array($entinfo)) { $entrevista[] = array('id' => $id = $entpreview['id'], 'idPersonal' => $idPersonal = $entpreview['idPersonal'], 'foto' => $foto = $entpreview['foto'], 'titulo' => $titulo = $entpreview['titulo'], 'autor' => $autor = $entpreview['autor'], 'preview' => $preview = $entpreview['preview'], 'fecha' => $fecha = formatoFecha($entpreview['fecha']), 'subseccion' => $subseccion = $entpreview['subseccion'], 'fotografo' => $fotografo = $entpreview['fotografo'], 'fotoautor' => $fotoautor = $entpreview['fotoautor']); } while ($rompreview = mysql_fetch_array($rominfo)) { $rompiendo[] = array('id' => $id = $rompreview['id'], 'idPersonal' => $idPersonal = $rompreview['idPersonal'], 'foto' => $foto = $rompreview['foto'], 'titulo' => $titulo = $rompreview['titulo'], 'autor' => $autor = $rompreview['autor'], 'preview' => $preview = $rompreview['preview'], 'fecha' => $fecha = formatoFecha($rompreview['fecha']), 'subseccion' => $subseccion = $rompreview['subseccion'], 'fotografo' => $fotografo = $rompreview['fotografo'], 'fotoautor' => $fotoautor = $rompreview['fotoautor']); } while ($edipreview = mysql_fetch_array($ediinfo)) { $editorial[] = array('id' => $id = $edipreview['id'], 'preview' => $preview = $edipreview['preview'], 'titulo' => $titulo = $edipreview['titulo']); } while ($conpreview = mysql_fetch_array($coninfo)) { $contratabu[] = array('id' => $id = $conpreview['id'], 'foto' => $foto = $conpreview['foto'], 'titulo' => $titulo = $conpreview['titulo'], 'autor' => $autor = $conpreview['autor'], 'preview' => $preview = $conpreview['preview'], 'fecha' => $fecha = formatoFecha($conpreview['fecha']), 'subseccion' => $subseccion = $conpreview['subseccion'], 'fotografo' => $fotografo = $conpreview['fotografo']); } while ($esppreview = mysql_fetch_array($espinfo)) { $especial[] = array('id' => $id = $esppreview['id'], 'foto' => $foto = $esppreview['foto'], 'titulo' => $titulo = $esppreview['titulo'], 'autor' => $autor = $esppreview['autor'], 'preview' => $preview = $esppreview['preview'], 'fecha' => $fecha = formatoFecha($esppreview['fecha']), 'subseccion' => $subseccion = $esppreview['subseccion'], 'idPersonal' => $idPersonal = $esppreview['idPersonal'], 'urlSeccion' => $urlSeccion = $esppreview['urlSeccion'], 'urlSubseccion' => $urlSubseccion = $esppreview['urlSubseccion'], 'fotografo' => $fotografo = $esppreview['fotografo']); } echo json_encode(array('columnistas' => $columnista, 'actualidades' => $actualidad, 'control' => $control, 'tribunas' => $tribuna, 'negocios' => $negocio, 'coyunturas' => $coyuntura, 'analisiss' => $analisis, 'libertades' => $libertad, 'sociedades' => $sociedad, 'resenas' => $resena, 'academias' => $academia, 'deportes' => $deporte, 'periodismos' => $periodismo, 'culturas' => $cultura, 'internacionales' => $internacional, 'politicas' => $politica, 'anecdotas' => $anecdota, 'entrevistas' => $entrevista, 'rompiendos' => $rompiendo, 'editoriales' => $editorial, 'contratabues' => $contratabu, 'especiales' => $especial, 'fotogalerias' => fotogaleria(), 'banner1' => banner(8, 1), 'banner2' => banner(8, 2), 'banner3' => banner(8, 3), 'banner4' => banner(8, 4), 'banner5' => banner(8, 5), 'banner5' => banner(8, 5), 'banner6' => banner(8, 6), 'banner7' => banner(8, 7), 'banner8' => banner(8, 8), 'banner9' => banner(8, 9), 'banner10' => banner(8, 10), 'banner11' => banner(8, 11), 'banner12' => banner(8, 12), 'banner13' => banner(8, 13), 'banner14' => banner(8, 14), 'banner15' => banner(8, 15), 'banner16' => banner(8, 16), 'banner17' => banner(8, 17), 'banner18' => banner(8, 18), 'banner19' => banner(8, 19), 'banner20' => banner(8, 20), 'bannerMovil' => banner(8, 'movil'), 'sondeo' => primerSondeo(), 'caricaturas' => caricatura()));
<?php include 'connection.php'; include 'funciones.php'; error_reporting(E_ERROR | E_WARNING | E_PARSE); date_default_timezone_set('America/El_Salvador'); $editdata = json_decode(file_get_contents("php://input")); $busqueda = mysql_escape_string($_GET['query']); // $busqueda ="reunión"; $infox = "SELECT a.idArticulo as id, a.titulo,a.preview, a.fecha, s.nombre, s.url, CONCAT(c.nombres, ' ', c.apellidos) as autor, c.idPersonal, se.url as urlSeccion\n FROM articulo a, personal c, subseccion s, seccion se\n where (LOWER(a.titulo) like '%{$busqueda}%' or LOWER(CONCAT(c.nombres, ' ', c.apellidos)) like '%{$busqueda}%')\n and a.idPersonal = c.idPersonal and a.idSubseccion = s.idSubseccion and s.idSeccion = se.idSeccion\n ORDER BY a.fecha desc, a.hora desc"; // echo $infox; $info = mysql_query($infox); while ($result = mysql_fetch_array($info)) { $resultado[] = array('id' => $id = $result['id'], 'titulo' => $titulo = $result['titulo'], 'fecha' => $fecha = formatoFecha($result['fecha']), 'subseccion' => $subseccion = $result['nombre'], 'url' => $url = $result['url'], 'urlSeccion' => $urlSeccion = $result['urlSeccion'], 'autor' => $autor = $result['autor'], 'idPersonal' => $idPersonal = $result['idPersonal'], 'preview' => $preview = $result['preview']); } // (select se.url as urlSeccion, se.nombre as seccion from seccion as se where se.idSeccion=(select x.idSeccion from subseccion as x where x.idSubseccion=a.idSubseccion)) $colinfo = mysql_query("SELECT a.idColumna as id, a.titulo, a.fecha, CONCAT(c.nombres, ' ', c.apellidos) as autor,c.idPersonal\n FROM columna a, personal c\n where (LOWER(a.titulo) like '%{$busqueda}%' or LOWER(CONCAT(c.nombres, ' ', c.apellidos)) like '%{$busqueda}%') and a.idPersonal = c.idPersonal\n ORDER BY a.fecha desc, a.hora desc"); while ($colpreview = mysql_fetch_array($colinfo)) { $resultado[] = array('id' => $id = $colpreview['id'], 'titulo' => $titulo = $colpreview['titulo'], 'fecha' => $fecha = formatoFecha($colpreview['fecha']), 'subseccion' => "Columnistas", 'url' => "columnistas", 'autor' => $autor = $colpreview['autor'], 'idPersonal' => $idPersonal = $result['idPersonal'], 'urlSeccion' => 'opinion'); } echo json_encode(array('resultado' => $resultado, 'actualidades' => actualidad(), 'caricatura' => caricatura(), 'banner1' => banner(8, 1), 'banner2' => banner(8, 2), 'bannerMovil' => banner(8, 'movil')));