Example #1
0
 */
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>";