*/
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>";