Datatables table configuration not working - sort, number of rows, paging, etc.. about datatables HOT 5 CLOSED

Hi, here attached with my setup for ajax without server side processing for configuration.

<script type="text/javascript" src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script> <script type="text/javascript" src="https://cdn.datatables.net/fixedcolumns/3.2.4/js/dataTables.fixedColumns.min.js"></script>

$(document).ready(function() {
$('#table_merchant_list').DataTable( {
"order": [[ 0, "asc" ]],
"pageLength": 5,
"scrollX": true,
"fixedColumns": {
leftColumns: 2
},
// "bProcessing": true,
// "bServerSide": true,
"sAjaxSource": "test/jxindex",
"columns": [
{ data: "id" },
{ data: "name" },
{ data: "city" },
{ data: "tel" },
{ data: "email" },
{ data: "contact" },
{ data: "created_date" },
{ data: "status" },
{ sortable: false, "render": function ( data, type, full, meta ) {
var rowID = full["id"];
return '<a href=/contacts/'+encodeURI(rowID)+' class="btn btn-info">Edit';
}
}
]
} );
} );

function jxIndex($request, $response)
{		
	$config = array(
			'host'     => 'localhost',
			'port'     => '3306',
			'username' => 'xxx',
			'password' => 'xxx',
			'database' => 'xxx' );

	$dt = new Datatables( new MySQL($config) );

	$dt->query("
	Select 
		id, name, city, tel, email, contact, created_date, status
	FROM 
		contact
	");

	echo $dt->generate();
	exit();
}

what i see here is, retrieve whole chunk of data instead of process the parameters from ajax to retrieve require data. So maybe can include in next update.

from datatables.

by turning off this two make it processing by datatables without server side support, which way is better? server side produce require data or give a large chunk of data and let datatables process it?

$('#table_merchant_list').DataTable( {
// "bProcessing": true,
// "bServerSide": true,
...
});

from datatables.

Can you show me your setup? Which version of datatables do you use?
Sorting and pagination etc. must work as expected.

from datatables.

@irvine48 Server side is better when you have to display a lot of results from an expensive query (mysql or another). You will be able to recover only the elements to be displayed according to the pagination parameters (start and length) sent during the server request.
On the other hand if you have little data to display, the client side does the job very well.

For your problem, I think you use incompatible datatables lib version (< 1.10). Try to use last stable version from offical website https://datatables.net/download/

from datatables.

"bServerSide": true,

you should enable this. Otherwise whole data will be loaded.

your setup looks ok to me.

from datatables.