Tutorial: How to output total blog posts count in custom template

Do you need to output total blog post count in your joomla template, anywhere "outside" EasyBlog environment ? Maybe you want to build your own statistics or display your data in a certain way or in a certain location across your site. This query will help you.

Use the code below

<?php

$db	= JFactory::getDbo();

$query = $db->getQuery(true);

$query	= 'SELECT COUNT(1) FROM #__easyblog_post';

$db->setQuery( $query );

$count = $db->loadResult();

echo $count;

?>

This will query the database and display the total posts count for EasyBlog.
To place the total posts count in a joomla template position, use one of the "custom code" modules (one that will run PHP) found in Joomla Extension Directory.

Enjoy !