Code: Select all
$(document).ready(function() {
$('#listax').dataTable({
"bProcessing": true,
"bLengthChange": true,
"bFilter": true,
"bSort": true,
"bInfo": true,
"bAutoWidth": true,
"bServerSide": true,
"sServerMethod": "POST",
"sAjaxSource": "ajax_live/getUsers",
"aoColumns": [
null,
null //put as many null values as your columns
]
});
});
Code: Select all
function getUsers(){
$this->db->select('id,username');
$query = $this->db->get('user');
$data = $query->result();
echo json_encode($data);
}
Code: Select all
[
{"id":"6","username":"Lab23"},
{"id":"11","username":"MaryMM"}
]