PHP分頁原理

標籤：

1.核心是利用mysql資料庫中的limit來進行分頁

語句：select * from tbArticle where status="0003" order by sn DESC limit offset, 100;

offSet為開始值，100為每頁的限制值

2.上一頁和下一頁，利用js中頁面的window.location.href 來進行頁面的跳轉

$(".prePage").click(function(){
var articleStatus = getArticleStatus();
var pageNum = getPageNum() - 1;

if (pageNum < 1) {
window.location.href="./getArticleList.html?articleStatus=" + articleStatus + "?pageNum=1";
}else{
window.location.href="./getArticleList.html?articleStatus=" + articleStatus +"?pageNum="+pageNum;
}
})

$(".nextPage").click(function(){
var articleStatus = getArticleStatus();
var pageNum = parseInt(getPageNum()) + 1;
window.location.href="./getArticleList.html?articleStatus=" + articleStatus +"?pageNum="+pageNum;
})
});

 

PHP分頁原理