php ajax mysql 获取数据库信息分页显示

最新推荐文章于 2021-02-02 20:06:20 发布

薛8

最新推荐文章于 2021-02-02 20:06:20 发布

阅读量607

点赞数

分类专栏： php

本文链接：https://blog.csdn.net/xueba8/article/details/78151965

版权

php 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

php code:

<?php
   include("../../../install/config.php");
   if($_POST){
       $pageNow = $_POST['pageNow']; //现在所在的页面
       $pageNow = 1;
       $perNumber = 10; //每页显示的记录数
       $pageStart = ($pageNow-1)*$perNumber;   //记录数开始
       $pageEnd = $pageNow*$perNumber;   //记录数结束
       $result = $conn->query("SELECT COUNT(*) FROM member"); // 获得用户信息数据库记录总数
       $result1 =$conn->query("SELECT * FROM member LIMIT $pageStart, $pageEnd");   //获得用户信息数据库表的全部信息
       list($totalNum) = $result->fetch_row();
       $per_num = ceil($totalNum/$perNumber); //获得总页数
       while($row=$result1->fetch_assoc()){          //while循环获得数据
           $studentnumber=$row['studentnumber'];
           $result_form = $conn->query("SELECT * FROM member_form WHERE studentnumber='$studentnumber' ");
           $row_form = $result_form->fetch_assoc();
           $data['list'][] = array(              //二维数组
                           "msg" => "成功",
                           "uid" => $row['uid'],
                           "studentnumber" => $row['studentnumber'],
                           "name" => $row['name'],
                           "email" => $row['email'],
                           "phone" => $row['phone'],
                           "qq" => $row['qq'],
                           "major" => $row['major'],
                           "hometown" => $row['hometown'],
                           "progress" => $row_form['progress'],
                           "progress_msg" => $row_form['progress_msg'],
                           "profile" => $row_form['profile'],
                           "profile1" => $row_form['profile1'],
                           "profile2" => $row_form['profile2']
                       );
       }
       echo json_encode($data);
   }
?>

JS code:

$(document).ready(getUserInfo());
var userInfo =[];    // js创建数组也可以这样 var userInfo =new Array();

function getUserInfo() { //取得一个用户信息的数组
   var pageNow = 1;
   var data = {
       'pageNow': "1"
   };
   $.ajax({
       type: "POST",
       dataType: "json",
       url: "allUsers.php",
       data: data,
       success: function (data){
           var list = data.list;   //与php的二维数组对应。获取list下的数据
           $.each(list,function (index,val){         //$.each 遍历数组 index为索引，val为值
               userInfo["uid"] = val['uid'];
               pageBar();   //加载pageBar函数，输出信息
           });
       },
       error: function (err){
           alert("信息获取失败");
       }
   });
}
function pageBar(){
   $(".users_content").html("<tr><td>"+userInfo["uid"]+"</td></tr>");
}