I have a mySQL database with over 7000 columns. I'm wondering if this plug-in can allow me to populate a table with data via query using users input in a search bar?
I want the user to be able to type in one of my index keys into a search bar, which then populates a table below the search bar with data from the mysql database.
Depending on your server's performance and hosting plan, wpDataTables can handle tables with millions of cells. If you have a good hosting plan, and a good server, you would be able to use our plugin, but please note that tables that consist of millions of records will probably load much slower than smaller tables.
If the table is created using a simple query from a single table, like SELECT * FROM myDatabaseTable then you would be able to post that table on the front-end page, and have your customers search for any data in the table.
If you wish to hide the table before search or filtering is applied, you would need to purchase our add-on Powerful Filters as well, but if you don't need to hide the table before filters are applied, you don't need the add-on.
My database has 40k rows or so. But at no point do I want to load the whole table to a page. 20 rows represents the data of one object. I'm hoping to have a search bar where a user can search for any of the objects in my database, which would then populate a table with the 20 rows of data.
You could use filters for this, but I don't believe that's what you're hoping for to achieve.
Maybe the best approach would be to include placeholders and then provide the same table multiple times using different shortcodes.
For example, if a column consists of "Income Statement", "Balance Sheet", or "Cash Flow", you can add a predefined filter to that column %VAR1%.
Then, on one tab (using tabs carousel widget for example), you would add [wpdatatable id=1 var1='Income Statement']; in the other tab you would add [wpdatatable id=1 var1='Balance Sheet'], and so on.
Hello,
I have a mySQL database with over 7000 columns. I'm wondering if this plug-in can allow me to populate a table with data via query using users input in a search bar?
I want the user to be able to type in one of my index keys into a search bar, which then populates a table below the search bar with data from the mysql database.
Thanks!
Hello Jake
Thank you for your interest in wpDataTables.
Depending on your server's performance and hosting plan, wpDataTables can handle tables with millions of cells. If you have a good hosting plan, and a good server, you would be able to use our plugin, but please note that tables that consist of millions of records will probably load much slower than smaller tables.
If the table is created using a simple query from a single table, like SELECT * FROM myDatabaseTable then you would be able to post that table on the front-end page, and have your customers search for any data in the table.
If you wish to hide the table before search or filtering is applied, you would need to purchase our add-on Powerful Filters as well, but if you don't need to hide the table before filters are applied, you don't need the add-on.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thanks for the reply Aleksandar.
Just to clarify a bit as I'm still not 100% sure.
My database has 40k rows or so. But at no point do I want to load the whole table to a page. 20 rows represents the data of one object. I'm hoping to have a search bar where a user can search for any of the objects in my database, which would then populate a table with the 20 rows of data.
Hope this explains what I am trying to do better. An example would be https://ca.finance.yahoo.com/quote/AAPL/financials?p=AAPL
As a user clicks 'Income Statement", "Balance Sheet", or "Cash Flow, the data in the table is updated to reflect what they clicked.
Thanks!
Hello again Jake
You could use filters for this, but I don't believe that's what you're hoping for to achieve.
Maybe the best approach would be to include placeholders and then provide the same table multiple times using different shortcodes.
For example, if a column consists of "Income Statement", "Balance Sheet", or "Cash Flow", you can add a predefined filter to that column %VAR1%.
Then, on one tab (using tabs carousel widget for example), you would add [wpdatatable id=1 var1='Income Statement']; in the other tab you would add [wpdatatable id=1 var1='Balance Sheet'], and so on.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables