Provides various official and user-released code examples. For code reference, you are welcome to exchange and learn. We often encounter this issue during the interview. use SQL to write the ID of the previous and next articles to query. Today, we will share the simplest query code for the previous and next articles.
Obtain the id of the current browser article
$id = isset($_GET['id']) > 0 ? intval($_GET['id']) : "";
Next article
$query = mysql_query("SELECT id,title FROM article WHERE id>'$id' ORDER BY id ASC LIMIT 1");
$next = mysql_fetch_array($query);
Previous Article
$query = mysql_query("SELECT id,title FROM article WHERE id <'$id' ORDER BY id DESC LIMIT 1");
$prev = mysql_fetch_array($query);
The title and link of the previous and next articles are displayed.
">
">
Previous and next article Demonstration: http://www.sucaihuo.com/php/436.html
Php#mysql and the following article. Zip (5.9 KB download: 31 times)
AD: truly free, domain name + VM + enterprise mailbox = 0 RMB