WP_Query의 필터로이 문제를 해결할 것입니다.추가 쿼리 변수를 감지하고이를 제목의 접두사로 사용하는 변수입니다.

 add_filter( 'posts_where', 'wpse18703_posts_where', 10, 2 );
function wpse18703_posts_where( $where, &$wp_query )
{
    global $wpdb;
    if ( $wpse18703_title = $wp_query->get( 'wpse18703_title' ) ) {
        $where .= ' AND ' . $wpdb->posts . '.post_title LIKE \'' . esc_sql( $wpdb->esc_like( $wpse18703_title ) ) . '%\'';
    }
    return $where;
}
 

이렇게하면 WP_Query를 계속 호출 할 수 있습니다. 제목을 wpse18703_title 인수로 전달하거나 이름을 더 짧은 이름으로 변경하면됩니다.

I would solve this with a filter on WP_Query. One that detects an extra query variable and uses that as the prefix of the title.

add_filter( 'posts_where', 'wpse18703_posts_where', 10, 2 );
function wpse18703_posts_where( $where, &$wp_query )
{
    global $wpdb;
    if ( $wpse18703_title = $wp_query->get( 'wpse18703_title' ) ) {
        $where .= ' AND ' . $wpdb->posts . '.post_title LIKE \'' . esc_sql( $wpdb->esc_like( $wpse18703_title ) ) . '%\'';
    }
    return $where;
}

This way you can still call WP_Query, you just pass the title as the wpse18703_title argument (or change the name to something shorter).

간체 :

 function title_filter( $where, &$wp_query )
{
    global $wpdb;
    // 2. pull the custom query in here:
    if ( $search_term = $wp_query->get( 'search_prod_title' ) ) {
        $where .= ' AND ' . $wpdb->posts . '.post_title LIKE \'%' . esc_sql( like_escape( $search_term ) ) . '%\'';
    }
    return $where;
}

$args = array(
    'post_type' => 'product',
    'posts_per_page' => $page_size,
    'paged' => $page,
    // 1. define a custom query var here to pass your term through:
    'search_prod_title' => $search_term,
    'post_status' => 'publish',
    'orderby'     => 'title', 
    'order'       => 'ASC'
);

add_filter( 'posts_where', 'title_filter', 10, 2 );
$wp_query = new WP_Query($args);
remove_filter( 'posts_where', 'title_filter', 10 );
return $wp_query;
 

Simplified:

function title_filter( $where, &$wp_query )
{
    global $wpdb;
    // 2. pull the custom query in here:
    if ( $search_term = $wp_query->get( 'search_prod_title' ) ) {
        $where .= ' AND ' . $wpdb->posts . '.post_title LIKE \'%' . esc_sql( like_escape( $search_term ) ) . '%\'';
    }
    return $where;
}

$args = array(
    'post_type' => 'product',
    'posts_per_page' => $page_size,
    'paged' => $page,
    // 1. define a custom query var here to pass your term through:
    'search_prod_title' => $search_term,
    'post_status' => 'publish',
    'orderby'     => 'title', 
    'order'       => 'ASC'
);

add_filter( 'posts_where', 'title_filter', 10, 2 );
$wp_query = new WP_Query($args);
remove_filter( 'posts_where', 'title_filter', 10 );
return $wp_query;

esc_sql ()은 4.0 이상에서 더 이상 사용되지 않으므로 워드 프레스 4.0 이상에서 작업 한이 코드를 업데이트하고 싶습니다.

 function title_filter($where, &$wp_query){
    global $wpdb;

    if($search_term = $wp_query->get( 'search_prod_title' )){
        /*using the esc_like() in here instead of other esc_sql()*/
        $search_term = $wpdb->esc_like($search_term);
        $search_term = ' \'%' . $search_term . '%\'';
        $where .= ' AND ' . $wpdb->posts . '.post_title LIKE '.$search_term;
    }

    return $where;
}
 

나머지는 동일합니다.

또한 WP_Query 인수 내에서 s 변수를 사용하여 검색어를 전달할 수 있음을 지적하고 싶습니다. 그러면 내가 믿는 게시물 제목도 검색됩니다.

예 :

 $args = array(
    'post_type' => 'post',
    's' => $search_term,
    'post_status' => 'publish',
    'orderby'     => 'title', 
    'order'       => 'ASC'        
);
$wp_query = new WP_Query($args);
 

Wanted to update this code you guys worked on for the wordpress 4.0 and above as esc_sql() is deprecated in 4.0 higher.

function title_filter($where, &$wp_query){
    global $wpdb;

    if($search_term = $wp_query->get( 'search_prod_title' )){
        /*using the esc_like() in here instead of other esc_sql()*/
        $search_term = $wpdb->esc_like($search_term);
        $search_term = ' \'%' . $search_term . '%\'';
        $where .= ' AND ' . $wpdb->posts . '.post_title LIKE '.$search_term;
    }

    return $where;
}

Rest of the stuff is same.

Also I want to point out you can use s variable within WP_Query arguments to pass search terms, which will also search for post title i believe.

Like this:

$args = array(
    'post_type' => 'post',
    's' => $search_term,
    'post_status' => 'publish',
    'orderby'     => 'title', 
    'order'       => 'ASC'        
);
$wp_query = new WP_Query($args);

여기에 게시 된 취약한 솔루션과 함께 약간 단순화되고 삭제 된 버전이 제공됩니다.

먼저,특정 조건과 일치하는 게시물 만 표시 할 수있는 posts_where 필터에 대한 함수를 만듭니다.

 function cc_post_title_filter($where, &$wp_query) {
    global $wpdb;
    if ( $search_term = $wp_query->get( 'cc_search_post_title' ) ) {
        $where .= ' AND ' . $wpdb->posts . '.post_title LIKE \'%' . $wpdb->esc_like( $search_term ) . '%\'';
    }
    return $where;
}
 

이제 cc_search_post_title을 쿼리 인수에 추가합니다.

 $args = array(
    'cc_search_post_title' => $search_term, // search post title only
    'post_status' => 'publish',
);
 

마지막으로 쿼리를 필터로 둘러 쌉니다.

 add_filter( 'posts_where', 'cc_post_title_filter', 10, 2 );
$query = new WP_Query($args);
remove_filter( 'posts_where', 'cc_post_title_filter', 10 );
 

get_posts () 사용

게시물을 검색하는 특정 함수는 필터를 실행하지 않으므로 첨부 한posts_where 필터 함수는 쿼리를 수정하지 않습니다. get_posts()를 사용하여 게시물을 쿼리하려는 경우 인수 배열에서 suppress_filters를false로 설정해야합니다.

 $args = array(
    'cc_search_post_title' => $search_term,
    'suppress_filters' => FALSE,
    'post_status' => 'publish',
);
 

이제 get_posts()를 사용할 수 있습니다.

 add_filter( 'posts_where', 'cc_post_title_filter', 10, 2 );
$posts = get_posts($args);
remove_filter( 'posts_where', 'cc_post_title_filter', 10 );
 

s 매개 변수는 어떻습니까?

s 매개 변수를 사용할 수 있습니다.

 $args = array(
    's' => $search_term,
);
 

검색어를 s 매개 변수에 추가하면 작동하고 게시물 제목을 검색하지만 게시물 콘텐츠도 검색합니다 .

WP 4.4에 추가 된 title 매개 변수는 어떻습니까?

title 매개 변수에 검색어 전달 :

 $args = array(
    'title' => $search_term,
);
 

대소 문자를 구분하며 LIKE가 아니라 %LIKE%입니다. 즉,hello를 검색하면 제목이 Hello World 또는 Hello 인 게시물이 반환되지 않습니다.

With some vulnerable solution posted here, I come with a bit simplified and sanitized version.

First, we create a function for the posts_where filter which allows you to only show posts matching specific conditions:

function cc_post_title_filter($where, &$wp_query) {
    global $wpdb;
    if ( $search_term = $wp_query->get( 'cc_search_post_title' ) ) {
        $where .= ' AND ' . $wpdb->posts . '.post_title LIKE \'%' . $wpdb->esc_like( $search_term ) . '%\'';
    }
    return $where;
}

Now we add cc_search_post_title into our query arguments:

$args = array(
    'cc_search_post_title' => $search_term, // search post title only
    'post_status' => 'publish',
);

And finally wrap the filter around the query:

add_filter( 'posts_where', 'cc_post_title_filter', 10, 2 );
$query = new WP_Query($args);
remove_filter( 'posts_where', 'cc_post_title_filter', 10 );

Using get_posts()

Certain functions which retrieve posts do not run filters, so the posts_where filter functions you attach will not modify the query. If you plan to use get_posts() to query your posts, you need to set suppress_filters to false in your argument array:

$args = array(
    'cc_search_post_title' => $search_term,
    'suppress_filters' => FALSE,
    'post_status' => 'publish',
);

Now you can use get_posts():

add_filter( 'posts_where', 'cc_post_title_filter', 10, 2 );
$posts = get_posts($args);
remove_filter( 'posts_where', 'cc_post_title_filter', 10 );

What about the s parameter?

The s parameter is available:

$args = array(
    's' => $search_term,
);

While adding your search term into the s parameter work and it will search the post title, it will also search the post content.

What about the title parameter which was added with WP 4.4?

Passing a search term into the title parameter:

$args = array(
    'title' => $search_term,
);

Is case sensitive and LIKE, not %LIKE%. This mean search for hello will not return post with title Hello World or Hello.

다른 답변을 바탕으로 메타 필드 또는 게시물 제목에 단어가 포함 된 게시물을 검색하려는 상황에서 유연성을 제공하기 위해 "title_filter_relation"인수를 통해 해당 옵션을 제공합니다. 이 구현에서는 기본값이 "AND"인 "OR"또는 "AND"입력 만 허용합니다.

 function title_filter($where, &$wp_query){
    global $wpdb;
    if($search_term = $wp_query->get( 'title_filter' )){
        $search_term = $wpdb->esc_like($search_term); //instead of esc_sql()
        $search_term = ' \'%' . $search_term . '%\'';
        $title_filter_relation = (strtoupper($wp_query->get( 'title_filter_relation'))=='OR' ? 'OR' : 'AND');
        $where .= ' '.$title_filter_relation.' ' . $wpdb->posts . '.post_title LIKE '.$search_term;
    }
    return $where;
}
 

다음은 질문이 게시물 제목 자체 인 매우 간단한 게시물 유형 "faq"에 대한 작동 코드의 예입니다.

 add_filter('posts_where','title_filter',10,2);
$s1 = new WP_Query( array(
    'post_type' => 'faq',
    'posts_per_page' => -1,
    'title_filter' => $q,
    'title_filter_relation' => 'OR',
    'post_status' => 'publish',
    'orderby'     => 'title', 
    'order'       => 'ASC',
    'meta_query' => array(
        'relation' => 'OR',
        array(
            'key' => 'faq_answer',
            'value' => $q,
            'compare' => 'LIKE'
        )
    )
));
remove_filter('posts_where','title_filter',10,2);
 

Building on other answers before me, to provide flexibility in the situation where you want to search a post that contains a word in a meta field OR in the title of the post, I give that option via the argument "title_filter_relation." In this implementation, I only allow for "OR" or "AND" inputs with a default of "AND."

function title_filter($where, &$wp_query){
    global $wpdb;
    if($search_term = $wp_query->get( 'title_filter' )){
        $search_term = $wpdb->esc_like($search_term); //instead of esc_sql()
        $search_term = ' \'%' . $search_term . '%\'';
        $title_filter_relation = (strtoupper($wp_query->get( 'title_filter_relation'))=='OR' ? 'OR' : 'AND');
        $where .= ' '.$title_filter_relation.' ' . $wpdb->posts . '.post_title LIKE '.$search_term;
    }
    return $where;
}

Here's an example of the code in action for a very simple post type "faq" where the question is the post title itself:

add_filter('posts_where','title_filter',10,2);
$s1 = new WP_Query( array(
    'post_type' => 'faq',
    'posts_per_page' => -1,
    'title_filter' => $q,
    'title_filter_relation' => 'OR',
    'post_status' => 'publish',
    'orderby'     => 'title', 
    'order'       => 'ASC',
    'meta_query' => array(
        'relation' => 'OR',
        array(
            'key' => 'faq_answer',
            'value' => $q,
            'compare' => 'LIKE'
        )
    )
));
remove_filter('posts_where','title_filter',10,2);