datatables使用ajax获取数据
前端：
//初始化datatable
var table3 = $('.jiaoshi_lst').DataTable({
"processing": true,
"serverSide": true,
"paging": true,
"ordering": false,
"searching": false,
"select": true,
"ajax": {
url: "get_lst",
type: "get",
dataType: 'json'
},
"columns": [
{
'data': null,
"render": function (data, type, full, meta) {
var div = `<div class="dt-checkbox">
<input type="checkbox" name="select_all" value="`+ data.id + `" id="example-select-all">
<span class="dt-checkbox-label"></span>
</div>`;
return div;
}
},
{ 'data': 'id' },
{ 'data': 'classroom' },
{ 'data': 'area' },
{ 'data': 'loudong' },
{
'data': 'id',
"render": function (data, type, full, meta) {
var div = `<a href="javascript:;" class="btn-sm btn-primary btn-edit mm-margin-right"><i class='fa fa-pencil'></i></a> <a href="javascript:;" class="btn-sm btn-danger btn-del" data-uid="${data}"><i class='fa fa-times'></i></a>`;
return div;
}
},
]
});
后台：
function room_get_lst()
{
$offset = $this->input->get('start');
$pager = $this->input->get('length');
$result = [
'draw' => $this->input->get('draw'),
'recordsTotal' => $this->db->get('shebei')->num_rows(),
'recordsFiltered' => $this->db->get('shebei')->num_rows(),
'data' => $this->db->select('id,area,loudong,classroom')->limit($pager, $offset)->get('jiaoshi')->result_array()
];
$rs = json_encode($result);
die($rs);
echo $rs;
}
