如何在wordpress中按子类别搜索帖子[关闭]

Question

How to search post by subcategories in wordpress. Is it even possible? I was going through the wordpress plugin for searching it. The name is "Facetious Search", but it is limited to categories only. I have googled a lot for this, but got no solution.

Answer 1

> if plugin doesnt provide you desire output then you can get the post of sub category by manually ie from data base.
> First you need to parent category id then you can get its sub category from table wp_term_taxonomy
> after geting subcategory list. you can get the object_id from table Table: wp_term_relationships where term_taxonoy_id=sub category_id
> and From boject_id you can get the post from wp_posts table where object_id is the post id. eg


<?php global $wpdb;$prefix=$wpdb->prefix;

$subcateogyr_list=$wpdb->get_results("Select * from ".$prefix."term_taxonomy WHERE parent='main_category_id'");

foreach($subcateogyr_list as $subcat

    $object_id=$wpdb->get_results("select * from ".$prefix."term_relationships where term_taxonomy_id='$subcat['term_id']'");

        foreach($object_id as $object_post){

            $post_detail=$wpdb->get_row("select * from ".$prefix."posts where id='$object_post['object_id']");

            print_r($post_detial);//you will get the post detail

        }
}
?>