making a "go to next article" link on detailed article page

Hi Meg, 

This is can be done using getPrevAndNextRecords function. I wrote an example of how to use it in this post:

http://www.interactivetools.com/forum/forum-posts.php?postNum=2230133#post2230133

Let me know if you need a hand integrating it into your code.

Cheers!

Greg

Thanks. I tried to implement the script according to that post and I'm getting an error. What am I doing wrong?

Notice: Undefined variable: articlesRecord in /home/content/85/8004985/html/themarrowmagazine/article.php on line 19

Code:

<?php
  $libraryPath = 'cms/lib/viewer_functions.php';
  $dirsToCheck = array('/home/content/85/8004985/html/themarrowmagazine/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

  list($articlesRecords, $articlesMetaData) = getRecords(array(
    'tableName'   => 'articles',
    'where'       => whereRecordNumberInUrl(1), 
    'loadUploads' => true,
    'allowSearch' => true,
    'limit'       => '1',
  ));
  $detailRecord = @$articlesRecords[0];
  
  list($prevRecord, $nextRecord, $firstRecord, $lastRecord) = getPrevAndNextRecords(array( 
    'tableName' => 'articles', 
    'recordNum' => $articlesRecord['num'], 
    'orderBy'   => 'createdDate'
  ));
  
  list($articlesRecords, $articlesMetaData) = getRecords(array(
    'tableName'   => 'articles',
    'loadUploads' => false,
    'allowSearch' => false,
'perPage'     => '1',
  ));
  

?>

<!-- PREVIOUS -->
<div class="previous-article"><?php if ($articlesMetaData['prevPage']): ?><a href="<?php echo (@$prevRecord['_link'])? $prevRecord['_link'] : '?' ; ?>" style="background: none;"><span style="font-size: 12px"><</span> PREVIOUS FEATURE</a> <?php else: ?><span style="font-size: 12px"><</span> PREVIOUS FEATURE<?php endif ?></div>

<!-- NEXT -->
<div class="next-article"><?php if ($articlesMetaData['nextPage']): ?><a href="<?php echo $articlesMetaData['nextPageLink'] ?>" style="background: none; text-align: right;">NEXT FEATURE <span style="font-size: 12px">></span></a><?php else: ?>NEXT FEATURE <span style="font-size: 12px">></span><?php endif ?></div>


Hi Meg,

You've assigned the details from your articles section to $detailRecord. You just need to amend $articlesRecord['num'] to $detailRecord['num']:

<?php
  $libraryPath = 'cms/lib/viewer_functions.php';
  $dirsToCheck = array('/home/content/85/8004985/html/themarrowmagazine/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

  list($articlesRecords, $articlesMetaData) = getRecords(array(
    'tableName'   => 'articles',
    'where'       => whereRecordNumberInUrl(1), 
    'loadUploads' => true,
    'allowSearch' => true,
    'limit'       => '1',
  ));
  $detailRecord = @$articlesRecords[0];
  
  list($prevRecord, $nextRecord, $firstRecord, $lastRecord) = getPrevAndNextRecords(array( 
    'tableName' => 'articles', 
    'recordNum' => $detailRecord['num'], 
    'orderBy'   => 'createdDate'
  ));
  
  list($articlesRecords, $articlesMetaData) = getRecords(array(
    'tableName'   => 'articles',
    'loadUploads' => false,
    'allowSearch' => false,
'perPage'     => '1',
  ));
  

?>

This will return the previous and next record details for selected article number.

Cheers!

Greg

Hi Meg,

You just need to change the code so that it checks if data from the prevRecord and nextRecord exists. As the $articleMetaData['prevPage'] will always have a link even if it's to a blank page. Something like this should work:

<!-- PREVIOUS -->
<div class="previous-article">
  <?php if (@$prevRecord['num']): ?>
    <a href="<?php echo (@$prevRecord['_link'])? $prevRecord['_link'] : '?' ; ?>" style="background: none;"><span style="font-size: 12px"><</span> PREVIOUS FEATURE</a>
  <?php else: ?>
    <span style="font-size: 12px"><</span> PREVIOUS FEATURE
  <?php endif ?>
</div>

<!-- NEXT -->
<div class="next-article">
  <?php if (@$nextRecord['num']): ?>
    <a href="<?php echo (@$nextRecord['_link'])? $nextRecord['_link'] : '?' ; ?>" style="background: none; text-align: right;">NEXT FEATURE <span style="font-size: 12px">></span></a>
  <?php else: ?>
    NEXT FEATURE <span style="font-size: 12px">></span>
  <?php endif ?>
</div>

If there isn't a previous or next record, the system will return an empty array, so we can check for the num value in each variable to see if the array has been created.

Let me know if you have any questions.

Cheers

Greg