K2 User show total number of Item hits

Question

I have a requirement where I want to show the total number of hits that a user's items have been read. For example, if they have ten K2 items, each have been read 10 times, then I want to show the total number (in this case 100) of hits that users total items have been read.

K2 has a variable, which I can echo for each of the items:

<?php echo $item->hits; ?>

But I need a way to add all of the authors items hits up.

** Update **

So I'm thinking, could this be done using a SQL query? Something similar to:

SELECT count('hits') FROM #__k2_items WHERE authorid='id';

Answer 1

This should be what you need.

$db = JFactory::getDbo();

$query = $db->getQuery(true);
$query->select($db->qn('hits'))
      ->from($db->qn('#__k2_items'))
      ->where($db->qn('created_by') . ' = ' . $db->q($this->user->id));
$db->setQuery($query);

$results = $db->loadObjectList();

$sum = 0;
foreach ($results as $key => $val)
{
    $sum+= $val->hits;
}

echo number_format($sum);

Simple database query that returns that hits for all articles created by the author of the current article being views.

It that adds each of the values in a foreach loop and displays the result.

Hope this helps :)