The difference between get_posts & WP_Query You can view get_posts() as a slimmed down WP_Query. In fact looking at the source: //… prepares query array $r $get_posts = new WP_Query; return $get_posts->query($r); get_posts() use WP_Query, but only returns an array of posts – nothing more. Furthermore it sets: $r[‘no_found_rows’] = true; Normally (by default with … Read more
If all of your custom post type posts have all meta fields that you need then you can use the fields argument and set it to ids which will work much faster for example: //get your custom posts ids as an array $posts = get_posts(array( ‘post_type’ => ‘your_post_type’, ‘post_status’ => ‘publish’, ‘posts_per_page’ => -1, ‘fields’ … Read more
The WP_Query object accepts a post meta argument. Generally speaking you want to do the following: $my_query = new WP_Query( array( ‘post_type’ => ‘post’, ‘meta_query’ => array( array( ‘key’ => ‘project_cat’, ‘value’ => ‘my-value’, ) ), // Other query properties ) ); Where ‘my-value’ is your ‘specified value’. Example usage: add_action( ‘pre_get_posts’ , ‘my_pre_get_posts’ ); … Read more
You can try a trick with querying post data directly and setting filter field of post objects to sample before passing it to get_permalink() to reduce memory usage. See get_permalink memory usage issue for detailed reasoning behind it.
It’s not possible with WP_Query directly out of the box, but by using the posts_where filter to look for a custom argument on WP_Query, it is possible to add this functionality. Assuming starts_with is the name of the argument we want to use, we can filter posts_where to add a WHERE clause limiting results to … Read more
To query posts by custom fields you can use the ‘meta_query’ parameter <?php $args = array( ‘post_type’ => ‘payment’, ‘meta_query’ => array( array( ‘key’ => ‘bookingref’, ‘value’ => ‘the_value_you_want’, ‘compare’ => ‘LIKE’ ), array( ‘key’ => ‘customerref’, ‘value’ => ‘the_value_you_want’, ‘compare’ => ‘LIKE’ ) ); query_posts($args); while (have_posts()) : the_post(); ?> you can’t use get_post_meta … Read more
The question has already been asked and the answer has been posted too, How to display related posts from same category? Add this code inside your single.php after a loop wherever you want to show related post, <?php $related = get_posts( array( ‘category__in’ => wp_get_post_categories($post->ID), ‘numberposts’ => 5, ‘post__not_in’ => array($post->ID) ) ); if( $related … Read more
In addition to birgire’s solution, as of WordPress 3.7, you can use Date parameters. Your arguments would look like this to filter posts from the last 7 days: $args = array( ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘orderby’ => ‘date’, ‘order’ => ‘DESC’, // Using the date_query to filter posts from last week ‘date_query’ => … Read more
This code is incorrect! You have ‘taxonomy’ => ‘post-format’ But it really needs to be: ‘taxonomy’ => ‘post_format’ Without the underscore, the query will be invalid. I just tested this on my WordPress 3.1 install after pulling my hair out for hours. Hope that helps!!
If you can explain it in SQL, you can query for it! There are three places where we want to change the default query: SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) WHERE 1=1 AND wp_posts.post_type=”post” AND (wp_posts.post_status=”publish”) AND wp_postmeta.meta_key = ‘startDate’ AND CAST(wp_postmeta.meta_value AS CHAR) < ‘2011-03-23’ GROUP BY wp_posts.ID ORDER … Read more