<?php
include 'connection.php';
include 'funciones.php';
$editdata = json_decode(file_get_contents("php://input"));
date_default_timezone_set('America/El_Salvador');
$id = $editdata->id;
$fecha = date('Y-m-d');
$hora = date('H:i:s');
mysql_query("insert into resultado(idRespuesta,fecha,hora) values({$id},'{$fecha}','{$hora}')");
echo json_encode(array('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');
$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()));
