Serverside processing....how to retrieve specific records from the database table

saleemkh

Hi,

How can the datatable be filled from the records of a database table depending on where clause. e.g (all records where field1='5')

Thank you.

systematical

You should give a better description and code samples. Have you looked at server-side processing:
http://datatables.net/release-datatables/examples/data_sources/server_side.html

saleemkh

I am new to datatables but I have used server_side datatables already. Now my requirement is that I want to fill the datatable using server_side processing
[code]
$(document).ready(function() {
$('#example').dataTable( {
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "../server_side/scripts/server_processing.php"
} );
} );
[/code]

but I don't want to get all the records from database table. Rather some records matching SQL where clause.

Thank you

tangerine

Your "server_processing.php" file should include the necessary query.

saleemkh

Thank you. Its working...:)