Several reasons 1. Filters and Actions By using the standard loop, you execute various filters and actions that plugins rely on. Additionally, you set up the_post correctly, allowing functions such as the_content etc to work correctly. Some filters can even insert “posts” into the loop 2. Memory Efficiency By fetching all the posts as an … Read more
How to reload a select box of posts dynamically?
Your function works in your page template but not in the sidebar because at the point that your template is processed, $post already contains the post that has been loaded for the page. I tried your code and, just like Michael said, all I needed to add was the global declaration of $post inside the … Read more
I think you forgot about the inherit post status. The default one in WP_Query is publish. You should also use = instead of LIKE, to avoid using LIKE ‘%%’ in the SQL query. So try to add this: ‘post_status’ => ‘inherit’ and ‘compare’ => ‘=’ into your query arguments, to match the empty _wp_attachment_image_alt string … Read more
Here’s one way to check if there was an DB error within get_posts(): global $EZSQL_ERROR; $before = isset( $EZSQL_ERROR ) ? count( $EZSQL_ERROR ) : 0; $posts = get_posts( $args ); $after = isset( $EZSQL_ERROR ) ? count( $EZSQL_ERROR ) : 0; if ( empty( $posts ) && $before < $after ) { // … … Read more
You should use posts_join and posts_where filters to modify JOIN and WHERE clauses. add_filter( ‘posts_join’ , ‘se333659_posts_join’, 20, 2 ); add_filter( ‘posts_where’ , ‘se333659_posts_where’, 20, 2 ); function se333659_posts_join( $join, $query ) { global $wpdb; if ( isset($query->query_vars[‘_rev_of_publ’]) && $query->query_vars[‘_rev_of_publ’] == ‘1’ ) { $join .= ” LEFT JOIN {$wpdb->posts} AS rev_p ON ({$wpdb->posts}.post_parent = … Read more
Yes, get_posts is the safest way to use multiple loops. It does not mess up with the original query. Another way would be to create new WP_Query objects: $my_query = new WP_Query($args); while ($my_query->have_posts()) : $my_query->the_post(); Note: Why you should not use query_posts()
For now post_type support is not currently available for count_user_posts(), so put the below code in theme’s functions.php file. function count_user_posts_by_type( $userid, $post_type=”post” ) { global $wpdb; $where = get_posts_by_author_sql( $post_type, true, $userid ); $count = $wpdb->get_var( “SELECT COUNT(*) FROM $wpdb->posts $where” ); return apply_filters( ‘get_usernumposts’, $count, $userid ); } Now this function would take … Read more
There are two parts to the solution here. You need to use a JSON API custom controller In your custom controller, you’ll need to decide how to pass the meta_query data structure Depending on how robust you need this to be, you could use a variety of approaches. Here is the maximalist approach, that will … Read more
The get_posts() function creates an instance of WP_Query inside the function and simply returns the array of results. This WP_Query instance doesn’t override the global $wp_query and is out of scope by the time you need it. In short, I don’t see a way how you can get the requested SQL via get_posts(). An alternative … Read more