主页 / 问题 / 1180656
Accepted
4efirrr
Asked:2020-09-21 20:05:51 +0000 UTC2020-09-21 20:05:51 +0000 UTC

WordPress 按内容和作者姓名/昵称搜索

  • 772

有一个通过 Ajax 工作的搜索，我试图让它同时按内容和作者姓名进行搜索。

六功能

function custom_search_khp() {
    $post_type = $_POST['pt'];
    if ( $post_type == 'reviews' ) {
        $ar_query = new WP_Query( array(
            'post_type' => 'reviews',
            's'         => $_POST['term'],
            //'name'                   => $_POST['term'],
            //'author'            => $_POST['term'],
        ) );

        /*echo '<pre>';
        var_dump($ar_query);
        echo '</pre>';*/
        if ( $ar_query->have_posts() ) :
            while ( $ar_query->have_posts() ) :
                $ar_query->the_post();
                get_template_part( 'template-parts/content', 'khp-reviews' );
            endwhile;
        else:
            echo '<h3>'. __('The search has not given any results', 'gmr') . '</h3>';
        endif;
    }
    die;
}
add_action( 'wp_ajax_nopriv_search_reviews', 'custom_search_khp' );
add_action( 'wp_ajax_search_reviews', 'custom_search_khp' );

据我了解，'s' 和任何其他参数的联合使用不会产生预期的结果。尝试添加 name、author、author_name、author__in.. 还尝试将 first_name 和 last_name 作为 meta_query

搜索可以按作者姓名或按内容进行，但两者都是必需的。

php

1 个回答

  1. Best Answer

    你能这样做吗

    function custom_search_khp() {
    $post_type = $_POST['pt'];
    if ( $post_type == 'reviews' ) {
        
        add_filter('posts_where', 'custom_posts_where' );
        
        $ar_query = new WP_Query( array(
            'post_type' => 'reviews',
            's'         => $_POST['term'],
            //'name'                   => $_POST['term'],
            //'author'            => $_POST['term'],
        ) );
        
        

        /*echo '<pre>';
        var_dump($ar_query);
        echo '</pre>';*/
        if ( $ar_query->have_posts() ) :
            while ( $ar_query->have_posts() ) :
                $ar_query->the_post();
                get_template_part( 'template-parts/content', 'khp-reviews' );
            endwhile;
        else:
            echo '<h3>'. __('The search has not given any results', 'gmr') . '</h3>';
        endif;
        
        remove_filter('posts_where', 'custom_posts_where' );
    }
    die;
}
add_action( 'wp_ajax_nopriv_search_reviews', 'custom_search_khp' );
add_action( 'wp_ajax_search_reviews', 'custom_search_khp' );


function custom_posts_where( $where = '' ){
 
        global $wpdb;

        $search = ( isset($_POST['term']) ) ? sanitize_text_field($_POST['term']) : false ;
        $search = (string)$search;

        $users = $wpdb->get_results( "SELECT user_id FROM $wpdb->usermeta WHERE meta_key = 'first_name' AND meta_value = '$search'",OBJECT_K  );

        foreach ($users as $user)
        {
            $users_ids.=$user->user_id.','; 
        }
        $users_ids = rtrim($users_ids, ',');

        $where .= " AND ( ($wpdb->posts.post_author IN ({$users_ids})) 
               OR ($wpdb->posts.post_title LIKE '$search')
               OR ($wpdb->posts.post_content LIKE '$search') )
            AND $wpdb->posts.post_type = 'post'
            AND $wpdb->posts.post_status = 'publish'";  

        return $where;
}
    • 1

相关问题