Reply 347580 to: Search Result Displaying Unrelated Products

Avatar: websitedude1985
WebsiteDude
Participant
February 21, 2023 at 03:11

This works a treat…. (put in Child Theme php)

/**
* Limit search to title
*/
function search_by_title_only($search, $wp_query)
{
global $wpdb;
if (empty($search)) {
return $search; // skip processing – no search term in query
}
$q = $wp_query->query_vars;
$n = !empty($q[‘exact’]) ? ” : ‘%’;
$search =
$searchand = ”;
foreach ((array) $q[‘search_terms’] as $term) {
$term = esc_sql($wpdb->esc_like($term));
$search .= “{$searchand}($wpdb->posts.post_title LIKE ‘{$n}{$term}{$n}’)”;
$searchand = ‘ AND ‘;
}
if (!empty($search)) {
$search = ” AND ({$search}) “;
if (!is_user_logged_in()) {
$search .= ” AND ($wpdb->posts.post_password = ”) “;
}
}
return $search;
}
add_filter(‘posts_search’, ‘search_by_title_only’, 20, 2);

Go To The Whole Conversation In Topic
We're using our own and third-party cookies to improve your experience and our website. Keep on browsing to accept our cookie policy.