queryParams是bootstrap-table的一个属性功能。
前端代码如下：
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>第二个</title>
.......
</head>
<body>
<input type="text" id="test" placeholder="输入用户id" >
<input type="text" id="test1" placeholder="输入用户名" >
<input type="button" value="找它" id="name">
<table id="table" data-toggle="table"
data-url="<?php echo base_url('work2/page');?>"
data-pagination="true"
data-side-pagination="server"
data-query-params="queryParams" >
<thead>
<tr>
<th data-field="uid" data-filter-control="input">ID</th>
<th data-field="username">用户名</th>
<th data-field="password">用户密码</th>
</tr>
</thead>
</table>
<script>
function queryParams(params) {
var uid = $("#test").val(); //获取文本框的值
var name = $("#test1").val(); //获取文本框的值
params.search1 = uid;
params.search2 = name;
return params;
}
$('#name').click(function () {
$('#table').bootstrapTable('refresh')
})
</script>
</body>
</html>
后端代码如下php：
前端传入后台的是一个对象，前后台一般都以JSON字符串传递，后台只要根据关键字名称取值。
$search = $this->input->get('search2'); //这个是查用户名
$search1 = $this->input->get('search1'); //这个是查uid
if(empty($search) && empty($search1)){
//两个空则输出全部数据
$rows = $this->db->limit($limit,$offset)->get('user1')->result();
$count = $this->db->count_all('user1');
}else if(empty($search) && $search1 != " " ){
//用户名空，查uid
$rows = $this->db->like('uid',$search1)->limit($limit,$offset)->get('user1')->result();
$count = $this->db->like('uid',$search1)->count_all_results('user1');
}
else if(empty($search1) && $search != " " ){
//uid空，查用户名
$rows = $this->db->like('username',$search)->limit($limit,$offset)->get('user1')->result();
$count = $this->db->like('username',$search)->count_all_results('user1');
}else{
//一起查
$rows = $this->db->like('uid',$search1)->like('username',$search)->get('user1')->result();
$count = $this->db->like('uid',$search1)->like('username',$search)->count_all_results('user1');
}
$data = array(
'total'=>$count,
'rows'=>$rows
);
echo json_encode($data);