Phoca Forum

Hi all,

I posted this around a year ago now, wondering if anyone can help at all yet....I am looking for a way display gallery statistics in Joomla, ideally in a module box..I would like to display "Total Number of Photos Online: XXXXXX" and "Total Albums Online: XXXXXX" which updates as I add more images to the gallery - I am thinking this is most likely fairly straight forward to pull the info out of MySQL...but no idea how!

Any help or ideas would be great

Steve

Hi, what you exactly mean with "total number of photos online"? Do you mean all images inside Phoca Gallery which are published? (resp. categories)

Jan

Yes, the total number published photos in all of the catergories, like a global photo stats sort of module is what I am after

Hi, then you need to do new module or customize some other and add sql to this (with loading the items and displaying them in html)

something like: or for categories:

I have found a plugin to insert code into an artice. There is an example: $db = JFactory::getDbo();

$query = $db->getQuery(true);
$query->select($db->quoteName(array('favorite_color')))
->from($db->quoteName('colors'))
->where($db->quoteName('name') . ' = '. $db->quote('bob'));
$db->setQuery($query);
$rows = $db->loadObjectList();

foreach ($rows as $row) {
echo $row->favorite_color;
}

How can I implement your code to show number of photos uploaded? I really need a code to show how many photos my gallary contains.

Hi, which code you mean? I added SQL example how to get the counts from database, but not a module code

Jan

Yes, you supplied the SQL query example. I supplied some code I found in anouther joomla plugin to add custom code in an article. I ask if your examples can be added in the supplied code or if you can supply a working code like the example I posted. I really need some code to show total number of photos available in my gallery.

Hi, the code needs to be directly customized on your site - on place where you exactly want to display the statistics. On this place you should implement the sql query to get the statistics and display the outcome - unfortunately I don't know your site and the place where you want to display it - coding is about directly implementing and testing the changes on server - so this needs to be customized directly on the server (with testing, etc.)

Jan