array_groupBy and display image

4 posts by 2 authors in: Forums > CMS Builder
Last Post: September 23, 2020   (RSS)

Hi All.

I'm grouping records by brand with the code below:

// load records from 'independent_research_reports'
list($researchRecords, $researchMetaData) = getRecords(array(
'tableName' => 'independent_research_reports',
'where' => "`typeNum` = '1'",
'loadUploads' => true,
'allowSearch' => false,
));
$researchSeries = array_groupBy($researchRecords, 'brandsNum:label', true);

Sor to display the brand, I use;

<?php foreach($researchSeries as $series => $items): ?>
<div class="row">
<div class="col"><h3><?php echo htmlencode($series) ?></h3></div>
</div>
   <?php foreach ($items as $record): ?>.....<?php endforeach ?>
<?php endforeach ?>

My question is, how do I go about displaying an image with each brand?

<?php foreach($researchSeries as $series => $items): ?>
<div class="row">
<div class="col">

[IMAGE HERE]
<h3><?php echo htmlencode($series) ?></h3></div>

</div>
   <?php foreach ($items as $record): ?>.....<?php endforeach ?>
<?php endforeach ?>

Cheers,

Tim (toledoh.com.au)

By Carl - September 18, 2020 - edited: September 23, 2020

Hi Toledoh,
Were you only wanting to display a single image? In your getRecords function, you are including the uploads in your results so the following code should do the trick you're wanting. Note: I haven't tested it, so you might need to change some things to get it to work. If you want to display multiple images, you can just loop the $image variable and get every image attached to the record.

<?php foreach($researchSeries as $series => $items): ?>
	<div class="row">
	<div class="col">

	<?php
	$image = $items['images'];
if (!empty($images[0]['urlPath'])):
	?>
	<img src="<?php echo $images[0]['urlPath']; ?>">
    <?php
endif;
	?>

    <h3><?php echo htmlencode($series) ?></h3></div>

    </div>
       <?php foreach ($items as $record): ?>.....<?php endforeach ?>
    <?php endforeach ?>
Carl

PHP Programmer

interactivetools.com

By Carl - September 23, 2020

What if you created a $researchRecords loop first and then loop over other items? It might be easier if you submitted a support request so I can see how everything is being joined together and I can more specifically help with a code snippet.

https://www.interactivetools.com/support/request/

Carl

PHP Programmer

interactivetools.com