填一下以前文章中提到的WordPress获取所有文章链接的坑。
网站根目录
文章链接:https://cloud.tencent.com/developer/article/1151802
红色字体即为前缀,绿色即为后缀
<?php include ( "wp-config.php" ) ; require\_once (ABSPATH.'wp-blog-header.php'); global $wpdb; $qianzui = "https://www.qcgzxw.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/>"; } ?>
1234567891011121314 | <?php include ( "wp-config.php" ) ; require\_once (ABSPATH.'wp-blog-header.php'); global $wpdb; $qianzui = "https://www.qcgzxw.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/>"; } ?>
12345678910 | <?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; $CID = 1;//分类id $sql="SELECT ID,post\_title,post\_content FROM wp\_posts,wp\_term\_relationships,wp\_term\_taxonomy WHERE ID=object\_id and wp\_term\_relationships.term\_taxonomy\_id = wp\_term\_taxonomy.term\_taxonomy\_id and post\_type='post' and post\_status = 'publish' and wp\_term\_relationships.term\_taxonomy\_id = $CID and taxonomy = 'category' order by ID desc"; $myrows = $wpdb->get\_results($sql); foreach ($myrows as $b) { echo $b->ID."<br />"; } ?>
1234567891011 | <?php include ( "wp-config.php" ) ; require\_once (ABSPATH.'wp-blog-header.php'); global $wpdb; $CID = 1;//分类id $sql="SELECT ID,post\_title,post\_content FROM wp\_posts,wp\_term\_relationships,wp\_term\_taxonomy WHERE ID=object\_id and wp\_term\_relationships.term\_taxonomy\_id = wp\_term\_taxonomy.term\_taxonomy\_id and post\_type='post' and post\_status = 'publish' and wp\_term\_relationships.term\_taxonomy\_id = $CID and taxonomy = 'category' order by ID desc"; $myrows = $wpdb->get\_results($sql); foreach ($myrows as $b) { echo $b->ID."<br />"; }?> |
---|
更多玩法持续更新中···