php代码获取WordPress网站所有的文章链接

<?php
      include ( "wp-config.php" ) ;
      require_once (ABSPATH.'wp-blog-header.php');
      global $wpdb;
      $qianzui = "http://xxx.cn/";//网站域名
      $houzui = ".html";//文章后缀
      $sql="SELECT ID FROM wp_posts WHERE post_type =  'post' AND post_status =  'publish' ORDER BY ID DESC ";
      $myrows = $wpdb->get_results($sql);
      foreach ($myrows as $b) {
        echo $qianzui;
        echo $b->ID;
        echo $houzui."<br/>";
      }
?>

<?php
      include ( "wp-config.php" ) ;
      require_once (ABSPATH.'wp-blog-header.php');
      global $wpdb;
      $sql="SELECT guid FROM wp_posts WHERE post_type =  'post' AND post_status =  'publish' ORDER BY ID DESC ";
      $myrows = $wpdb->get_results($sql);
      foreach ($myrows as $b) {
        echo $b->guid."<br/>";
      }
?>

<?php
      include ( "wp-config.php" ) ;
      require_once (ABSPATH.'wp-blog-header.php');
      global $wpdb;
      $qianzui = "/pages/articles/articles?id=";//百度小程序路径地址
      $sql="SELECT ID FROM wp_posts WHERE post_type =  'post' AND post_status =  'publish' ORDER BY ID DESC ";
      $myrows = $wpdb->get_results($sql);
      foreach ($myrows as $b) {
        echo $qianzui;
        echo $b->ID;
        echo "<br/>";
      }
?>