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

2022-11-17 15:37:23 浏览数 (1)

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


1、网站根目录新建geturl.php文件,将代全部码粘贴通过浏览器访问该文件即可(例如:域名/geturl.php

代码:

代码语言:javascript复制
<?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/>";
      }
?>

如果你的是ID的话(就是你的文章链接是这样的 https://www.xiaohulizyw.com/?p=520)就使用这个代码:

代码语言:javascript复制
<?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/>";
      }
?>

效果:

二、如果您有百度小程序的话可以使用这个代码直接生成文章路径,如图

代码:

代码语言:javascript复制
<?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/>";
      }
?>

声明:本站所有文章,如无特殊说明或标注,均为本站原创发布。任何个人或组织,在未征得本站同意时,禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益,可联系我们进行处理。

0 人点赞