WordPress中建立文章存档页面的方法

<?php/*
* Template Name: sitemap
* @author: Ludou
* @Blog : https://**.ludou.org/
*/

<div class="myArchive">
<ul>
<?php
/**
* WordPress分类存档页面
* 作者：露兜
* 博客：https://**.ludou.org/
* 较后修改：2012年8月27日
*/
$categoryPosts = $wpdb->get_results("
SELECT post_title, ID, post_name, slug, {$wpdb->prefix}terms.term_id AS catID, {$wpdb->prefix}terms.name AS categoryname
FROM {$wpdb->prefix}posts, {$wpdb->prefix}term_relationships, {$wpdb->prefix}term_taxonomy, {$wpdb->prefix}terms
WHERE {$wpdb->prefix}posts.ID = {$wpdb->prefix}term_relationships.object_id
AND {$wpdb->prefix}terms.term_id = {$wpdb->prefix}term_taxonomy.term_id
AND {$wpdb->prefix}term_taxonomy.term_taxonomy_id = {$wpdb->prefix}term_relationships.term_taxonomy_id
AND {$wpdb->prefix}term_taxonomy.taxonomy = 'category'
AND {$wpdb->prefix}posts.post_status = 'publish'
AND {$wpdb->prefix}posts.post_type = 'post'
ORDER BY {$wpdb->prefix}terms.term_id, {$wpdb->prefix}posts.post_date DESC");

$postID = 0;
if ( $categoryPosts ) :
$category = $categoryPosts[0]->catID;
foreach ($categoryPosts as $key => $mypost) :
if($postID == 0) {
echo '<li><strong>分类:</strong> <a title="'.$mypost->categoryname.'" href="'.get_category_link($mypost->catID).'">'.$mypost->categoryname."</a>n";
echo '<ul>';
}

if($category == $mypost->catID) {
?>
<li><a title="<?php echo $mypost->post_title; ?>" href="<?php echo get_permalink( $mypost->ID ); ?>"><?php echo $mypost->post_title; ?></a></li>
<?php
$category = $mypost->catID;
$postID++;
}
else {
echo "</ul>n</li>";
echo '<li><strong>分类:</strong> <a title="'.$mypost->categoryname.'" href="'.get_category_link($mypost->catID).'">'.$mypost->categoryname."</a>n";
echo '<ul>';
?>
<li><a title="<?php echo $mypost->post_title; ?>" href="<?php echo get_permalink( $mypost->ID ); ?>"><?php echo $mypost->post_title; ?></a></li>
<?php
$category = $mypost->catID;
$postID = 1;
}
endforeach;
endif;
echo "</ul>n</li>";
?>

<li><strong>页面</strong>
<ul>
<?php
// 读取所有页面
$mypages = $wpdb->get_results("
SELECT post_title, post_name, ID
FROM {$wpdb->prefix}posts
WHERE post_status = 'publish'
AND post_type = 'page'");

if ( $mypages ) :
foreach ($mypages as $mypage) :
?>
<li><a title="<?php echo $mypage->post_title; ?>" href="<?php echo get_permalink( $mypage->ID ); ?>"><?php echo $mypage->post_title; ?></a></li>
<?php endforeach; echo "</ul>n</li>"; endif; ?>
</ul>
<p><a href="https://**.ludou.org/sitemap.xml">查看 sitemap.xml</a></p>
</div>

.myArchive {
line-height:18px;
margin:1.5em 0;
color:#555555;
font-size:14px;
}
.myArchive h2 {
font-size:16px;
margin:0 0 10px;
font-weight:bold;
}
.myArchive ul {
line-height:21px;
padding:0 0 0 2em;
}
.myArchive ul li {
background:none;
list-style-type:disc;
margin:0;
padding-left:10px;
}
.myArchive a {
color:#2970A6;
outline:medium none;
text-decoration:none;
}
.myArchive a:hover {
text-decoration:underline;
}
.myArchive ul li ul {
margin:10px 0;
}
.myArchive ul li ul li {
list-style-type:circle;
}

echo '<ul>';
wp_get_archives('type=postbypost&show_post_count=1');
echo '</ul>';