codeIgniter3.1
$q = $this->db->from($this->table)->where($where)->get()```
$res = $q->result();
$res = $q->row_array();
$sql = $this->db->last_query();
jquery data table
$('#table').dataTable( {
"lengthChange": true,
"searching": true,
"bInfo": true,
"lengthMenu": [[5, 10, 15, -1], [5, 10, 15, "All"]],
"oLanguage": {
"sLengthMenu": "每页显示 _MENU_ 条记录",
"sZeroRecords": "对不起,没有匹配的数据",
"sInfo": "第 _START_ - _END_ 条 / 共 _TOTAL_ 条数据",
"sInfoEmpty": "没有匹配的数据",
"sInfoFiltered": "(数据表中共 _MAX_ 条记录)",
"sProcessing": "正在加载中...",
"sSearch": "全文搜索:",
"oPaginate": {
"sFirst": "第一页",
"sPrevious": " 上一页 ",
"sNext": " 下一页 ",
"sLast": " 最后一页 "
}
}
});