What are some best practices for implementing links to navigate to the next and previous news articles in a PHP news system?

When implementing links to navigate to the next and previous news articles in a PHP news system, it is essential to keep track of the current article's position and dynamically generate the URLs for the next and previous articles. One common approach is to use database queries to fetch the IDs of the adjacent articles based on the current article's ID and then construct the URLs accordingly. 

// Assuming $currentArticleId contains the ID of the current article

// Query to get the ID of the next article
$queryNext = "SELECT id FROM articles WHERE id > $currentArticleId ORDER BY id ASC LIMIT 1";
$resultNext = mysqli_query($connection, $queryNext);
$nextArticleId = mysqli_fetch_assoc($resultNext)['id'];

// Query to get the ID of the previous article
$queryPrev = "SELECT id FROM articles WHERE id < $currentArticleId ORDER BY id DESC LIMIT 1";
$resultPrev = mysqli_query($connection, $queryPrev);
$prevArticleId = mysqli_fetch_assoc($resultPrev)['id'];

// Generate the URLs for the next and previous articles
$nextUrl = ($nextArticleId) ? "article.php?id=$nextArticleId" : "";
$prevUrl = ($prevArticleId) ? "article.php?id=$prevArticleId" : "";

// Output the links
echo "<a href='$prevUrl'>Previous Article</a>";
echo "<a href='$nextUrl'>Next Article</a>";

Keywords

pagination PHP database queries navigation links news system

Related Questions