Return XML of Post Metadata

The best solution is to create a custom XML page template in the exact format you need. If you look at the code below taken from the WordPress XML exporter you can see that the data it returns contains the normal stuff we see in a typical WordPress loop. 

echo '<?xml version="1.0" encoding="' . get_bloginfo('charset') . '"?' . ">\n";
?>
<!-- This is a WordPress eXtended RSS file generated by WordPress as an export of your blog. -->
<!-- It contains information about your blog's posts, comments, and categories. -->
<!-- You may use this file to transfer that content from one site to another. -->
<!-- This file is not intended to serve as a complete backup of your blog. -->

<!-- To import this information into a WordPress blog follow these steps. -->
<!-- 1. Log into that blog as an administrator. -->
<!-- 2. Go to Tools: Import in the blog's admin panels (or Manage: Import in older versions of WordPress). -->
<!-- 3. Choose "WordPress" from the list. -->
<!-- 4. Upload this file using the form provided on that page. -->
<!-- 5. You will first be asked to map the authors in this export file to users -->
<!--    on the blog.  For each author, you may choose to map to an -->
<!--    existing user on the blog or to create a new user -->
<!-- 6. WordPress will then import each of the posts, comments, and categories -->
<!--    contained in this file into your blog -->

<?php the_generator('export');?>
<rss version="2.0"
    xmlns:excerpt="http://wordpress.org/export/<?php echo WXR_VERSION; ?>/excerpt/"
    xmlns:content="http://purl.org/rss/1.0/modules/content/"
    xmlns:wfw="http://wellformedweb.org/CommentAPI/"
    xmlns:dc="http://purl.org/dc/elements/1.1/"
    xmlns:wp="http://wordpress.org/export/<?php echo WXR_VERSION; ?>/"
>

<channel>
    <title><?php bloginfo_rss('name'); ?></title>
    <link><?php bloginfo_rss('url') ?></link>
    <description><?php bloginfo_rss("description") ?></description>
    <pubDate><?php echo mysql2date('D, d M Y H:i:s +0000', get_lastpostmodified('GMT'), false); ?></pubDate>
    <generator>http://wordpress.org/?v=<?php bloginfo_rss('version'); ?></generator>
    <language><?php echo get_option('rss_language'); ?></language>
    <wp:wxr_version><?php echo WXR_VERSION; ?></wp:wxr_version>
    <wp:base_site_url><?php echo wxr_site_url(); ?></wp:base_site_url>
    <wp:base_blog_url><?php bloginfo_rss('url'); ?></wp:base_blog_url>
<?php if ( $cats && ($terms == 'all' || $terms == 'cats')) : foreach ( $cats as $c ) : ?>
    <wp:category><wp:category_nicename><?php echo $c->slug; ?></wp:category_nicename><wp:category_parent><?php echo $c->parent ? $cats[$c->parent]->name : ''; ?></wp:category_parent><?php wxr_cat_name($c); ?><?php wxr_category_description($c); ?></wp:category>
<?php endforeach; endif; ?>
<?php if ( $tags && ($terms == 'all' || $terms == 'tags')) : foreach ( $tags as $t ) : ?>
    <wp:tag><wp:tag_slug><?php echo $t->slug; ?></wp:tag_slug><?php wxr_tag_name($t); ?><?php wxr_tag_description($t); ?></wp:tag>
<?php endforeach; endif; ?>
    <?php do_action('rss2_head'); ?>
    <?php if ($post_ids) {
        global $wp_query;
        $wp_query->in_the_loop = true;  // Fake being in the loop.
        // fetch 20 posts at a time rather than loading the entire table into memory
        while ( $next_posts = array_splice($post_ids, 0, 20) ) {
            $where = "WHERE ID IN (".join(',', $next_posts).")";
            $posts = $wpdb->get_results("SELECT * FROM $wpdb->posts $where ORDER BY post_date_gmt ASC");
                foreach ($posts as $post) {
                    setup_postdata($post); ?>
<item>
<title><?php echo apply_filters('the_title_rss', $post->post_title); ?></title>
<link><?php the_permalink_rss() ?></link>
<pubDate><?php echo mysql2date('D, d M Y H:i:s +0000', get_post_time('Y-m-d H:i:s', true), false); ?></pubDate>
<dc:creator><?php echo wxr_cdata(get_the_author()); ?></dc:creator>
<?php wxr_post_taxonomy() ?>

<guid isPermaLink="false"><?php the_guid(); ?></guid>
<description></description>
<content:encoded><?php echo wxr_cdata( apply_filters('the_content_export', $post->post_content) ); ?></content:encoded>
<wp:post_date><?php echo $post->post_date; ?></wp:post_date>
<wp:post_date_gmt><?php echo $post->post_date_gmt; ?></wp:post_date_gmt>
    </item>
<?php } } } ?>
</channel>
</rss>
<?php
}

Related Posts:

  1. $wpdb->get_row() only returns a single row?
  2. WordPress 4.8.1 uses mysql_connect which doesn’t work with PHP 7
  3. How to use $wpdb to delete in a custom table
  4. Matching database content types to PHP types
  5. Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
  6. $wpdb->last_error doesn’t show the query on error
  7. Saving custom form data into database
  8. Get data from database table by post_id to get data from second database table
  9. wp-content/db.php : where is this file?
  10. $wpdb sql help. Select post id and post meta value based on 2 other post_meta values
  11. $wpdb->get_results() returns good result only in first foreach iteration
  12. $wpdb->insert – inserting multiple rows
  13. $wpdb prepared with search term
  14. WPDB->insert with special characters
  15. What does wp_update_post() do that the $wpdb class does not?
  16. Is there a (better) way to access $wpdb results?
  17. $wpdb->prepare not working with update table prefix
  18. How to use prepare to query with variables
  19. Use $wpdb in wordpress theme files
  20. wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
  21. Problem in creating table through plugin code
  22. I want to update my postcontent with $wpdb
  23. XOR functionality for meta_query
  24. $wpdb->replace / Replace or update primary key
  25. Create an array with a string key from wpdb->get_results
  26. $wpdb – do you have to use foreach even if there will always only be one result?
  27. Replicating the WP_Query ‘s’ param with $wpdb
  28. Need help writing a $wpdb query
  29. get the number of queries made on a page(inside my plugin)
  30. Doing a loop with multiple DBs simultaneoulsy
  31. $wpdb->insert query changes to SHOW COLUMNS query Output
  32. Fixing wpdb->get_results and wpdb->prepare?
  33. How does the WXR file differ from the WPDB?
  34. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  35. Modify the structure of data returned by $wpdb
  36. WPDB If primary key already exists, add +1 to integer field
  37. How to get an array of user roles with or without a specific capability?
  38. What is wrong with this wpdb update?
  39. Programmatically Creating Page using $wpdb and getting 404 error
  40. Problem in inserting row to custom database table
  41. sanitize_text_field and apostrophe problem
  42. $wpdb->prepare with ON DUPLICATE KEY UPDATE
  43. 301 Redirect Code
  44. wpdb updating record in wordpress with json adds extra array elements
  45. How to display a specific category using a custom Query?
  46. $wpdb->insert inserting only f character in custom table
  47. AWS Bitnami WordPress – SELECT command denied to user
  48. WPDB Placeholders and second argument for prepared statements
  49. PHP Fatal Error – $wpdb a non-object?
  50. Why does wpdb->update delete other meta?
  51. Increment integer field in database when WHERE needs to be dynamic [closed]
  52. Getting variable from Database
  53. How do I count columns on a custom WPDB query?
  54. Custom $wpdb returns unexpected time based results
  55. Trouble inserting string containing quotations marks with wpdb in save_post hook
  56. $wpdb->prepare was called incorrectly when inserting multiple records
  57. How to protect a script execution on WordPress?
  58. how to connect to another database in wordpress
  59. wpdb query not working
  60. Save sql file after doing insert wpdb
  61. Perform a function when a user clicks register button
  62. Can I use wpdb to insert query results into a post?
  63. WPDB Query Question with Category Only
  64. $wpdb->prepare error after WordPress update [duplicate]
  65. $wpdb->num_rows doesn’t work
  66. $wpdb->get_var next var?
  67. How do I modify this wpdb query to include posts that have a post_status of publish and draft?
  68. Can’t find out why dbDelta dosen’t create my table
  69. How to pass an input value into wpdb->Prepare
  70. Check if Value Exists in Database, adding row details to variables and echoing result
  71. wpdb replace returning 1 where delete and insert is expected
  72. wpdb discards duplicate column names?
  73. update_post_meta not working in template_redirect action
  74. Get records from Formidable Table using $wpdb->get_col
  75. WPDB SQL query SELECT from category
  76. How to work with constraints on wordpress user metadata?
  77. How to Update multiple rows using $wpdb->update
  78. Unable to use $wpdb in WordPress
  79. How to display specific data from custom database table in WordPress
  80. Get 3 row ID’s via ARRAY_A
  81. Getting record from three wpdb tables
  82. Why is an empty result an error? ( $wpdb->get_row )
  83. get_row returns empty when data exists
  84. wpdb->update update the entire table instead of one row
  85. wpdb insert working in one function, but not another
  86. How to set up prepared query using IN statement
  87. Save customizer default values to DB on theme activation
  88. Plugin with connection to database – Single function
  89. Alter the main search query to search posts by coauthor user name
  90. WPDB Prepared Delete
  91. wpdb select from using array as search parameters
  92. wpdb Cannot Access Associative Array Data in a Count Query
  93. Using $wpdb to update current post
  94. Can’t get expected result from a wpdb query
  95. Can’t seem to get set_blog_id working, it just doesn’t reset the blog ID
  96. selecting row using wpdb which contain special symbols
  97. Query Problem in Clustom Plugin
  98. How does $wpdb->get_var work with offset?
  99. query_vars doesn’t return query string (trying to get data from $wpdb)
  100. $wpdb->prepare UPDATE process not work in functions.php