HTML代码
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<input type="text" id="word" value="{$data.word}">
<input type="button" value="搜索" onclick="page(1)">
<table>
<tr>
<th>ID</th>
<th>账号</th>
<th>密码</th>
<th>手机</th>
<th>登录时间</th>
<th>登录次数</th>
<th>状态</th>
</tr>
{volist name="data.list" id="v"}
<tr>
<td>{$v.id}</td>
<td>{$v.uname}</td>
<td>{$v.pwd}</td>
<td>{$v.phone}</td>
<td>{$v.login_time|date="Y-m-d H:i:s",###}</td>
<td>{$v.login_num}</td>
<td>
{switch name="$v.is_on" }
{case value="1"}正常{/case}
{case value="2"}锁定{/case}
{/switch}
</td>
</tr>
{/volist}
</table>
<a href="javascript:void(0);" onclick="page({$data.home_page})">首页</a>
<a href="javascript:void(0);" onclick="page({$data.prev_page})">上一页</a>
<a href="javascript:void(0);" onclick="page({$data.next_page})">下一页</a>
<a href="javascript:void(0);" onclick="page({$data.last_page})">尾页</a>
<script src="__STATIC__/js/jquery.js"></script>
<script>
function page(obj){
//获取搜索框的值
var word = $("#word").val();
if(word==''){
$.get("{:url('Three/home')}?page="+obj,function(data){
$("body").html(data);
})
}else{
//有值
$.get("{:url('Three/home')}?page="+obj+"&word="+word,function(data){
$("body").html(data);
})
}
}
</script>
</body>
PHP代码
//展示页面 public function home(){ //接收关键字 $word = Request::instance()->param('word'); if(empty($word)){ //查询所有的数据 //求出总条数 $count = Db::table("user")->count(); //设置每页显示的条数 $length = 2; //求出来总页数 $zong_page = ceil($count/$length); //接收当前页 $page = Request::instance()->param('page'); $current_page = empty($page) ? 1 : $page; //求出偏移量 $limit = ($current_page-1)*$length; //查询 $data = Db::table("user")->limit($limit,$length)->select(); }else{ //根据关键字实现多条件查询 //求出总条数(满足条件的) $count = Db::table("user")->where('uname|phone','like',"$word%")->count(); //设置每页显示的条数 $length = 2; //求出来总页数 $zong_page = ceil($count/$length); //接收当前页 $page = Request::instance()->param('page'); $current_page = empty($page) ? 1 : $page; //求出偏移量 $limit = ($current_page-1)*$length; //查询 $data = Db::table("user")->where('uname|phone','like',"$word%")->limit($limit,$length)->select(); } //判断页码 $arr['list'] = $data; $arr['home_page'] = 1; $arr['prev_page'] = $current_page-1 <= 1 ? 1 : $current_page-1; $arr['next_page'] = $current_page+1 >= $zong_page ? $zong_page : $current_page+1; $arr['last_page'] = $zong_page; $arr['word'] = empty($word) ? null : $word; return view('home',['data'=>$arr]); }