<!DOCTYPE html>
<html><head> <meta charset="utf-8"> <title></title></head><body> <input type="text" id="word" value="{$data.word}"> <input type="button" value="搜索" οnclick="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);" οnclick="page({$data.home_page})">首页</a>
<a href="javascript:void(0);" οnclick="page({$data.prev_page})">上一页</a><a href="javascript:void(0);" οnclick="page({$data.next_page})">下一页</a><a href="javascript:void(0);" οnclick="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></html>//展示页面
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]);
}