php – posts_search中的自定义查询

发布时间：2020-12-13 13:28:13 所属栏目：PHP教程来源：网络整理

导读：如何将此查询用作自定义搜索查询？ 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 Sc

如何将此查询用作自定义搜索查询？

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
  "; 
}

查询是正确的(我在phpMyAdmin中检查过)但在WordPress中我得到了消息,没有结果.

在function.php文件中：

add_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;
}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!