count - Read For Learn

Count posts or custom post types from last 24 hours (or from today)

You can write your own function (add it to functions.php file: function get_posts_count_from_last_24h($post_type=”post”) { global $wpdb; $numposts = $wpdb->get_var( $wpdb->prepare( “SELECT COUNT(ID) “. “FROM {$wpdb->posts} “. “WHERE “. “post_status=”publish” “. “AND post_type= %s “. “AND post_date> %s”, $post_type, date(‘Y-m-d H:i:s’, strtotime(‘-24 hours’)) ) ); return $numposts; } function get_posts_count_from_today($post_type=”post”) { global $wpdb; $numposts = $wpdb->get_var( … Read more

count posts from custom taxonomy terms by year

EDIT 2 Here is another version of the code in EDIT 1. This code is about much more faster. Here is my test between the code in EDIT 1 and EDIT 2 EDIT 1 Database query time = +/- 0.25 and Database queries = 69 EDIT 2 Database query time = +/- 0.07 and Database … Read more

show number of open comments on custom dashboard

Actually, it is not that hard. The last access time for a user is in get_user_meta( get_current_user_id(), ‘last_access’, TRUE ). The date of each comment is in the column comment_date. Both share the same format, so we can compare them in SQL with a simple >. There is an action in the Right Now dashboard … Read more

How to cache a shortcode functions output?

You might have a look at the WordPress Transient API. You should be able to store your shortcode output $total_network with set_transient( ‘my_shortcode_cache’, $total_network, WEEK_IN_SECONDS ); where WEEK_IN_SECONDS is a built in constant equal to 604800. You can then fetch it with: get_transient( ‘my_shortcode_cache’ ); If you need it to work network wide there exists … Read more

Total word count for posts by one author

I use a plug-in called Post Word Count to sum the total number of published words across my entire site … then again, I’m the only author, so this is a pretty simple example. But you could start with this plug-in and add a filter that changes the query based on the author’s ID. Basically: … Read more

Count the number of images uploded on the website

There’s a handy built-in function, namely wp_count_attachments(). We can filter out images with wp_count_attachments( $mime_type=”image” ) that returns an object like: stdClass Object ( [image/gif] => 9 [image/jpeg] => 121 [image/png] => 20 [image/x-icon] => 6 [trash] => 0 ) So we can use the one-liner: $count = array_sum( (array) wp_count_attachments( $mime_type=”image” ) ); for … Read more

How to display 2 equal columns of li based on the count of items in wp_nav_menu divided by 2?

You’ll need to register your own custom walker, but it’s pretty simple as you only need to have one function(start_el) inside the custom walker. We’ll have to add the code from the thread you referenced to work out how many items there are, then work out what half is and end the current list when … Read more

WP 3.5 and Galleries – how to count images?

This works: $images = get_children( array( ‘post_parent’ => $post->ID, ‘post_type’ => ‘attachment’, ‘post_mime_type’ => ‘image’, ‘orderby’ => ‘menu_order’, ‘order’ => ‘ASC’, ‘numberposts’ => 999 )); if ( $images ) { $total_images = count( $images ); } The variable $total_images will hold the count of images in your gallery.

Taxonomy count per Post type

I needed to get the number of post per type per term so i created this small function: function get_term_post_count_by_type($term,$taxonomy,$type){ $args = array( ‘fields’ =>’ids’, //we don’t really need all post data so just id wil do fine. ‘posts_per_page’ => -1, //-1 to get all post ‘post_type’ => $type, ‘tax_query’ => array( array( ‘taxonomy’ => … Read more

Hide the post count behind Post Views (Remove All, Published and Trashed) in Custom Post Type

There is, unfortunately, no “pretty” way to do this (i.e. without using string replacing or rewriting a big chunck of functionality). So, resorting to preg_replace… We’ll need to filter the links, and it’s good to see that you’ve already found the proper filters! Looping through the views and using a regular expression, we can remove … Read more

+ More