WordPress posts to CSV using WPDB class

php-wordpress-posts-to-csv.php

<?php
  # Author: Samuel Guebo
  # reference: https://codex.wordpress.org/Class_Reference/wpdb
  # Description: A simple snippet to display WordPress posts as in CSV (comma separated format).
  # The script uses WPDB class and can accessed directly if put in the Website's root (/script.php)
  
  // Include WordPress core features
  require_once("wp-blog-header.php"); 

  // Leverage WPDB class, utility for perfoming DB actions
  global $wpdb;
  
  // Build the query and get all posts with type "page"
  $result = $wpdb->get_results ( "
      SELECT *
      FROM  $wpdb->posts
          WHERE post_type = 'page'
  " );
  
  // Print headers of CSV columns
  echo 'ID, TITLE, LINK' . '<br/>';

  // Print rows of the CSV document
  foreach ( $result as $page )
  {
     echo $page->ID . ", " . $page->post_title.', '. get_the_permalink($page->ID) . '<br/>';
  }
?>