How to add total post count in wordpress

If you are looking for adding total number of posts in your
wordpress blog, you can use this code.

————— This can be added with a link —————
<?php
$numposts = $wpdb->get_var(”SELECT COUNT(*) FROM $wpdb->posts
WHERE post_status = ‘publish’”); if (0 < $numposts) $numposts = number_format($numposts);

$numcomms = $wpdb->get_var(”SELECT COUNT(*)
FROM $wpdb->comments
WHERE comment_approved = ‘1′”);
if (0 < $numcomms) $numcomms = number_format($numcomms);

$numcats = $wpdb->get_var(”SELECT COUNT(*)
FROM $wpdb->categories”);
if (0 < $numcats) $numcats = number_format($numcats); ?>
<p><?php printf(__(’There are currently %1$s <a href=”%2$s”
title=”Posts”>posts</a> and %3$s <a href=”%4$s”
title=”Comments”>comments</a>, contained within %5$s
<a href=”%6$s” title=”categories”>categories</a>.’),
$numposts, ‘edit.php’,  $numcomms, ‘edit-comments.php’,
$numcats, ‘categories.php’); ?></p>

————— This can be added without a link ————-

<?php
$numposts = $wpdb->get_var(”SELECT COUNT(*) FROM $wpdb->posts
WHERE post_status = ‘publish’”);
if (0 < $numposts) $numposts = number_format($numposts);

$numcomms = $wpdb->get_var(”SELECT COUNT(*)
FROM $wpdb->comments WHERE comment_approved = ‘1′”);
if (0 < $numcomms) $numcomms = number_format($numcomms);

$numcats = $wpdb->get_var(”SELECT COUNT(*)
FROM $wpdb->categories”);
if (0 < $numcats) $numcats = number_format($numcats); ?>

<p>
<?php printf(__(’There are currently %1$s Free Games to Play</a>.’),
$numposts, ‘edit.php’,  $numcomms, ‘edit-comments.php’,
$numcats, ‘categories.php’); ?></p>

————————————————————

Let me know if you like it.

Your IP Address is:
38.107.191.119

Feel free to register and post your comments. thanks

Clap

0