Could someone help me learn if DataTables is right for my needs?

thirtywest · March 2022

Hello, first time posting.

Can someone tell me if this product is worth the time to learn for the following needs:

I have a mySQL query I've been running through a simple php file and exporting to excel.
I have a few users that do NOT need to edit the data there--only view; and
be able to do multi-column sorting; and
export those results to something like a .csv or .xls. with a download button
I need to be able to access this through a normal browser and include a close/signoff/exit button as well.

Any help would be most appreciated.

Thanks!

kthorngren · March 2022

Datatables can help with all these:

Use an Ajax query to the server to fetch the data. Here are some Ajax examples.
Datatables will display the table. You can use the Editor if you need editing capabilities for some users.
Supports multi column sorting. See the orderMulti docs for details.
The Buttons extension supports CSV, Excel and other export options. See the examples page.
"include a close/signoff/exit button as well." Not sure what this specifically means but you can create Custom buttons to perform any action you want.

Please post any questions.

Kevin

Answers