How to implement the functions of the previous and next articles in PHP (code)

The content of this article is about how PHP implements the functions (code) of the previous and next articles. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to you.

Take some time every day to summarize.

In actual PHP development, publishing news or articles generally involves the functions of the previous article and the next article. When doing this function, the first thing that comes to mind is, how to implement it in one step? What I will think about is, how to get the ID of the previous article and the ID of the next article? After some thinking, I thought of it. The ideas for solving the problem are as follows:

1. Connect to the database.

2. Get the id of the previous or next article through the limit statement

3. Use the if statement to determine the previous article, then get the smallest id and compare it with it. The current ids are equal. Next article, vice versa. . .

4. $rsQ = mysql_fetch_object($resultQ); //It is an array of objects. Get a row from the result set (record set) as an object, and use the data returned by the json interface to get each parameter.

<?php
                    require_once  &#39;conn.php&#39;; // 连接数据库
                   //上一篇文章 
                   $id = $_GET[&#39;id&#39;];  // id 为每一篇文章的id
                    $sqlQ = "select * from 表名 where id < $id order by id desc limit 0,1"; // 取出上一篇的id小于当前的id
                    // 查询数据获取id的最小值
                    $Sqlmin="select id from 表名 where id=(select min(id) from 表名)";
                    $resultmin = mysql_query($Sqlmin);
                    // 获取Sqlmin中的某一个字段
                    $rowQ  = mysql_fetch_assoc($resultmin);

                    $resultQ = mysql_query($sqlQ) or die(&#39;错误：&#39;.mysql_error());
                    $rsQ = mysql_fetch_object($resultQ);  // 结果集（记录集）中取得一行作为对象。
                     
                    if ($id == $rowQ[&#39;id&#39;]) { 
                        $idQ = &#39;&#39;; 
                        $rsQtitle = &#39;&#39;; // 上一篇的标题
                    }
                    else{
                        $idQ = $rsQ->id; // stdClass Object里面每个参数的值 , 利用json接口返回的数据
                         $rsQtitle = $rsQ->title; // 上一篇的标题
                    }
                    //下一篇文章 
                    $sqlH = "select * from lujiaoxiang_addarticle where id > $id order by id asc limit 0,1"; 
                    
                    // 查询数据获取id的最大值
                    $Sqlmax="select id from lujiaoxiang_addarticle where id=(select max(id) from lujiaoxiang_addarticle)";
                    $resultmax = mysql_query($Sqlmax);
                    $rowH  = mysql_fetch_assoc($resultmax);
                    $resultH = mysql_query($sqlH) or die(&#39;错误：&#39;.mysql_error());
                    $rsH = mysql_fetch_object($resultH);
                  
                    if ($id == $rowH[&#39;id&#39;]) {
                        $idH = &#39;&#39;; 
                        $rsHtitle = &#39;&#39;;
                    }
                    else{
                        $idH = $rsH->id; // stdClass Object里面每个参数的值 , 利用json接口返回的数据   
                        $rsHtitle = $rsH->title; // 下一篇的标题
                    } 
                    ?>

The final effect is as shown below:

##Related recommendations:

php implementation File upload and download methods (code)

Code implementation of WeChat authorized login under TP5 framework

The above is the detailed content of How to implement the functions of the previous and next articles in PHP (code). For more information, please follow other related articles on the PHP Chinese website!