wordpress 根据日期调用全站文章url

在网站根目录新建一个url.php文件，然后把下面的代码粘贴进去，替换网站域名即可！

调用方法：

date  = 你需要调用的日期

https://www.123.com/url.php?date=2022-06-16

 
      include ( "wp-config.php" ) ; 
      require_once (ABSPATH.'wp-blog-header.php'); 
      global $wpdb; 
      $qianzui = "https://www.123.com/";//网站域名
      $houzui = ".html";//文章后缀
      $sj = $_GET['date'];
      $s = $sj.' 00:00:00';
      $l = $sj.' 23:59:59';
      $sql="SELECT ID FROM wp_posts WHERE post_type =  'post' AND post_status =  'publish' AND post_date>='$s' AND post_date<='$l' ORDER BY ID DESC "; 
      $myrows = $wpdb->get_results($sql);
      foreach ($myrows as $b) { 
        echo $qianzui;
        echo $b->ID;
        echo $houzui."<br/>";
      }