*/ session_start(); header("Content-Type: text/xml; charset=utf-8"); ob_clean(); $pagina = $_REQUEST['PAGINA']; $tamanio = $_REQUEST['TAMANIO']; //para la query ver de donde pido if (!$pagina) { $inicio = 0; $pagina = 1; } else { $inicio = ($pagina - 1) * $tamanio; } include_once '../DataBase/BDconfig.php'; $db = new Database(); $dblink = $db->bdconnect(); //sacamos el total $query2 = "SELECT count(1) as total\n \t\t\t\t\tfrom `wp_posts`, `wp_users`, `wp_postmeta`\n\t \t\t\t\twhere `wp_posts`.`ID` = `wp_postmeta`.`post_id` \n\t\t\t\t\t\t AND `wp_postmeta`.`meta_key` like '_aioseop_description'\n\t\t\t\t\t\t AND `wp_users`.`ID` = `wp_posts`.`post_author`\n\t\t\t\t\t\t AND `wp_posts`.`post_status` like 'publish'\n\t\t\t\t\t\t AND `wp_posts`.`post_type` like 'post'\n\n"; if ($result2 = $dblink->query($query2)) { while ($row2 = $result2->fetch_object()) { $total = "<TOTAL>" . $row2->total . "</TOTAL>"; } } $query = "SELECT wp_posts.ID as id, `post_date` as fecha, `display_name` as autor, `post_title` as titulo,\n `meta_value` as resumen, `post_content` as contenido,\n `comment_count` as cantidad_comentarios\n from `wp_posts`, `wp_users`, `wp_postmeta`\n\t\t\t\twhere `wp_posts`.`ID` = `wp_postmeta`.`post_id` \n\t\t\t\t AND `wp_postmeta`.`meta_key` like '_aioseop_description'\n\t\t\t\t AND `wp_users`.`ID` = `wp_posts`.`post_author`\n\t\t\t\t AND `wp_posts`.`post_status` like 'publish'\n\t\t\t\t AND `wp_posts`.`post_type` like 'post'\n\t\t\t\torder by `post_date`desc"; if ($result = $dblink->query($query)) { $noticia = ""; while ($row = $result->fetch_object()) { $id = "<ID>" . $row->id . "</ID>"; $autor = "<AUTOR>" . $row->autor . "</AUTOR>"; $fecha = "<FECHA>" . $row->fecha . "</FECHA>"; $titulo = "<TITULO>" . $row->titulo . "</TITULO>";