html代码(用表单form 的method用$GET)
<div class="table-responsive table-bordered"><br> <form id="form" method="get" class="form-inline"> <div class="demo"> <div class="form-group"> <div class="label"> <label for="start"> 提现时间 </label> </div> <div class="field"> <input class="input" id="start" name="start" value=""> <input class="input" id="end" name="end" value=""> </div> </div> <div class="form-group"> <div class="label"> <label for="agentname"> 代理商 </label> </div> <div class="field"> <input class="input" type="text" id="agentname" name="agentname" value=""> </div> </div> <div class="form-group"> <div class="label"> <label for="selete"> 提现状态 </label> </div> <div class="field"> <select class="input" id="selete" name="selete"> <option value="">请选择</option> <option value="通过" >通过</option> <option value="拒绝">拒绝</option> <option value="未审核">未审核</option> </select> </div> </div> <div class="form-group"> <button class="button bg-main float-right" type="submit" id="selecting" name="submit">搜索</button> </div> </div> </form> <table class="table"> <tr> <!-- <th><input type="checkbox"></th>!--> <th style="text-align: center;vertical-align: middle">代理商</th> <th style="text-align: center;vertical-align: middle">级别</th> <th style="text-align: center;vertical-align: middle">提现金额</th> <th style="text-align: center;vertical-align: middle">提现时间</th> <th style="text-align: center;vertical-align: middle">提现IP</th> <th style="text-align: center;vertical-align: middle">提现状态</th> </tr> <volist name="list" id="shenhe"> <tr> <td style="text-align: center;vertical-align: middle;">{$shenhe.agentexamine_name}</td> <td style="text-align: center;vertical-align: middle;">{$shenhe.agentexamine_id}</td> <td style="text-align: center;vertical-align: middle;">{$shenhe.agentexamine_task}</td> <td style="text-align: center;vertical-align: middle;">{$shenhe.agentexamine_time}</td> <td style="text-align: center;vertical-align: middle;">{$shenhe.agentexamine_ip}</td> <td style="text-align: center;vertical-align: middle">{$shenhe.agentexamine_feedback}</td> </tr> </volist> </table> <div id="pageBar" class="pagination" style="float: right"> {$page} </div> </div>PHP代码(注意:在此代码开始最好不要使用if(isset($_get['submit']))这个判断,这句在执行下一页的时候根本不会显示内容,因为下一页后需要再次判断submit。)
public function paging() { $start = $_GET['start']; $end = $_GET['end']; $agentname = $_GET['agentname']; $selete = $_GET['selete']; //取值 $st = array(array('EGT',$start),array('ELT',$end),'AND');// 构造查询条件//判断在时间范围内 $where=array('agentexamine_time' => $st, 'agentexamine_name' => $agentname, 'agentexamine_feedback' => $selete); $M = M("daili_agentexamine");//实例化 $p=getpage($M,$where,1); // 获取查询参数 /* foreach($map as $key=>$val) { $p->parameter .= "$key=".urlencode($val)."&"; }*/ // 分页显示输出 $page = $p->show(); $shenhe = D('daili_agentexamine')->where($where)->limit($p->firstRow.','.$p->listRows)->select(); // 赋值赋值 $this->assign('page', $page); $this->assign('list', $shenhe); $this->display(); }JS代码(之所以写这个代码,是由于当我们进入第二页之后,然后再改变查询条件,这时查询出来的结果不是从第一个开始,而是从第二页开始,所以我们这里还需要在查询的时候在js中把p参数(当前页码)设置为1)
<script type="text/javascript"> $(function(){ //查询 $("#selecting").click(function(){ $("#form").attr("action", "__URL__/paging/p/1"); $("#form").submit(); }); } ); </script>