我试图只在侧边栏中显示当前类别的注释。到目前为止，我得到了这个：
但它不起作用，它要么到处显示0条评论，要么到处显示全部评论。我没有；I don’我不明白我做错了什么。。。
问题似乎出在这部分：//类别（可以是父类别）$cat=get_query_var（'cat'）；$category_present=$cat；
<?php
// Posts per page setting
$ppp = 8; //get_option('posts_per_page'); // either use the WordPress global Posts per page setting or set a custom one like $ppp = 10;
$custom_offset = 0; // If you are dealing with your custom pagination, then you can calculate the value of this offset using a formula
// category (can be a parent category)
$cat = get_query_var('cat');
$category_parent = $cat;
// lets fetch sub categories of this category and build an array
$categories = get_terms( 'category', array( 'child_of' => $category_parent, 'hide_empty' => false ) );
$category_list = array( $category_parent );
foreach( $categories as $term ) {
$category_list[] = (int) $term->term_id;
}
// fetch posts in all those categories
$posts = get_objects_in_term( $category_list, 'category' );
$sql = "SELECT comment_ID, comment_date, comment_content, comment_post_ID, user_id, comment_author
FROM {$wpdb->comments} WHERE
comment_post_ID in (".implode(',', $posts).") AND comment_approved = 1
ORDER by comment_date DESC LIMIT $ppp OFFSET $custom_offset";
$comments_list = $wpdb->get_results( $sql );
if ( count( $comments_list ) > 0 ) {
$date_format = get_option( 'date_format' );
foreach ( $comments_list as $comment ) {
?>
<li>
<a href="<?php echo ( get_permalink( $comment->comment_post_ID ) ); ?>#comment-<?php echo($comment->comment_ID); ?>"><?php echo get_avatar( $comment->user_id, 50 ); ?></a>
<span><strong><?php echo($comment->comment_author); ?></strong> commented on</span>
<h3><a href="<?php echo ( get_permalink( $comment->comment_post_ID ) ); ?>"><?php echo get_the_title ( $comment->comment_post_ID ); ?></a></h3>
<span><?php echo($comment->comment_date); ?></span>
<p>"<?php comment_excerpt(); ?>" <a href="<?php echo ( get_permalink( $comment->comment_post_ID ) ); ?>#comment-<?php echo($comment->comment_ID); ?>">Read More</a></p>
<div class="clearfloat"></div><!-- Very Important -->
</li>
<?php
}
} else {
echo '<p>No comments</p>';
}
?>
WordPress提供了一些功能，可以查询您需要的大部分内容。例如，有一个名为get_the_category()的函数，它将包括当前类别及其子类/祖先。
参考：
get_the_category()query_posts()
<?php
$ppp = 8;
$custom_offset = 0;
// get the current category (includes children/parents)
$categories = get_the_category();
// create an array that only has each category_id
$category_ids = array_map(function($category) {
return $category->cat_ID;
}, $categories);
// find all posts by the category ids
$posts = query_posts('cat=' . implode(',', $category_ids));
// create an array that only has each post_id
$post_ids = array_map(function($post) {
return $post->ID;
}, $posts);
// find all comments by post_ids
$sql = "SELECT comment_ID, comment_date, comment_content, comment_post_ID, user_id, comment_author
FROM {$wpdb->comments} WHERE
comment_post_ID in (".implode(',', $post_ids).") AND comment_approved = 1
ORDER by comment_date DESC LIMIT $ppp OFFSET $custom_offset";
$comments = $wpdb->get_results( $sql );
if( $comments ) {
// do stuff with $comments
}
?>