Help Modifiying Code for Tags

Hi,

I haven't setup the tag cloud with this code so I'm not sure but could you use PHP sort() ?

Hi, Damon -

Thanks for your input but sort() won't work - not until I can first count the number of times each particular tag has been used.

How do I do that?!

:0)

Perch

Hi Perch, 

It looks like you've already got an array of tag names to counts called $tagsToCount.

PHP has a number of different sorting functions here: 
http://php.net/manual/en/array.sorting.php

I think the one you want is: arsort();

So if we start with this test data:

$tagsToCount = array (
  'apples' => 20,
  'oranges' => 33,
  'pears' => 2,
  'bananas' => 2,
  'peaches' => 22,
  'apricots' => 22,
);
arsort($tagsToCount);

// print output
header("Content-type: text/plain");
print_r($tagsToCount);
exit;


We get some output like this:

Array
(
    [oranges] => 33
    [peaches] => 22
    [apricots] => 22
    [apples] => 20
    [pears] => 2
    [bananas] => 2
)

Does that do what you need? 

And if you need it sorted by count and then alphabetic, try this:

krsort($tagsToCount);
arsort($tagsToCount);

Ah...!

Sorry Dave (and Damon!). I had hold of the wrong end of the stick. I see what the code does now and where I should add the sort(). I've dropped it in here:

<?php
$tagsToCount = array();
$sectionsToField = array('records' => 'tags');
foreach ($sectionsToField as $sectionName => $fieldName) {
//get section records
  $records = mysql_select($sectionName);
  foreach ($records as $record) {
//turn field into an array of values
    $tags = explode("\t", @ $record[$fieldName]);
// add tags to the count array
    foreach ($tags as $tag) {
      $tag = trim($tag);
      if (!$tag) {
        continue;
      } // skip empty array values
      if (array_key_exists($tag, $tagsToCount)) {
        $tagsToCount[$tag]++;
      }
      else {
        $tagsToCount[$tag] = 0;
      }
    }
  }
}
?>

<?php
//extract tags from the array
arsort($tagsToCount);
$tags = array_keys($tagsToCount);
$maximumResults = 20;
$resultCount = 0;
?>

This gives the intended result.

Just one thing; the count is wrong - due to the Postincrement code further up the chain...

$tagsToCount[$tag]++;

This means the count is always one less than the actual number. I thought I might be able to correct this by using a Preincrement - but it doesn't work:

++$tagsToCount[$tag]

Any ideas?

:0)

Perch

Hi Perch, 

Try replacing this: 

//turn field into an array of values
    $tags = explode("\t", @ $record[$fieldName]);
// add tags to the count array
    foreach ($tags as $tag) {
      $tag = trim($tag);
      if (!$tag) {
        continue;
      } // skip empty array values
      if (array_key_exists($tag, $tagsToCount)) {
        $tagsToCount[$tag]++;
      }
      else {
        $tagsToCount[$tag] = 0;
      }
    }


With this:

  $tags = explode("\t", @$record[$fieldName]);    // to lowercase tags use: mb_strtolower($record[$fieldName])
  $tags = array_filter(array_map('trim', $tags)); // remove whitespace and empty tags
  foreach ($tags as $tag) { @$tagsToCount[$tag]++; }

Let me know if that works for you!