扩展站点搜索以包括单个定制字段

我的函数中有以下代码。php文件

function __adapted_search_function($search, $query) {
  if(is_admin() || !$query->is_main_query() || !$query->is_search)
    return; //determine if we are modifying the right query

  global $wpdb;
  $search_term = $query->get(\'s\');
  $search = \' AND (\';

  //point 1
  $search .= "($wpdb->posts.post_title LIKE \'%$search_term%\')";

  //need to add an OR between search conditions
  $search .= " OR ";

  //point 2
  $search .= "($wpdb->posts.post_excerpt LIKE \'%$search_term%\')";

  //need to add an OR between search conditions
  $search .= " OR ";

  //point 3
  $search .= "($wpdb->postmeta.meta_key = \'mcb-product\' AND $wpdb->postmeta.meta_value LIKE \'%$search_term%\')";

  //add the filter to join, sql will error out without joining the tables to the query
  add_filter(\'posts_join\', \'__custom_join_tables\');   


  return $search . \') \';
}

function __custom_join_tables($joins) {
  global $wpdb;
  $joins = "JOIN $wpdb->postmeta ON ($wpdb->postmeta.post_ID = $wpdb->posts.ID)";
  return $joins;
}

我希望它只搜索帖子标题、摘录和单个自定义字段。

如果我删除了连接，但确实需要将其包括在内，那么它会起作用，有人能看到我哪里出错了吗？

function extend_search( $search, &$wp_query ) { global $wpdb; if ( empty( $search )) return $search; $terms = $wp_query->query_vars[ \'s\' ]; $exploded = explode( \' \', $terms ); if( $exploded === FALSE || count( $exploded ) == 0 ) $exploded = array( 0 => $terms ); $search = \'\'; foreach( $exploded as $tag ) { $search .= " AND ( ($wpdb->posts.post_title LIKE \'%$tag%\') OR ($wpdb->posts.post_excerpt LIKE \'%$tag%\') OR EXISTS ( SELECT * FROM $wpdb->postmeta WHERE post_ID = pl_posts.ID AND meta_key = \'--KEY--\' AND meta_value LIKE \'%$tag%\' ) )"; } return $search; }

search page different results

我有自定义的帖子类型，并希望根据用户的搜索元数据显示不同的结果。我有三种不同风格的自定义帖子类型，希望根据各自的风格返回搜索结果，而不是当前显示的通用页面链接和摘录。我可以使用is\\u search（）吗？<?php if ( is_search() ) : // Only display Excerpts for Search ?> <div class=\"entry-summary\"> <?php the_excerpt(); ?>&#

相关推荐

search page different results