You’re gonna need regular expressions to accomplish that. First of all, you need to change ‘LIKE’ to ‘RLIKE’ (or ‘REGEXP’). Second, replace $keyword in ‘value’ with a regex that involves word boundaries. Like so: $queryArgs = array( ‘post_type’ => ‘faculty’, ‘posts_per_page’ => -1, ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘proposed_keywords’, // name … Read more
You may be able to use a WP_Query on nav_menu_item since it is its own post type. I’ve never done this but maybe it would work like you need it to, worth a shot. There are three other possibilities: Option 1 – Get Your Nav Menu Items There’s a functions called wp_get_nav_menu_items() which will return … Read more
One problem with the query is that the self-join with the ambiguous WHERE gives you a crossed dataset (which is masked by the DISTINCT), so it would be simpler to use wp_post as a base to attach the joins that precisely match the keys, eg SELECT p.ID, key1.meta_value as prog_ongoing, key2.meta_value as prog_date_start FROM $wpdb->posts … Read more
Maybe a bit late … add_action( ‘pre_get_posts’, function($query) { if ( !is_admin() && $query->is_main_query() && is_post_type_archive( ‘[your_post_type]’ ) ) { $query->set(‘meta_query’, array( ‘_property_price’ => array( ‘key’ => ‘_property_price’, ), ‘_property_featured’ => array( ‘key’ => ‘_property_featured’, ) )); $query->set(‘orderby’,array( ‘_property_price’ => ‘DESC’, ‘_property_featured’ => ‘DESC’ )); } return $query; } );
As @Howdy_McGee suggested and I made a quick test. Removing key do the trick so you can just remove the key and add compare LIKE if you do not want exact match. Example:- $posts = new WP_Query(array( ‘meta_query’ => array( array( ‘value’ => ‘meta_value’ ) ) )); This will produce the SQL like WHERE 1=1 … Read more
I understand your confusion but you haven’t something to worry about as behinds the scenes WordPress make all the necessary steps to make it work. For example, take the following code from the class-wp-query.php // If querystring ‘cat’ is an array, implode it. if ( is_array( $q[‘cat’] ) ) { $q[‘cat’] = implode( ‘,’, $q[‘cat’] … Read more
You need to add a \ in front of the WP_Query call to tell PHP that it’s in the global namespace and not the namespace of this class. Try this: $query = new \WP_Query($args);
The WordPress function get_posts() is making it’s own instance of WP_Query that is not globally accessible: function get_posts($args = null) { // … cut … $get_posts = new WP_Query; return $get_posts->query($r); } so you could instead try $results = get_posts($args); echo count($results); to give you the array count of post objects returned by get_posts(). WP_Query() … Read more
Edited Jul, 07 2014 at 6:28 There are a lot of gotchas with your approach. It will not work if there are any custom rewrite rule, it (probably) will not work if server is IIS and pretty permalink are active, it will not work for custom post types, it will not work for archive or … Read more
Here is a concept that you can try out to exclude 5 posts per category each from category 3 and 5 where posts are excluded that belongs to category 9 and either of the before mentioned categories. Here is the function: (CAVEAT: Requires PHP 5.4+ as I used new short array syntax. Change as needed) … Read more