php查询数据，ajax获取数据并分页展示

最新推荐文章于 2021-08-05 23:08:05 发布

fi25vh

最新推荐文章于 2021-08-05 23:08:05 发布

阅读量501

点赞数

分类专栏： jquery

本文链接：https://blog.csdn.net/fi25vh/article/details/104592518

版权

jquery 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

php查询数据，ajax获取数据并分页展示:

api.html
<script src="jquery-1.7.1.js"></script>
<script type="text/javascript">
var curPage = 1; //当前页码
var total,pageSize,totalPage;
//获取数据
function getData(page){
           $.ajax({
                   type: 'POST',
                   url: 'api.php',
                   data: {'pageNum':page-1},
                   dataType:'json',
                   beforeSend:function(){

                   $("#list ul").append("<li id='loading'>loading...</li>");
                   },
                       success:function(json){
                       //alert(json);
                       $("#list ul").empty();
                       total = json.total; //总记录数
                       pageSize = json.pageSize; //每页显示条数
                       curPage = page; //当前页
                       totalPage = json.totalPage; //总页数
                       var li = "";
                       var list = json.list;
                       $.each(list,function(index,array){ //遍历json数据列
                       li += "<li><img src='"+array['pic']+"'><a href='#'>"+array['title']+"</a></li>";
                       });
                   $("#list ul").append(li);
                   },
                   complete:function(){ //生成分页条
                   getPageBar();
                   },
                   error:function(){
                   alert("数据加载失败");
                   }
           });
}

//获取分页条
function getPageBar(){
//页码大于最大页数
if(curPage>totalPage) curPage=totalPage;
//页码小于1
if(curPage<1) curPage=1;
pageStr = "<span>共"+total+"条</span><span>"+curPage+"/"+totalPage+"</span>";

//如果是第一页
if(curPage==1){
pageStr += "<span>首页</span><span>上一页</span>";
}else{
pageStr += "<span><a href='javascript:void(0)' rel='1'>首页</a></span><span><a href='javascript:void(0)' rel='"+(curPage-1)+"'>上一页</a></span>";
}

//如果是最后页
if(curPage>=totalPage){
pageStr += "<span>下一页</span><span>尾页</span>";
}else{
pageStr += "<span><a href='javascript:void(0)' rel='"+(parseInt(curPage)+1)+"'>下一页</a></span><span><a href='javascript:void(0)' rel='"+totalPage+"'>尾页</a></span>";
}

$("#pagecount").html(pageStr);
}

$(function(){
getData(1);
$("#pagecount span a").live('click',function(){
var rel = $(this).attr("rel");
if(rel){
getData(rel);
}
});
});
</script>
</head>

<body>

api.php

<?php

$host="localhost";
$db_user="root";
$db_pass="root";
$db_name="pages.cn";
$timezone="Asia/Shanghai";
$con=mysqli_connect($host,$db_user,$db_pass,$db_name);
if (mysqli_connect_errno($con))
{
echo "连接 MySQL 失败: " . mysqli_connect_error();
}

mysqli_set_charset($con, "utf8");
$page = intval($_POST['pageNum']);

$sql="select id from food";
$result=mysqli_query($con,$sql);
$total = mysqli_num_rows($result);//总记录数

$pageSize = 6; //每页显示数
$totalPage = ceil($total/$pageSize); //总页数
$startPage = $page*$pageSize;
$arr['total'] = $total;
$arr['pageSize'] = $pageSize;
$arr['totalPage'] = $totalPage;
$sql="select id,title,pic from food order by id asc limit $startPage,$pageSize";
if ($result=mysqli_query($con,$sql))
{
// 一条条获取
// while ($row=mysqli_fetch_row($result))
// {
// printf ("%s : %s",$row[0],$row[1]);
// echo "<br>";
// }

   while($row=mysqli_fetch_row($result)){
       //printf($row[1]);
       $arr['list'][] = array(
           'id' => $row[0],
           'title' => $row[1],
           'pic' => $row[2],
       );
   }
}