I am using Datatables
with server side processing to display data. I have around 10000 rows of data which I would like to limit to make it more readable.
I would like to display only 50 rows of data in the datatable.
$('#dataTable3').dataTable({
"sAjaxSource": "user_data.php",
"sPaginationType":"full_numbers",
"bProcessing": true,
"bPaginate":true,
"iDisplayLength": 20,
"aoColumns": [
{ mData: 'sno' } ,
{ mData: 'dob' } ,
{ mData: 'fullname' },
{ mData: 'email'}]
});
The server side PHP script limits the number of rows to 50 as shown :
SELECT * FROM users order by id desc limit 50
Now, the issue is if I want to search for a particular user, it is searching from the 50 rows of the Datatable. I would like to search on the server side as well. Any idea how to do it ?