Search box then display datatable with results

funkeychikkin

Hi,

Is this possible to do, I would like to search my database for a term and then that query be the source of data for the datatable which I will then display on the page? Can anyone advise on the best way to do this if possible?

Also if the user then searches again for something different it would be able to get that new data for the datatable?

Sorry if this is simple, I am new to web development. Thanks for any help :)

fbas

http://datatables.net/release-datatables/examples/data_sources/server_side.html

aaronw

I'm not sure what you mean. Do you mean that a user will search for 'Contoso' and then you will query a database called 'Contoso' ?

funkeychikkin

No the query would just be SELECT * FROM table WHERE column_a = 'search_term' or something like that.

It is just using that as the seed for the datatable that I am struggling with and all on the same page.

psharp

It's kind of the meat and potatoes part of the datatables plugin, especially when dealing with server side data requests.

Here is a better example that will show how to set up a query by column, based on user input.
http://www.datatables.net/examples/api/multi_filter.html