get post count outside of workpress loop WordPress

Jatin Soni answers:

try this

<?php

$postcount = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish'");

echo $postcount;

?>

---

---

John Cotton answers:

You're going to want to look at [[LINK href="http://codex.wordpress.org/Function_Reference/get_objects_in_term"]]get_objects_in_term[[/LINK]].


function my_tax_count( $name ) {
$ids = get_terms( $name, array( 'fields' => 'ids' ) );

$objects = get_objects_in_term( $ids, $name );

return count($objects);
}


It doesn't do precisely what you want, but if you pass it a list of the ids in the term, then you could do a count on the result.

You could, of course, write a little custom SQL that does precisely what you want. Certainly you'd get far better performance, but with the downside that you risk things breaking if a future WP update changes the way things are structured in the database.

Luis Abarca answers:

This can work


wp_list_categories('include=' . $your_cat_ID);


---

Francisco Javier Carazo Gil answers:

Well, if you want to do this only for a taxonomy:

<?php

$postcount = $wpdb->get_var(";

SELECT SELECT COUNT(*)
FROM $wpdb->posts p
INNER JOIN $wpdb->term_relationships tr
ON p.post_id = tr.object_id
INNER JOIN $wpdb->terms t
ON t.term_id = tr.term_id
WHERE p.post_status = 'publish'
"
echo $postcount;

?>

Arnav Joy answers:

i am not sure what i am giving is what you want , but try it

define it in functions.php
<?php
function returnCount($slug){
global $wpdb;
$row = $wpdb->get_row("SELECT tt.count FROM ".$wpdb->prefix."term_taxonomy tt LEFT JOIN ".$wpdb->prefix."terms t ON tt.term_id = t.term_id WHERE t.slug = '".$slug."'");
return $row->count;
}

?>

and in the template use it as:-

<?php
$slug = 'uncategorized';
$count = returnCount($slug);
echo $count;
?>

Rashad Aliyev answers:

$term = get_term_by( 'slug', get_query_var( 'term' ), get_query_var( 'taxonomy' ) );
echo 'Count :' .$term->count;