Display Next Record
2 posts by 2 authors in: Forums > CMS Builder
Last Post: May 16, 2018 (RSS)
By osga - May 16, 2018
Hello guys.
We are working with a new website template and there is a slider image and related news article(s). Each 'slide' should display the next article by date posted. I thought we could just use the [1] after $articlesRecords ($articlesRecords[1], but obviously that doesn't work. I also tried to create the next article by using 'offset', which works to a point but throws errors and certainly can't be the way to do this (below) . . . Any assitance would be greatly appreciated.
// load record from 'articles'
list($articlesRecords2, $articlesMetaData) = getRecords(array(
'tableName' => 'articles',
'where' => '', // load second record
'loadUploads' => true,
'allowSearch' => false,
'limit' => '1',
'offset' => '1',
));
SO....Here what we have so far:
<?php
/* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */
// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/var/www/sites/www.osga.com/html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }
// load record from 'articles'
list($articlesRecords, $articlesMetaData) = getRecords(array(
'tableName' => 'articles',
'where' => '', // load first record
'loadUploads' => true,
'allowSearch' => false,
'limit' => '1',
));
?>
********************
<div class="caroufredsel_wrapper caroufredsel_wrapper_slider">
<ul class="slider">
<li class="slide">
<img src='images/slider/image_01.jpg' alt='img'>
<div class="slider_content_box">
<ul class="post_details simple">
<li class="category"><?php echo htmlencode($articlesRecord['art_field1']) ?></li>
<li class="date">
<?php echo date("D, M jS, Y g:i:s a", strtotime($articlesRecord['date'])) ?>
</li>
</ul>
<h2><div>
<?php foreach ($articlesRecords as $record): ?>
<a href="<?php echo $record['_link'] ?>" target="new"><?php echo $record['title'] ?></a><br/>
<p class="clearfix"><?php echo $record['summary'] ?></p>
<?php endforeach ?>
<?php if (!$articlesRecords): ?>
No records were found!<br/><br/>
<?php endif ?></div>
<!-- /Slide2: Display -->
</div>
</li>
<li class="slide">
<img src='images/slider/image_01.jpg' alt='img'>
<div class="slider_content_box">
<ul class="post_details simple">
<li class="category"><?php echo $articlesRecord[1]['categoryNum:label'] ?></li>
<li class="date">
<?php echo date("D, M jS, Y g:i:s a", strtotime($articlesRecord[1]['date'])) ?>
</li>
</ul>
<h2><div>
<?php foreach ($articlesRecords[1] as $record): ?>
<a href="<?php echo $record['_link'] ?>" target="new"><?php echo $record['title'] ?></a><br/>
<p class="clearfix"><?php echo $record['summary'] ?></p>
<?php endforeach ?>
<?php if (!$articlesRecords[1]): ?>
No records were found!<br/><br/>
<?php endif ?></div>
By Toledoh - May 16, 2018
Whenever I do this kind of thing, I just use the list view and order by; ie;
// load records from 'articles'
list($articlesRecords2, $articlesMetaData) = getRecords(array(
'tableName' => 'articles',
'loadUploads' => true,
'orderBy'=> date,
'allowSearch' => false,
));
<div class="caroufredsel_wrapper caroufredsel_wrapper_slider">
<ul class="slider"><?php foreach ($articlesRecords as $record): ?>
<li class="slide">
... slide content ...
</li>
<?php endforeach ?>
By the way. My favourite carousel these days is http://idangero.us/swiper/
Tim (toledoh.com.au)