Been Here Before

Hi Michael,

If you want to group the records by their category, you can use cmsb library function array_groupBy($array, $key). In your case you can call it like this: $records = array_groupBy($resource_links_docsRecords, 'category'); That will give you the record array that's grouped by their category, and do 2 foreach loop to get the result.

Hope that answers your question!

Thanks,

So what does that look like in my situation here.

I am not experienced enough to see that work out in code.

Thanks
Your help is greatly appreciated.

Michael

Hi Michael,

If you want an array of records that are grouped by their categories, call $records = array_groupBy($resource_links_docsRecords, 'category:label');

And your page will be something similar to this structure:

<?
foreach($records as $categoryLabel => $recordsByCategory){
  echo $categoryLabel; // HTML for the category label
  foreach($recordsByCategory as $record){
    showme($record); // HTML for each record
  }
}
?>

Hope that helps!

Ok

I have broken out what you did so that I can have more control over how I display it

But I'm getting errors and I am hoping it's because of how I am adding the strings.

   <? foreach($records as $categoryLabel => $recordsByCategory): // HTML for the category label?>
    <h4><p><?php echo ($categoryLabel['lables']) ?></p></h4>
   <? foreach($recordsByCategory as $record): ?>
    <ul>
<li><?php echo ($record['title']) // HTML for each record ?></li>
    </ul>
   <? endforeach ?>
   <hr/>
   <? endforeach ?>

The errors I'm getting back are:

Warning: Illegal string offset 'lables' in /home/homevaluere/public_html/resourcesTEST.php on line 34

• Warning: Illegal string offset 'title' in /home/homevaluere/public_html/resourcesTEST.php on line 37 R
• Notice: Undefined index: title in /home/homevaluere/public_html/resourcesTEST.php on line 37
• Notice: Undefined index: title in /home/homevaluere/public_html/resourcesTEST.php on line 37
• AND SO ON .....

I am closer than I was  ...

What is the problem? (Page attached)

Michael

Hi Michael,

The label is just $categoryLabel not $categoryLabel['label']. And seems either your record doesn't have a 'title' field or it doesn't have a 'category' field. That gives you the second error. Fix those and you should be good!

Hey Leo

I changed it to $categoryLabel which now it is showing the category "number" but not the actual title of the category.

Both the category list and the docs/links list have a "title"

And the docs/links section does have a "category" field as it is a list pulling the of "category" list into it. (see attached image)

So I am seeing where you're going but something is still missing.

What do you think?

Michael

Hi Michael,

Try changing your array_group function to this: array_groupBy($resource_links_docsRecords, 'category:label'); and it should be good!

OK 

One step closer.

We got rid of the errors but it seems to skip over your code altogether.

Here is what I have: (the main chunks LOL)

  // load records from 'resource_links_docs'
  list($resource_links_docsRecords, $resource_links_docsMetaData) = getRecords(array(
    'tableName'   => 'resource_links_docs',
    'loadUploads' => true,
    'allowSearch' => false,
  ));
  
  $records = array_groupBy($resource_links_docsRecords, 'category:label');



    <h1>Leo's Code</h1>
   <? foreach($records as $categoryLabel => $recordsByCategory): // HTML for the category label?>
    <h4><p><?php echo ($categoryLabel) ?></p></h4>
   <? foreach($recordsByCategory as $record): ?>
    <ul>
<li><?php echo ($record['title']) // HTML for each record ?></li>
    </ul>
   <? endforeach ?>
   <hr/>
   <? endforeach ?>

    <h1>Regular Viewer Code</h1>
    <?php foreach ($resource_links_docsRecords as $record): ?>
    
      Record Number: <?php echo htmlencode($record['num']) ?><br/>
      Title: <?php echo htmlencode($record['title']) ?><br/>
      Category (values): <?php echo join(', ', $record['category:values']); ?><br/>
      Category (labels): <?php echo join(', ', $record['category:labels']); ?><br/>
      Link: <?php echo htmlencode($record['link']) ?><br/>

      <hr/>
    <?php endforeach ?>

    <?php if (!$resource_links_docsRecords): ?>
      No records were found!<br/><br/>
    <?php endif ?>


You can see the result here:

http://homevaluerealestate.biz/resourcesTEST.php

Thanks 

Michael

Hi Michael,

Try this: array_groupBy($resource_links_docsRecords, 'category:label', true);