DataTables - Server-side
by abhijeetkarve
HTML
<script src="//cdn.datatables.net/1.10.6/js/jquery.dataTables.js"></script>
<link rel="stylesheet" href="//cdn.datatables.net/1.10.6/css/jquery.dataTables.css">
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-mockjax/1.6.2/jquery.mockjax.min.js"></script>
<table id="example" class="display" cellspacing="0" width="100%">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
</tr>
</thead>
</table>
JavaScript
// FOR DEMONSTRATION ONLY
// AJAX emulation
$.mockjax({
url: '/test/0',
responseTime: 200,
response: function(settings){
var val = settings.data.start;
this.responseText = {
data: {
data: [],
draw: settings.data.draw,
recordsTotal: 1000,
recordsFiltered: 1000
}
};
for(var i = 0; i < settings.data.length; i++){
this.responseText.data.data.push(["A" + (i + settings.data.start + 1), i]);
}
}
});
var table = $("#example").DataTable({
processign:true,
serverSide: true,
ajax: {
url: "/test/0",
dataSrc: function(json){
json.draw = json.data.draw;
json.recordsTotal = json.data.recordsTotal;
json.recordsFiltered = json.data.recordsFiltered;
return json.data.data;
}
}
});