page.php 1.0 KB

123456789101112131415161718192021222324252627282930313233343536
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: yoby
  5. * Date: 2018/8/24
  6. * Time: 23:31
  7. */
  8. include "db.php";
  9. if(1==$_POST['ajax']) {
  10. $pindex = max(1, intval($_POST['page'])); //页码
  11. $psize = $_POST['pagesize']; //每页显示数据
  12. $list = $db->fetchall("SELECT * FROM " . $db->tablename('demo') . " WHERE 1=1 ORDER BY id asc LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
  13. $total = $db->getcolumn('demo', array(), "count(*)");
  14. $arr = [
  15. 'msg' => '请求成功',
  16. 'code' => 200,
  17. "list" => $list,
  18. 'total' => $total
  19. ];
  20. echo json_encode($arr);
  21. }elseif(2==$_POST['ajax']){
  22. $pindex = max(1, intval($_POST['page']));
  23. $psize = $_POST['pagesize'];
  24. $list =$db->fetchall("SELECT * FROM ".$db->tablename('demo') ." WHERE 1=1 ORDER BY id asc LIMIT ".($pindex - 1) * $psize.','.$psize);
  25. $total = $db->getcolumn('demo', array(), "count(*)");
  26. $arr = [
  27. 'msg' => '请求成功',
  28. 'code' => 200,
  29. "list" => $list,
  30. 'total' => $total
  31. ];
  32. echo json_encode($arr);
  33. }