Wordpress tables: Dynamic table from SQL database

Question

I am currently trying to implement a (wordpress) website that shows a table which is dynamically filled from an SQL database based on user input. Let me give a little detail as to what I'm trying to achieve:

I have a big database that contains a list of documents with details such as filer, date, link to document
On my website, I want to show a table with pre-defined columns that is empty at the start
when the user starts to type in values either in one of the pre-defined columns, or in a separate search box (whatever is easier to implement for now), the table should dynamically query the database and show the 10 best matches for that input.

I have no idea where to start, I've seen a couple of (paid) wordpress plugins to achieve this, but I wonder if that's something I could implement myself?

Thanks already for your help

Paul Mitchell · Accepted Answer · 2021-03-14 13:04:14Z

1

For an MVP I'd go with Gravity Forms (for user input) + Gravity View (for displaying data) pair. It will do the job, 100%. After you see what's working and what's not, you might dive into custom development and code something that suits all your needs.

answered Mar 14, 2021 at 13:04

Paul Mitchell

1526 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kim Chi Over a year ago

Thanks Paul, but this looks like a paid solution as well. Like I said I found a few plugins already that seem to be able to do the trick, like wpDataTables, but I was curious if it would be feasible to do myself..

Collectives™ on Stack Overflow

Wordpress tables: Dynamic table from SQL database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related