是否可以显示与当前帖子类别相同的相关帖子？
如何显示同一类别的相关帖子？
4 个回复
最合适的回答,由SO网友:Michael 整理而成
一种可能性：
$related = get_posts(
array(
\'category__in\' => wp_get_post_categories( $post->ID ),
\'numberposts\' => 5,
\'post__not_in\' => array( $post->ID )
)
);
if( $related ) {
foreach( $related as $post ) {
setup_postdata($post);
/*whatever you want to output*/
}
wp_reset_postdata();
}
WP_Query():$related = new WP_Query(
array(
\'category__in\' => wp_get_post_categories( $post->ID ),
\'posts_per_page\' => 5,
\'post__not_in\' => array( $post->ID )
)
);
if( $related->have_posts() ) {
while( $related->have_posts() ) {
$related->the_post();
/*whatever you want to output*/
}
wp_reset_postdata();
}
SO网友:Lawrence Oputa
这里是另一个干净且非常灵活的选项：
将此代码放入函数中。php文件
function example_cats_related_post() {
$post_id = get_the_ID();
$cat_ids = array();
$categories = get_the_category( $post_id );
if(!empty($categories) && is_wp_error($categories)):
foreach ($categories as $category):
array_push($cat_ids, $category->term_id);
endforeach;
endif;
$current_post_type = get_post_type($post_id);
$query_args = array(
\'category__in\' => $cat_ids,
\'post_type\' => $current_post_type,
\'post__not_in\' => array($post_id),
\'posts_per_page\' => \'3\'
);
$related_cats_post = new WP_Query( $query_args );
if($related_cats_post->have_posts()):
while($related_cats_post->have_posts()): $related_cats_post->the_post(); ?>
<ul>
<li>
<a href="<?php the_permalink(); ?>">
<?php the_title(); ?>
</a>
<?php the_content(); ?>
</li>
</ul>
<?php endwhile;
// Restore original Post Data
wp_reset_postdata();
endif;
}
<?php example_cats_related_post() ?>
*编辑-您可以将此更改：post\\u not\\u in更改为查询中的此post\\u not\\u in
SO网友:almhdy
您可以使用此代码从同一类别获取相关帖子
$args = array(
\'category__in\' => wp_get_post_categories( get_queried_object_id() ),
\'posts_per_page\' => 5,
\'orderby\' => \'rand\',
\'post__not_in\' => array( get_queried_object_id() )
);
$the_query = new WP_Query( $args );
if ( $the_query->have_posts() ) : ?>
<ul class="">
<!-- the loop -->
<?php while ( $the_query->have_posts() ) : $the_query->the_post(); ?>
<li>
<h6>
<a href="<?php the_permalink(); ?>" title="<?php the_title_attribute(); ?>">
<?php the_title(); ?>
</a>
</h6>
</li>
<?php endwhile; ?>
<!-- end of the loop -->
</ul>
<?php wp_reset_postdata(); ?>
<?php endif; ?>
$tags = wp_get_post_terms( get_queried_object_id(), \'post_tag\', [\'fields\' => \'ids\'] );
$args = [
\'post__not_in\' => array( get_queried_object_id() ),
\'posts_per_page\' => 5,
\'orderby\' => \'rand\',
\'tax_query\' => [
[
\'taxonomy\' => \'post_tag\',
\'terms\' => $tags
]
]
];
$the_query = new WP_Query( $args );
if ( $the_query->have_posts() ) : ?>
<ul class="">
<!-- the loop -->
<?php while ( $the_query->have_posts() ) : $the_query->the_post(); ?>
<li>
<h6>
<a href="<?php the_permalink(); ?>" title="<?php the_title_attribute(); ?>">
<?php the_title(); ?>
</a>
</h6>
</li>
<?php endwhile; ?>
<!-- end of the loop -->
</ul>
<?php wp_reset_postdata(); ?>
<?php endif; ?>
SO网友:Felix Eve
这个答案确保了相关帖子是按照匹配的标签数量排序的。
例如，如果一篇文章有3个标签，而另一篇文章有完全相同的3个标签，那么它应该显示在列表的顶部。二级排序应按发布日期进行，以便于更新内容。
/**
* Select content with common tags.
* Sort so content with multiple matching tags are at the top.
* Secondary sort on most recent content first.
*
* @param $post_id
* @param int $limit
* @return array
*/
function related_posts($post_id, $limit = 5) {
global $wpdb;
$query = "SELECT TOP %d x.object_id as ID
FROM (
SELECT TOP 10 tr1.object_id, COUNT(tr1.term_taxonomy_id) AS common_tag_count
FROM {$wpdb->term_relationships} AS tr1
INNER JOIN {$wpdb->term_relationships} AS tr2 ON tr1.term_taxonomy_id = tr2.term_taxonomy_id
WHERE tr2.object_id = %d
GROUP BY tr1.object_id
HAVING tr1.object_id != %d
ORDER BY COUNT(tr1.term_taxonomy_id) DESC
) x
INNER JOIN {$wpdb->posts} p ON p.ID = x.object_id
ORDER BY common_tag_count DESC, p.post_date DESC;";
$query = $wpdb->prepare($query, $limit, $post_id, $post_id);
$ids = $wpdb->get_col($query);
$posts = [];
foreach($ids as $id) {
$posts[] = get_post($id);
}
return $posts;
}
注意：此查询是为SQL Server编写的，因此某些语法可能需要更新（例如，TOP vs LIMIT）。
结束