For a left-sided match you can get around the automatic adding of ‘%’‘s by WP by using regular expression RLIKE: ‘meta_value’ => ‘^’ . preg_quote( $today ), ‘meta_compare’ => ‘RLIKE’ Similarly for right-sided match: ‘meta_value’ => preg_quote( $today ) . ‘$’, ‘meta_compare’ => ‘RLIKE’
Your function returns $product->get_id();, instead of that, you should save those values into an array and at the end return that array. function ids(){ $args = array( ‘numberposts’ => -1, ‘post_type’ => ‘product’, ‘meta_key’ => ‘wppl_is_dax’, ‘meta_value’ => ‘1’ ); // query $the_query = new WP_Query( $args ); $allIds = array(); if( $the_query->have_posts() ): while( … Read more
Just figured it out. This isn’t clearly or explicitly documented at https://developer.wordpress.org/cli/commands/post/list/ or elsewhere. wp post list –fields=ID,post_title,Amazon.com,Amazon.co.uk –meta_key=Amazon.com –meta_key=Amazon.co.uk
It should be: $newsposts = new WP_Query(‘cat=restaurant&posts_per_page=7’); Another way to write it (helps readability with larger queries) would be: $newsposts = new WP_Query(array( ‘cat’ => ‘restaurant’, ‘posts_per_page’ => 7, )); See WP_Query in Codex for description of available parameters. PS would be good practice to add wp_reset_postdata() at the end. You are (correctly) not modifying … Read more
You need to define your arguments before you pass them to WP_Query, not after. Also, your meta_query should be an array of an array, not just an array This $query = new WP_Query($thumbs); $thumbs = array( ‘meta_query’ => array(‘key’ => ‘_thumbnail_id’) ); should look like this $thumbs = array( ‘meta_query’ => array( array( ‘key’ => … Read more
There is an action specifically for this: function my_parse_query( $wp_query ) { if ( $wp_query->get( ‘my_custom_var’ ) > 42 ) { $wp_query->set_404(); status_header( 404 ); } } add_action( ‘parse_query’, ‘my_parse_query’ ); That should load the 404.php template in your theme, if you have it. Otherwise, it will fall back to index.php. This will also trigger … Read more
Right after the pre_get_posts hook is fired, the public meta_query attribute of WP_Query is overridden with: $this->meta_query = new WP_Meta_Query(); $this->meta_query->parse_query_vars( $q ); where $q = &$this->query_vars; $q = $this->fill_query_vars($q); So I don’t think it will work to modify this attribute, like you’re trying to do, before the pre_get_posts hook is activated. Instead we need … Read more
Basically what you are looking for is the global $wp_the_query variable which is set to the value of the main query. It may not be a perfect fit for 100% of cases but will probably work fine in 99% of cases: add_action( ‘pre_get_posts’, ‘custom_post_count’ ); function custom_post_count( $query ){ global $wp_the_query; if ( $wp_the_query === … Read more
category is a valid parameter for get_posts, not for WP_Query. Here are the valid category parameters for WP_Query cat (int) – use category id. category_name (string)– use category slug (NOT name). category__and (array) – use category id. category__in (array) – use category id. category__not_in (array) – use category id. You can use either use cat … Read more
Your code will run five SQL queries in total. When setting no_found_rows => true the first two queries SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (1,49,63,249,72,95,259,207,183,225) AND wp_posts.post_type=”post” AND (wp_posts.post_status=”publish”) ORDER BY wp_posts.post_date ASC LIMIT 0, 10 SELECT FOUND_ROWS() will become a single query like SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND … Read more