header('Content-type: text/html; charset=utf-8'); } if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') { if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_METHOD'])) { header("Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS"); } if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS'])) { header("Access-Control-Allow-Headers: {$_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']}"); } } include "mysql.class.php"; $database = new MySQL(); global $database; if (!isset($_GET["parametro"])) { if ($database->Query("SELECT\n kiiconnect_setting.nombre,\n kiiconnect_setting.tag,\n kiiconnect_setting.descripcion,\n kiiconnect_setting.icono,\n kiiconnect_setting.link,\n kiiconnect_categoria.nombre AS categoria,\n kiiconnect_categoria.id AS id_categoria,\n kiiconnect_categoria.filecategoria,\n kiiconnect_categoria.filecategoria2,\n kiiconnect_categoria.icono AS categoria_icono\n FROM\n kiiconnect_setting\n INNER JOIN kiiconnect_categoria ON kiiconnect_setting.id_categoria = kiiconnect_categoria.id\n WHERE\n activo = 1\n ORDER BY\n orden ASC")) { echo $database->GetJSON(); } else { echo "<p>Query Failed</p>"; } } else { $temp = $database->QueryArray("SELECT\n kiiconnect_categoria.nombre AS categoria,\n kiiconnect_categoria.id AS id_categoria,\n kiiconnect_categoria.iconodev AS categoria_icono,\n kiiconnect_categoria.filecategoriadev AS filecategoria\n FROM\n kiiconnect_categoria\n WHERE\n activo = 1\n ORDER BY orden2", MYSQL_ASSOC); $temp2 = array(); foreach ($temp as $index => $categoria) { $categoria_id = $categoria['id_categoria']; // CONCAT('" . '<span style="font-weight:bold">' ." ', kiiconnect_setting.nombre, '</span>') AS nombre, $itemsCategoria = $database->QueryArray("SELECT\n kiiconnect_setting.nombre,\n kiiconnect_setting.tag,\n kiiconnect_setting.descripcion,\n kiiconnect_setting.icono,\n kiiconnect_setting.file,\n kiiconnect_setting.link\n FROM\n kiiconnect_setting\n WHERE\n activo = 1 AND id_categoria = {$categoria_id}\n ORDER BY\n orden ASC", MYSQL_ASSOC); if ($itemsCategoria != false) { $categoria['items'] = $itemsCategoria; $temp2[] = $categoria; } }
<?php include "mysql.class.php"; $databaseXmltv = new MySQL(); if ($databaseXmltv->Query("SELECT xmltv_canal.id,\n xmltv_canal.nombre as title\n FROM xmltv_canal WHERE activo = 1 ORDER BY orden")) { $canales = $databaseXmltv->GetJSON(); $data = $databaseXmltv->RecordsArray(); } else { $canales = "''"; } ////////////////////////// ?> { "calendars": <?php echo $canales; ?> }
header('Access-Control-Allow-Methods: POST, GET, OPTIONS'); header('Content-type: text/html; charset=utf-8'); } if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') { if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_METHOD'])) { header("Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS"); } if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS'])) { header("Access-Control-Allow-Headers: {$_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']}"); } } ////////////////////////// include "mysql.class.php"; $databaseXmltv = new MySQL(); if ($databaseXmltv->Query("SELECT xmltv_canal.id,\n xmltv_canal.nombre,\n xmltv_canal.file\n FROM xmltv_canal WHERE activo = 1 ORDER BY orden")) { $canales = $databaseXmltv->GetJSON(); } else { $canales = "''"; } //CONCAT(UNIX_TIMESTAMP (fecha_inicio), '000') as inicio, //CONCAT(UNIX_TIMESTAMP (fecha_fin), '000') as fin, // consulta que me devuelve los programas segun la fecha (ejemplo en fecha actual ) $programas = programacion($fecha); if ($databaseXmltv->Query("SELECT xmltv_programacion.id,\n xmltv_programacion.id_canal,\n xmltv_programacion.id_programa,\n xmltv_programa.titulo,\n IF(length(xmltv_programacion.descripcion) > 0, CONCAT(xmltv_programa.descripcion, ', ' , xmltv_programacion.descripcion) , xmltv_programa.descripcion ) AS descripcion,\n xmltv_programa.tipo,\nDAYOFWEEK(xmltv_programacion.creado),\n CONCAT(CAST(UNIX_TIMESTAMP (CONCAT(CURDATE(), ' ', horario)) AS INT), '000') as inicio,\n CONCAT(CAST(UNIX_TIMESTAMP (CONCAT(CURDATE(), ' ', horario)) AS INT) + xmltv_programacion.duracion * 60, '000') as fin,\n xmltv_programacion.duracion,\n xmltv_programa.file\n FROM xmltv_programacion INNER JOIN xmltv_programa ON xmltv_programacion.id_programa = xmltv_programa.id\n\t\t\t\t\t\t\tWHERE IF(xmltv_programacion.fecha_fin IS NOT NULL, xmltv_programacion.fecha_inicio < CURDATE() AND CURDATE() < xmltv_programacion.fecha_fin , xmltv_programacion.fecha_inicio < CURDATE()) AND\n\t\t\t\t\t\t\txmltv_programa.activo = 1;\n\t\t\t\t\t\t\t")) { $programas = $databaseXmltv->GetJSON(); } else { $programas = "''"; } ////////////////////////// $json = '[{ "categoria": "canal",
header("Access-Control-Allow-Origin: {$_SERVER['HTTP_ORIGIN']}"); header('Access-Control-Allow-Credentials: true'); header('Access-Control-Max-Age: 86400'); header('Access-Control-Allow-Origin: *'); header('Access-Control-Allow-Methods: POST, GET, OPTIONS'); header('Content-type: text/html; charset=utf-8'); } if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') { if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_METHOD'])) { header("Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS"); } if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS'])) { header("Access-Control-Allow-Headers: {$_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']}"); } } include "mysql.class.php"; $databaseKiiconnect = new MySQL(); global $databaseKiiconnect; // if (isset($_GET["tags"])) { $tags = $_GET["tags"]; $bodytag = '"' . str_replace(",", '","', $tags) . '"'; $consultaTag = "AND tag in ({$bodytag})"; } else { $consultaTag = ""; } if ($databaseKiiconnect->Query("SELECT *\n FROM\n kiiconnect_mensajes\n WHERE activo = 1 {$consultaTag}\n ORDER BY creado DESC ")) { echo $databaseKiiconnect->GetJSON(); } else { echo "<p>Query Failed</p>"; }