dongwu8050 2015-02-01 14:11
浏览 13

用Jquery显示分页

For example: I have 101 pages of results retrieve from database and I echoed it out like this:

$num_rec_per_page=5;
$result = mysqli_query($conn,$sql)
$total_records= mysqli_num_rows($result); // Get the number of rows
$total_pages = ceil($total_records / $num_rec_per_page);
...
for ($i=1; $i<=$total_pages; $i++){
 echo "<li class='num-pager'><a href=\"http://....&page=$i\">Page $i</a></li>";
}

Now I would like to display only 5 pages, so I write a simple jquery like this:

<script>
jQuery(function($) {
var page = $(".num-pager");
var totalPages = page.length;
var displayRange = 2;
var showFrom = 0;
var showTo = 5;
page.hide();
page.slice(showFrom,showTo).show();
});
</script>

So instead of showing all 101 pages like this: Page 1 | Page 2 | Page 3 ...Page101

I would like to show only 5 pages: Page 1 | Page 2 | Page 3 | Page 4 | Page 5

The problem comes from here: What if user wants to view page 6??? So I came up in mind that: if user click Page 5 (page number = showTO variable), it will add displayRange=2 to showFrom and showTo variables in the js code so that it will display from Page 3 to Page 7 like this:

Page 2 | Page 3 | Page 4 | Page 5 | Page 6 | Page 7

This is only theory, I don't know how to apply it for this advanced case. Please help...Many thanks

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 求各位懂行的人,注册表能不能看到usb使用得具体信息,干了什么,传输了什么数据
    • ¥15 个人网站被恶意大量访问,怎么办
    • ¥15 Vue3 大型图片数据拖动排序
    • ¥15 Centos / PETGEM
    • ¥15 划分vlan后不通了
    • ¥20 用雷电模拟器安装百达屋apk一直闪退
    • ¥15 算能科技20240506咨询(拒绝大模型回答)
    • ¥15 自适应 AR 模型 参数估计Matlab程序
    • ¥100 角动量包络面如何用MATLAB绘制
    • ¥15 merge函数占用内存过大