How can I use column filtering in PHP project
How can I use column filtering in PHP project
boxygen
Posts: 1Questions: 1Answers: 0
Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem:
https://datatables.net/extensions/fixedheader/examples/options/columnFiltering.html
On this page I can't see the HTML code.
Secondly how can I use this with a SQL query to fetch data from Database and show in the table
I am using PHP
Answers
Here is a guy who does this all using Javascript / jQuery:
https://datatables.net/forums/discussion/77547/creating-a-custom-filter-on-column-level#latest
Of course you can also do this with HTML. That's how I am doing it. My stuff is extremely complex. Won't post it here ... Just search the forum, you should find somethng.
Fetch data from database:
I am doing this exclusively using Editor which costs a small license fee. Editor will also provide full editing support that you might not need here, but on other occasions. I am using Editor for read-only data tables and also for editable data tables. You may also do read-only using the so called ssp class. That's a bit more cumbersome. Good luck.
That's odd. I'll look into that. For the time being, just right click and "View source". It is just a regular HTML table.
In addition to rf1234's comment, I'd suggest you read the Ajax section of the manual to discover how to use Ajax sourced data with DataTables (the Ajax source can be PHP or any other server-side environment).
Allan