Count pages with attribute (tag) assigned

Permalink March 15, 2017 at 5:21 PM

Hi,
how can I retrieve the number of pages that have an attribute (a tag) applied to? In previous version I used this function that in 8.10 seems not working.
thanks

public function pageUseCount($optID) {
      $db = Loader::db();
      $q = "select Pages.cID from Pages where cIsActive = 1";
      $r = $db->query($q);
      if ($r) {
         while ($row = $r->fetchRow()) {        
            $page = Page::getByID($row['cID']);
            if (gettype($page->getAttribute($this->attributeHandle)) == 'object') {
               foreach($page->getAttribute($this->attributeHandle) AS $v) {
                  if ($v->ID == $optID) $i[$v->ID][] = true;
               }
            }
         }
      }
      return count($i[$optID]);

Viewing 15 lines of 16 lines. View entire code block.

 
public function pageUseCount($optID) {
 
      $db = Loader::db();
 
      $q = "select Pages.cID from Pages where cIsActive = 1";
      $r = $db->query($q);
 
      if ($r) {
         while ($row = $r->fetchRow()) {        
            $page = Page::getByID($row['cID']);
            if (gettype($page->getAttribute($this->attributeHandle)) == 'object') {
               foreach($page->getAttribute($this->attributeHandle) AS $v) {
                  if ($v->ID == $optID) $i[$v->ID][] = true;
               }
 
            }
         }
      }
 
      return count($i[$optID]);
 
   }

Post Reply

Delete Post

You are allowed to delete your post for 5 minutes after it's posted.

Delete

Mark Post as Spam

Are you sure you would like to mark this post as spam?

Mark as Spam

Destroy Spammer

This script will report this post as spam and add a permanent IP ban for this user, type "DESTROY" below to continue.

DESTROY SPAMMER

Sign In?

You must have a user account and be signed to perform this action.

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.

Forums

Developing (v7+)