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;
}