以MVC为框架和Ajax实现分页的效果

最新推荐文章于 2021-03-23 10:22:11 发布

卡布奇诺Princes

最新推荐文章于 2021-03-23 10:22:11 发布

阅读量2.5k

点赞数 2

分类专栏：知识总结文章标签： mvc Ajax

本文链接：https://blog.csdn.net/zsj523/article/details/8674654

版权

知识总结专栏收录该内容

186 篇文章 1 订阅

订阅专栏

fenyeController.class.php文件

<?php
class fenyeController extends baseController{
public function showAction(){
  $goodsModel = new goodsModel('localhost','xuefei','root','123');
  $rows = $goodsModel ->getAll();
  $this ->smarty->assign('list',$rows);
  $this ->smarty->display('fenye.tpl');
}
public function processAction(){
  $goodsModel = new goodsModel('localhost','xuefei','root','123');
  //每页显示记录数
  $pagesize = 2;
  //求出总的记录数
  $total_rows = $goodsModel ->getTotal();
  //求总共的页码数
  $pages = ceil($total_rows[0]/$pagesize);
  //当前第几页
  $page = $_POST['page'];
  $str = "当前第".$page."页"."总共".$pages."页"."共".$total_rows[0]."记录";
  //var_dump($str);
  //接下来，我要根据当前点击的页码求出对应的数据
  $offset = $pagesize*($page-1);
  $pageInfo = $goodsModel ->getPage($offset,$pagesize);
  //var_dump($pageInfo);
  //将获得数据链接，后返回
  $first = 1;
  $prev = $page-1;
  $next = $page+1;
  $last = $pages;

  $first_a = "<a οnclick='viewpage(".$first.")' href='#'>首页</a>";
  if($page>1){
   $prev_a = "<a οnclick='viewpage(".$prev.")' href='#'>上一页</a>";
  }
  if($page<$pages){
   $next_a = "<a οnclick='viewpage(".$next.")' href='#'>下一页</a>";
  }
  $last_a = "<a οnclick='viewpage(".$last.")' href='#'>尾页</a>";
  $str = $str.$first_a.$prev_a.$next_a.$last_a;
  //var_dump($str);
  $info = array('str'=>$str,'info'=>$pageInfo);
  echo json_encode($info);

//命令视图层显示数据

}
}

goodsModel.class.php文件

<?php
//短路算法
defined("APP_NAME") || die("非法访问");
class goodsModel extends baseModel{
public function getAll(){
  $sql = "select * from book";
  $result = mysql_query($sql);
  $rows = array();
  while($row = mysql_fetch_assoc($result)){
   $rows[] = $row;
  }
  return $rows;
}
  public function getTotal(){
  $sql = "select count(*) as total_rows from book";
  $result = mysql_query($sql);
  $rows = mysql_fetch_array($result);
  //file_put_contents("d://row.txt",$rows,FILE_APPEND);
  return $rows;
}
public function getPage($offset,$pagesize){
  $sql = "select * from book limit $offset,$pagesize";
  $result = mysql_query($sql);
  $rows = array();
  while($row = mysql_fetch_assoc($result)){
   $rows[] = $row;
  }
  return $rows;
}
}
fenye.tpl文件

<html>
<head>
  <meta charset="utf-8">
  <script>
   function viewpage(page){
    var xhr;
    if(window.ActiveXObject){
     xhr = new ActiveXObject("Microsoft.XMLHTTP");
    }else if(window.XMLHttpRequest){
     xhr = new XMLHttpRequest();
    }
    var url = "index.php?c=fenye&a=process";
    xhr.open("POST",url,true);
    xhr.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
    xhr.onreadystatechange = callback;
    xhr.send("page="+page);
    function callback(){
     if(xhr.readyState==4){
      if(xhr.status==200){
      //alert(xhr.responseText);
      var json = eval("("+xhr.responseText+")");
      var str = json.str;
      document.getElementById("para").innerHTML = str;

      for(var i=0;i<json.info.length;i++){
       var info = json.info[i].id+json.info[i].name+json.info[i].author+json.info[i].public+json.info[i].isbn+json.info[i].type+json.info[i].price;
       document.getElementById('div').innerHTML = info;
       }

      //alert(json.str);
      //alert(json.str);
      /*for(var i=0;i<json.info.length;i++){
       alert(json.info[i].name);
      }
      */
     }
    }
   }
   }
  </script>
</head>
<body onLoad="viewpage(1)">

<h3 align="center">数据分页显示</h3>
<table style="margin-bottom:20px;margin:auto;border:1px solid;border-spacing:1">
  <tr>
  <th>ID</th><th>名称</th><th>作者</th><th>出版社</th><th>ISBN号</th><th>类型</th><th>价格</th>
  </tr>
  <{foreach from=$list item="value"}>
  <tr>
  <td style="padding-top:5px;"><{$value.id}></td>
  <td style="padding-top:5px;"><{$value.name}></td>
  <td style="padding-top:5px;"><{$value.author}></td>
  <td style="padding-top:5px;"><{$value.public}></td>
  <td style="padding-top:5px;"><{$value.isbn}></td>
  <td style="padding-top:5px;"><{$value.type}></td>
  <td style="padding-top:5px;"><{$value.price}></td>
  </tr>
  <{/foreach}>
  </table>
  <table align="center" style="margin-top:15px">
<tr>
<td style="colspan:3;height:20">
<p id="para"></p>
</td>
</tr>
</table>
<div id="div"></div>
</body>
</html>

卡布奇诺Princes

关注

2
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
以MVC为框架和Ajax实现分页的效果

fenyeController.class.php文件class fenyeController extends baseController{ public function showAction(){ $goodsModel = new goodsModel('localhost','xuefei','root','123'); $rows = $goodsModel
复制链接

扫一扫