Introduction to the method of implementing the article top function in PHP

The example in this article describes the method of implementing the article top function in PHP. Share it with everyone for your reference, the details are as follows:

Yesterday, the customer asked me to pin the article to the top. I haven't done it before. I did it with the guidance of my colleagues. It was a simple thing at first, but it took me a long time to do it. I really lack understanding of the program. Let’s write a blog to record it.

The first step is to create two fields in the article table for the pin function. One is the top field, timestamp type, "Definition" is selected by default, and is used to store the time of the pin operation; there is also a flag field, int type, used to determine whether to pin the item to the top. The pin is 1, otherwise it is 0. .

The second step is to modify the template page. Add a top column to the list option, and write the following code in the corresponding line below:

<td class="center"> {{if $logs[data].flag}} 
<a href="JavaScript:void(0);" onclick="istop(&#39;{{$logs[data].id}}&#39;,0)">取消置顶</a>{{else}} <a href="javascript:void(0);" 
onclick="istop(&#39;{{$logs[data].id}}&#39;,1)">置顶</a>{{/if}}</td>

is to use the flag to determine whether it is pinned to the top.
The pinned js corresponding to the page:

function istop(id,flag){
$.ajax({
type: "POST",
url: "?m={{'article'|encrypt}}&a=savePost",
data: "id="+id+"&flag="+flag,
dataType:"json",
success: function(msg){
if(msg.status == "true")
{
 window.location= '?m={{'article'|encrypt}}';
}
else
{
 alert(msg.message);
}
}
});
}

The third step is to make slight modifications in the program. First sort by whether to stick to the top, then sort by the stick time, and then sort by the default.

$sql .=" ORDER BY flag DESC,top DESC,id DESC ";

(Remember the fields we added?)

This completes the function of pinning the article to the top.

The above is the introduction of the method of implementing the article top function in PHP. For more related content, please pay attention to the PHP Chinese website (m.sbmmt.com)!