Multiple record listing

Hi Oakweb,

Based on one of the recipes in my CMSB Cookbook http://www.thecmsbcookbook.com, one possible approach is that you can have separate list records calls in the body of your page that set different parameters for the separate lists of articles.

So the code for the headlines could be something like:

<?php

list($newsRecords, $newsMetaData) = getRecords(array(
'tableName' => 'news',
'limit' => '5',
));
?>
<table width="100" Align="left" border="0" cellpadding="5">
<?PHP foreach ($newsRecords as $record): ?>
<tr>
<td><?PHP echo $record['_link'] ?>"><?PHP echo $record['headline'] ?>
</td>
</tr>
<?PHP endforeach; ?>
</table>

And the code for the item listing could be something like

<?php

list($newsRecords, $newsMetaData) = getRecords(array(
'tableName' => 'news',
'limit' => '10',
));
?>
<table width="100" Align="left" border="0" cellpadding="5">
<?PHP foreach ($newsRecords as $record): ?>
<tr>
<td><?PHP echo $record['_link'] ?>"><?PHP echo $record['content'] ?>
</td>
</tr>
<?PHP endforeach; ?>
</table>

If you want to limit the number of words in the” item” listings, here’s a recipe from the Cookbook which addresses that concept.

LIMITING THE NUMBER OF WORDS SHOWN IN A PAGE
If you use the character limiting function that’s exactly what you’ll get, and words can be cut off. But if you want to limit the word count, Dave Edis from Interactive Tools shares his usual uncanny wisdom:

Put this code at the top of your page, or before you want to invoke the word limiting function:

<?PHP
function maxWords($textOrHtml, $maxWords) {
$text = strip_tags($textOrHtml);
$words = preg_split("/\s+/", $text, $maxWords+1);
if (count($words) > $maxWords) { unset($words[$maxWords]); }
$output = join(' ', $words);

return $output;
}
?>

Then put this code inside the foreach loop where you want the words limited (to 5 words):

<?PHP echo maxWords($record['content'], 5);
?>
If you want to add ...more and a link, use something like this:

<?PHP echo maxWords($record['content'], 5);
?>...<a href="<?php echo $record['_link']; ?>”>Read More</a>


If you’re using a WYSIWYG Editor and are losing some formatting when using the MaxWord function, Jason Sauchuk of Interactive Tools suggests using this version of the function instead:

<?PHP
function maxWords($textOrHtml, $maxWords) {
$text=str_replace("<p>","*P*",$textOrHtml);
$text= str_replace("</p>","*/P*",$text);
$text = strip_tags($text);
$words = preg_split("/\s+/", $text, $maxWords+1);
if (count($words) > $maxWords) { unset($words[$maxWords]); }
$output = join(' ', $words);
$output=str_replace("*P*","<p>",$output);
$output=str_replace("*/P*","</p>",$output);
$output.="</p>";

return $output;
}
?>

Hope that helps to get you started.

Best,

Jerry Kornbluth

Many thanks for your help - all working well