This is directly related to, and a consequence of WordPress.com VIP At VIP, we deal with sites that range in the hundreds of millions of page views per week. As a result, situations that can slow down your site are much more noticeable at that scale than on a small shared host, but this still … Read more
Normally you would just specify a meta_value, e.g.: $args = array( ‘post_type’ => ‘business’, ‘meta_query’ => array( array( ‘key’ => ‘specials’, ‘value’ => ‘these are not the specials you are looking for – Obi Wan Kenobi’ ) ) ); However because your post meta is actually a data structure, a serialised PHP array/object, that’s not … Read more
You can use ‘posts_orderby’ filter to change the SQL performed. Note that: using get_posts() you need to set ‘suppress_filters’ argument of false for the filter to be performed if you don’t explicitly set ‘post_status’ you’ll get only published posts (so no much to order) Code sample: $filter = function() { return ‘post_status ASC’; }; add_filter(‘posts_orderby’, … Read more
Yes. To give you some historical perspective WordPress core: is relatively old code base, code volume tends to grow over time; has extreme commitment to backwards compatibility, as result it’s extremely rare for code to be removed from core; is written in essentially obsolete dialect of PHP version 5.2 (which it remains compatible with), which … Read more
meta_query and orderby are seperate parameters, you just put them together in an array. You will have to do one then the other. e.g. <?php $args = array( ‘post_type’ => ‘property’, ‘meta_query’ => array( array( ‘relation’ => ‘AND’, ‘city_clause’ => array( ‘key’ => ‘city’, ‘compare’ => ‘EXISTS’, ), ‘street_clause’ => array( ‘key’ => ‘street_name’, ‘compare’ … Read more
Case #1: Simple Offset You want to ‘offset’ posts of a category archive by ‘n’, i.e. you simply don’t want to show the first/latest ‘n’ posts in an archive. That is, (considering the posts_per_page setting in WP Dashboard > Settings > Reading is set to 10) you want posts 11 to 20 to be shown … Read more
Revisited and simplified answer: You can try: $args = [ ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘category_name’ => ‘projects’, ‘_name__like’ => ‘proj*’ // <– our new input argument! ]; $my_query = new WP_Query( $args ); where we’ve created the _name__like input argument. It supports wildcard *, for example: ‘_name__like’ => ‘a*b*’ Note that draft posts … Read more
If you need to: page the query retain 12 posts per page instead of “sticking” the desired posts on top of the required 12 only need to show those posts on the first page you can try the following $ids_args = [ ‘post_type’ => ‘products’ ‘posts_per_page’ => -1, ‘orderby’ => ‘meta_value_num’, ‘meta_key’ => ‘_price’, ‘order’ … Read more
Basic programming techniques you should have learned before building a plugin: You can concatenate checks with && (and) and || (or). You can (and should) guard each CREATE query with its own check SQL syntax you should have looked into before writing queries on your own: IF NOT EXISTS On a related note, please make … Read more
Use the fields argument to grab just the ID – will save you a ton of memory 😉 $product_ids = get_posts( array( ‘posts_per_page’ => -1, ‘post_type’ => array( ‘product’, ‘product_variation’ ), ‘fields’ => ‘ids’, ) );