首页 > 代码库 > YOURPHP的查询
YOURPHP的查询
html代码
<?php print_r($ser[‘searchtype‘]);?> <select name="searchtype"> <option value=http://www.mamicode.com/"name" <if condition="$ser[‘searchtype‘] ==name">selected="selected"</if>>姓名</option> <option value=http://www.mamicode.com/"mobile" <if condition="$ser[‘searchtype‘] ==mobile">selected="selected"</if>>手机</option> </select> <select name="status" id="status"> <option value=http://www.mamicode.com/"null" <if condition="$ser[‘status‘]===‘null‘">selected="selected"</if>>完成</option> <option value=http://www.mamicode.com/"1" <if condition="$ser[‘status‘] ==‘1‘">selected="selected"</if>>是</option> <option value=http://www.mamicode.com/"0" <if condition="$ser[‘status‘] ==‘0‘">selected="selected"</if>>否</option> </select> <select name="sort"> <option value=http://www.mamicode.com/"asc" <if condition="$ser[‘sort‘] ==asc">selected="selected"</if>>时间递增</option> <option value=http://www.mamicode.com/"desc" <if condition="$ser[‘sort‘] ==desc">selected="selected"</if>>时间递减</option> </select> <select name="listRows"> <option value=http://www.mamicode.com/"15" <if condition="$ser.listRows ==5">selected="selected"</if>>15{:L(‘listRows‘)}</option> <option value=http://www.mamicode.com/"20" <if condition="$ser.listRows ==20">selected="selected"</if>>20{:L(‘listRows‘)}</option> <option value=http://www.mamicode.com/"50" <if condition="$ser.listRows ==50">selected="selected"</if>>50{:L(‘listRows‘)}</option> <option value=http://www.mamicode.com/"100" <if condition="$ser.listRows ==100">selected="selected"</if>>100{:L(‘listRows‘)}</option> </select>
php代码
public function index(){ $m = M(‘service‘); //**** 查询条件 $ser[‘keywords‘] =$_GET[‘keywords‘]; $ser[‘searchtype‘]= $_GET[‘searchtype‘]; $ser[‘status‘] = $_GET[‘status‘]; $ser[‘listRows‘] = $_GET[‘listRows‘]; $ser[‘sort‘] = $_GET[‘sort‘]; $mo = URL(‘Admin-Service/index‘); $url = $mo.‘&keywords=‘.$ser[‘keywords‘].‘&searchtype=‘.$ser[‘searchtype‘].‘&status=‘.$ser[‘status‘].‘&sort=‘.$ser[‘sort‘].‘&listRows=‘.$ser[‘listRows‘].‘&p=‘; $p = $_GET[‘p‘]; //echo $url; //******分页 $res = $m->select(); // 共有几条 $totalNum = count($res); // 共有多少页 $pagesize = ‘3‘; ///$ser[‘listRows‘] $totalpage1 = $totalNum/$pagesize; $totalpage = intval($totalpage1); if($totalpage1 !=0){ $totalpage +=1; } if($totalpage<=0){ $totalpage = 1; } //echo $totalpage; //当前页 $nowpage = $p; if(empty($p)){ $nowpage = 1; } $nowsize = $nowpage*$pagesize-$pagesize;; //echo $nowpage; //第一页 $firstpage = $url.‘1‘; //上一页 $prevpage = $nowpage-1; if($prevpage<=0){ $prevpage = 1; } $prevpageUrl = $url.$prevpage; //下一页 $nextpage = $nowpage+1; if($nextpage>=$totalpage){ $nextpage = $totalpage; } $nextpageUrl = $url.$nextpage; //尾页 $lastpage = $url.$totalpage; //******分页结束 $list = $m->limit($nowsize,$pagesize)->select(); foreach($list as $k=>$v){ $list[$k][‘problem‘] = $this->config_problem(‘1‘,$v[‘problem‘]); } $page = ‘<a class="a1">共‘.$totalNum.‘条 当前‘.$nowpage.‘/‘.$totalpage.‘页</a>‘; $page .= ‘<a href="http://www.mamicode.com/‘.$firstpage.‘">第一页</a>‘; $page .= ‘<a href="http://www.mamicode.com/‘.$prevpageUrl.‘">上一页</a>‘; $page .= ‘<a href="http://www.mamicode.com/‘.$nextpageUrl.‘">下一页</a>‘; $page .= ‘<a href="http://www.mamicode.com/‘.$lastpage.‘">尾页</a>‘; //$page = ‘30条第一页上一页12下一页最后一页‘; //print_r($ser[‘searchtype‘]); $this->assign(‘ser‘,$ser); $this->assign(‘page‘,$page); $this->assign(‘list‘,$list); $this->display(); }
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。