在pre\\u get\\u posts中修改搜索WP\\u查询的meta\\u查询参数的两个答案中的代码版本不再搜索post\\u标题。如果不修改SQL,就无法在WP\\U查询中直接添加搜索帖子标题或元数据的功能,很遗憾,正如此问题所阐述的:Using meta query ('meta_query') with a search query ('s')
我在这里结合了一些技术,得到了一个可以避免preg\\u替换和太多SQL修改的工作版本(我希望可以完全避免)。唯一的缺点是,在搜索之后,页面顶部的字幕文本会显示“搜索结果”。我刚刚用CSS为插件的自定义帖子类型隐藏了它。
/**
* Extend custom post type search to also search meta fields
* @param WP_Query $query
*/
function extend_cpt_admin_search( $query ) {
// Make sure we\'re in the admin area and that this is our custom post type
if ( !is_admin() || $query->query[\'post_type\'] != \'your_custom_post_type\' ){
return;
}
// Put all the meta fields you want to search for here
$custom_fields = array(
"your_custom_meta_field",
"your_custom_meta_field2",
"your_custom_meta_field3"
);
// The string submitted via the search form
$searchterm = $query->query_vars[\'s\'];
// Set to empty, otherwise no results will be returned.
// The one downside is that the displayed search text is empty at the top of the page.
$query->query_vars[\'s\'] = \'\';
if ($searchterm != ""){
// Add additional meta_query parameter to the WP_Query object.
// Reference: https://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters
$meta_query = array();
foreach($custom_fields as $cf) {
array_push($meta_query, array(
\'key\' => $cf,
\'value\' => $searchterm,
\'compare\' => \'LIKE\'
));
}
// Use an \'OR\' comparison for each additional custom meta field.
if (count($meta_query) > 1){
$meta_query[\'relation\'] = \'OR\';
}
// Set the meta_query parameter
$query->set(\'meta_query\', $meta_query);
// To allow the search to also return "OR" results on the post_title
$query->set(\'_meta_or_title\', $searchterm);
}
}
add_action(\'pre_get_posts\', \'extend_cpt_admin_search\');
/**
* WP_Query parameter _meta_or_title to allow searching post_title when also
* checking searching custom meta values
* https://wordpress.stackexchange.com/questions/78649/using-meta-query-meta-query-with-a-search-query-s
* https://wordpress.stackexchange.com/a/178492
* This looks a little scary, but basically it\'s modifying the WHERE clause in the
* SQL to say "[like the post_title] OR [the existing WHERE clause]"
* @param WP_Query $q
*/
function meta_or_title_search( $q ){
if( $title = $q->get( \'_meta_or_title\' ) ){
add_filter( \'get_meta_sql\', function( $sql ) use ( $title ){
global $wpdb;
// Only run once:
static $nr = 0;
if( 0 != $nr++ ) return $sql;
// Modified WHERE
$sql[\'where\'] = sprintf(
" AND ( (%s) OR (%s) ) ",
$wpdb->prepare( "{$wpdb->posts}.post_title LIKE \'%%%s%%\'", $title),
mb_substr( $sql[\'where\'], 5, mb_strlen( $sql[\'where\'] ) )
);
return $sql;
});
}
}
add_action(\'pre_get_posts\', \'meta_or_title_search\');