如何将此查询用作自定义搜索查询？
add_filter('posts_search','my_search_is_perfect',20,2);
function my_search_is_perfect($search,$wp_query)
{
$sWord = 'Zukunft haus';
return "
SELECT *,MATCH(post_title) AGAINST('$sWord' IN BOOLEAN MODE) AS score
FROM `wp_posts`
INNER JOIN wp_term_relationships ON wp_term_relationships.object_id = ID
AND wp_term_relationships.term_taxonomy_id = 1
WHERE MATCH( post_title) AGAINST ('$sWord' IN BOOLEAN MODE)
AND `post_status` = 'publish'
AND `post_type` = 'post'
ORDER BY score DESC
";
}
在function.PHP文件中：
原文链接：https://www.f2er.com/php/137500.htmladd_filter('posts_search',2);
function my_search_is_perfect()
{
global $post;
global $wpdb;
$sWord = 'Zukunft haus';
$sel_query = "SELECT *,MATCH(post_title) AGAINST('$sWord' IN BOOLEAN MODE) AS score
FROM ".$wpdb->prefix."posts
INNER JOIN ".$wpdb->prefix."term_relationships ON ".$wpdb->prefix."term_relationships.object_id = ID
AND ".$wpdb->prefix."term_relationships.term_taxonomy_id = 1
WHERE MATCH( post_title) AGAINST ('$sWord' IN BOOLEAN MODE)
AND post_status = 'publish'
AND post_type = 'post'
ORDER BY score DESC";
$totaldata = $wpdb->get_results($sel_query);
return $totaldata;
}
