lavavel ajax分页

来源：互联网发布：求购湖南快乐十分源码编辑：程序博客网时间：2024/04/30 08:33

@Laravel框架

@Ajax无刷新分页(简单7步骤)

public function page()

{

//1、查询数据库总条数

$count = count(Db::table('email')->get());

//2、设置每页显示条数

$rev = '4';

//3、求总页数

$sums = ceil($count/$rev);

//4、求单前页

$page = Input::get('page');if(empty($page)){$page = "1";}

$prev = ($page-1)>0?$page-1:1;$next = ($page+1)<$sums?$page+1:$sums;

//6、求偏移量

$offset = ($page-1)*$rev;

//7、sql查询数据库

$data = Db::select("select * from email limit $offset,$rev");

/*

@需要替换的部分页面

*/

public function page_pro(){……前面的一样……return view('page.page_pro', ['data'=>$data,'prev'=>$prev,'next'=>$next,'sums'=>$sums,'pp'=>$pp,'page'=>$page]);}}

html页面

<!DOCTYPE html><html lang="en"><head><meta charset="UTF-8"><title>Document</title><script src="Js/jquery.min.js"></script></head><body><div id="box"><!-- 第一部分 --><a href="javascript:void(0)" onclick="page(1)">首页</a><a href="javascript:void(0)" onclick="page(<?php echo $prev ?>)">上一页</a><a href="javascript:void(0)" onclick="page(<?php echo $next ?>)">下一页</a><a href="javascript:void(0)" onclick="page(<?php echo $sums ?>)">尾页</a><br /><!-- 第二部分 -->@foreach($pp as $key=>$val)@if($val == $page){{$val}}@else<a href="javascript:void(0)" onclick="page({{$val}})">{{$val}}</a>@endif@endforeach<!-- 表 --><table border="1" id=""><tr><td>序号</td><td>名称</td><td>时间</td></tr>@foreach($data as $val)<tr><td>{{$val->email_id}}</td><td>{{$val->email_name}}</td><td>{{$val->email_time}}</td></tr>@endforeach</table></div></body></html><script>/*@分页*/function page(page){$.ajax({type:"get",url:"page_pro",data:{page:page},success:function(msg){if(msg){$("#box").html(msg)}}})}</script>page_pro.blade.php页面：与“page.blade.php”中 div 包着的部分一样

0 0