1、layui 数据表格添加搜索框
代码如下:
<div class="demoTable">
搜索ID:
<div class="layui-inline">
<input class="layui-input" name="value" id="inputval" autocomplete="off">
</div>
<button type="button" class="layui-btn" data-type="reload">搜索</button>
</div>
2、在方法渲染中添加id用于查询时数据重载
3、给上面搜索框中添加事件(紧接在第二步的下面即可)
代码如下:
$('.demoTable .layui-btn').on('click', function(){
table.reload('idTest', {
where: { //设定异步数据接口的额外参数,任意设
value:$("#inputval").val()
},
page:{
curr:1
}
});
});
4、thinkphp5.1 后台控制器处理:
代码如此下:
/**
* 前台获取数据的接口
* @return [type] [description]
*/
public function getUserData(){
$page = request()->param('page');
$val = request()->param('value');
$limit = request()->param('limit');
$start=$limit*($page-1);
if($val == ''){
$data = UserModel::where('isadmin',0)->limit($start,$limit)->order('create_time','desc')->select();
$count = count(UserModel::where('isadmin',0)->select());
}else{
$data = UserModel::where('isadmin',0)->where('id',$val)->limit($start,$limit)->select();
$count = count(UserModel::where('isadmin',0)->where('id',$val)->select());
}
$msg = [
'code' => 0,
'msg' => '查询成功',
'data'=> $data,
'count' => $count
];
echo json_encode($msg);die;
}