Allan,
Is it possible to pass a search string while using the Server side processing. Instead of coming from the user entered data in search box, I would like to pass something like $sSearch = 'Searchthis' .
You certainly can do this. If you have a look at this example for adding another variable to send to the server ( http://datatables.net/1.5-beta/examples/server_side/custom_vars.html ) you'll be able to see how you can write a function which DataTables will use to retrieve data form the server. Here you can either intercept the search string (sSearch) or just define a new variable and use the logic on the server-side to deal with it.
Replies
You certainly can do this. If you have a look at this example for adding another variable to send to the server ( http://datatables.net/1.5-beta/examples/server_side/custom_vars.html ) you'll be able to see how you can write a function which DataTables will use to retrieve data form the server. Here you can either intercept the search string (sSearch) or just define a new variable and use the logic on the server-side to deal with it.
Regards,
Allan
thank you.
Kalyan
This questions seems to answer what I was looking for, but the page with the example is unfortunately no longer available.
I was looking to introduce a value e.g 100033 as in productId = 100033 to use in the MYSQL query for server side processing.
Try this link. I think it is what you are looking for.
http://datatables.net/examples/server_side/custom_vars.html