模糊搜索（异步）因用smarty模版受限

一生小白 2017-09-12 02:30:18

需要实现的

搜索栏



 <div id="mySidenavt" class="sidenavt">

            <div id="searchBox" >

                <select name="classxuan" id="keyword">

                    <option value="用户名">用户名</option>

                    <option value="用户ID">用户ID</option>

                </select>

                <input type="text" id="keywordt">

                <button class="sousuoniu" onclick="showHint()">提交</button>

            </div>

提交进入JS异步部分



function showHint()

{

    var xmlhttp;

    var str = $('#keyword').val();

    var inp = $('#keywordt').val();

    console.log(str);console.log(inp);



    if (str.length==0)

    {

        $('#txtHint').html();

        return;

    }

    $.ajax({

        type: "get",

        url: "?do=sousuo&leixing="+str+"&str="+inp,

        //data:{"":""},

        //async:false,

        success: function(r){

            console.log(r);

        }

    });

}

业务处理层



  public function sousuo(){



        $fun=new fun();

        $a1=$fun->get('leixing');

        $arr=$fun->get('str');

        if($a1=='用户名'){

            $a=$fun->SelectAdminAuser($arr);

        }else{

            $a=$fun->SelectAdminid($arr);

        }

        $smarty = new Smarty();

        $smarty->assign("users", $a);

        $smarty->assign("iid", $_SESSION['id']);

        $smarty->display('../tpl/add.tpl');

    }

涉及的SQL



    function DeleteAdminAid($aid)

    {



        $sql = "delete from admin where id=:id";

        $pc = [":id" => $aid];

        $sz = $this->query($sql, $pc);

        return $sz;

    }



    //查询admin表中的某用户

    function SelectAdminAuser($auser)

    {

        $sql = "select * from admin where auser= :auser ";

        $pa = [":auser" => $auser];

        $res = $this->query($sql, $pa);

        return $res;

    }