首页 > 代码库 > 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();    }