Created
September 18, 2015 14:19
-
-
Save marushu/f04e402d09a6e17b6e91 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<? | |
/** | |
* add custom fields to search query :) | |
*/ | |
/** | |
* Extend WordPress search to include custom fields | |
* | |
* http://adambalee.com | |
*/ | |
/** | |
* Join posts and postmeta tables | |
* | |
* http://codex.wordpress.org/Plugin_API/Filter_Reference/posts_join | |
*/ | |
function cf_search_join( $join ) { | |
global $wpdb; | |
if ( is_search() ) { | |
$join .=' LEFT JOIN '.$wpdb->postmeta. ' ON '. $wpdb->posts . '.ID = ' . $wpdb->postmeta . '.post_id '; | |
} | |
return $join; | |
} | |
add_filter('posts_join', 'cf_search_join' ); | |
/** | |
* Modify the search query with posts_where | |
* | |
* http://codex.wordpress.org/Plugin_API/Filter_Reference/posts_where | |
*/ | |
function cf_search_where( $where ) { | |
global $pagenow, $wpdb; | |
if ( is_search() ) { | |
$where = preg_replace( | |
"/\(\s*".$wpdb->posts.".post_title\s+LIKE\s*(\'[^\']+\')\s*\)/", | |
"(".$wpdb->posts.".post_title LIKE $1) OR (".$wpdb->postmeta.".meta_value LIKE $1)", $where ); | |
} | |
return $where; | |
} | |
add_filter( 'posts_where', 'cf_search_where' ); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment