Ajax与php实现搜索功能

7 篇文章 0 订阅
3 篇文章 0 订阅
HTML代码
<div class="search-bar">
    <input value="" type="text" name="username"  class="input-small" />
    <label class="first txt-green">查询方式:</label>
    <select name="way" id="way"><option value="0">用户id</option><option value="1">用户账号</option><option value="2">VIP等级</option><option value="3">昵称</option></select>
    <label class="txt-green">性别:</label>
    <select name="sex" ><option value="">不限</option><option value="1">男</option><option value="2">女</option></select>
    <label class="txt-green">状态:</label>
    <select name="status"><option value="">不限</option><option value="1">正常</option><option value="0">禁用</option></select>
    <a class="btn-lit" type="submit"  onclick="searchResult()"><span>搜索</span></a>
    <a class="btn-lit" href=""><span>刷新</span></a>
    <a class="btn-lit" type="submit"  onclick="redis()"><span>Redis</span></a>

</div>
 <tr id="caption">
表头区
</tr>
<tr class="show1"> </tr>
<tr class="show"> </tr>
<tr class="showTr">
首次遍历的数据区
</tr>


<div class="cnt-wp xiaoshi">页次:{$pagefunc[1]}/{$pagefunc[4]} 每页22总数{$pagefunc[2]}
      <a href="{$pagefunc[3]['first']}" class="btn-lit"><span>首页</span></a>
        <a href="{$pagefunc[3]['prev']}" class="btn-lit"><span>上一页</span></a>
        <a href="{$pagefunc[3]['next']}" class="btn-lit"><span>下一页</span></a>
        <a href="{$pagefunc[3]['end']}" class="btn-lit"><span>尾页</span></a>
        <input type="text" name="current" id="current" style="width: 35px;height: 20px;margin-top:-2px;">
        <a id="tiao" href="" class="btn-lit"><span>跳转</span></a>
     
</div>
 <div id="fenye" class="cnt-wp" style="display: none;">
        <span id="pageAjax"> 页次:{$pagefunc[1]}/{$pagefunc[4]} 每页22总数{$pagefunc[2]}</span>
        <a class="btn-lit" onclick="pageAjaxFirst()"><span>首页</span></a>
        <a class="btn-lit" onclick="pageAjaxPrev()"><span>上一页</span></a>
        <a class="btn-lit" onclick="pageAjaxNext()"><span>下一页</span></a>
        <a class="btn-lit" onclick="pageAjaxEnd()"><span>尾页</span></a>
        <input type="text" name="current" id="current" style="width: 35px;height: 20px;margin-top:-2px;">
        <a id="tiaoAjax" class="btn-lit"><span>跳转</span></a>
</div>
JQ代码
<script type="text/javascript">
   
    function searchResult()
    {
        var formData = $("#myPost").serialize();
        var caption = $("#caption"); 
        var html = '';
        $('#pageBar').remove();
        $.ajax({    
            type:"post",    
            url:"/user/search/do_search",    
            data:formData, 
            success:success, 
            error: fail
        });  

        function fail() {
            alert('查询条件有误。')
        }
        function success(search){
           if (search != null) {
            var obj =  JSON.parse(search);
            var content = obj[0];
            var nowPage = obj[1];
            var total1 = obj[2];
            var allPage = obj[4];
            $.each(content, function (key, value) {
                html += '<tr class="sousuo"><td class="chk"><input value="" val="' + content[key]['user_id'] + '" type="checkbox"  name="CheckBox[' + content[key]['user_id'] + ']" class="check-box"  /></td>  <td class="txt40 c">' + content[key]['user_id'] + '</td><td class="txt40 c"><a href="/user/user/user_info/user_id/' + content[key]['user_id'] +'"' + '"title="查看资料">'+ content[key]['account'] + '</a></td>' + '<td class="txt40 c">' + content[key]['nickname']+ '</td><td class="txt40 c">' + content[key]['sex'] + '</td><td class="txt80 c">' + content[key]['coin'] + '</td><td class="txt40 c">' + content[key]['tickets'] + '</td><td class="txt40 c">' + content[key]['gem'] + '</td><td class="txt40 c">VIP' + content[key]['vip_id'] + '</td><td class="txt40 c">' + content[key]['user_type'] + '</td> <td class="txt80 c">' + content[key]['register_platform'] + ' </td> <td class="txt80 c">' + content[key]['register_date'] + '</td> <td class="txt80 c">'+content[key]['last_login_time'] + '</td><td class="txt80 c">'+ content[key]['last_login_ip'] + '</td> <td class="txt80 c">'+ content[key]['game_login_times'] +'</td><td class="txt80 c">'+ content[key]['prohibit_flag'] + '</td><td class="icon"><a class="opt" title="编辑" href="/user/user/edit_user/user_id/' + content[key]['user_id'] + '}"><span class="icon-sprite icon-edit"></span></a></td></tr>';
            }); 
            $('.showTr').remove();
            $('.sousuo').remove();
            $('.xiaoshi').remove();
           
            $('.show').after(html);
            } else {
                $('.show').after('<tr>没有数据</tr>');
            } 
           $('#fenye').css('display','block');
           $('#pageAjax').html('页次:'+ nowPage + '/' + allPage +'每页22总数' + total1);
        }   
    }
</script>
PHP代码
	public function do_search()
	{
		$data = Request::instance()->param();
		$search = [];
		$platform = ['0'=>'未知','1'=>'Android','2'=>'iOS','3'=>'PC-WEB'];
		$sex = ['0'=>'未知','1'=>'男','2'=>'女'];
		$user_table = $this->user->selUser();
		$account_table = $this->account->selUser();
	 
		$search = Search::chang2($data, $platform, $sex, $user_table, $account_table);
		echo json_encode($search,JSON_UNESCAPED_UNICODE);
	}

	public function chang($data, $platform, $sex, $user_table, $account_table)
	{
		
		foreach ($pagefunc as $key => $value) {
			 //搜索结果遍历
		}
		return $pagefunc;
	}


  • 1
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值