As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
I'd like to generate a table that loads from mysql database, but I want to get the data in the querystring part of url, and use that as a filter for the table.
so i will be sending an email with a link like
http;//example.com/tableofyourimages.php?id=123456
and then the wptable would load using the id=123456 as a condition in the SQL. something like
select * from imagetable where id={querystring:id}
possible?
Hello larrysm.
I'm not sure I understand what you're trying to accomplish.
Is ID located somewhere in the table, in the database?
Can you show me an example, maybe provide some screenshots and instructions how I could test this locally, and I'll be able to provide a better answer then?
Best regards.
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
yes, i would make the query string name and value match a field and a value for the same database table that the form is populating from
so for example my database table has a column for "customer_id" with values that are numeric ids of the customers.
then i would email out to people a link that would filter their data accordingly . the link url would be
http://whatever/page.php?customer_id=123456
thus when clicked you would only see data that is related to that customer_id
wptable would need to check the query string first before sending the SQL to the db to fetch the data.
https://www.screencast.com/t/KkntNLXkl
Hello again larrysm.
I believe Pre-filtering through URL could help you out here.
The column has a number assigned to it, so you can add the filter like:
http://whatever/page.php/?wdt_column_filter[1]=123456
The URL key that will be parsed by the wpDataTables is “wdtColumnFilter[KEY]” where the KEY is either a zero-based numerical index of the column you want to filter, or an initial header of the column (header or the CSV or Excel table, or MySQL column header for MySQL-based column header).
Please check out the documentation in the link provided above and let me know if this helps.
Best regards.
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
excellent. thanks. you guys are very clever and helpful.
You're welcome larrysm.
Thank you, we do our best.
If you have any further questions or issues, please feel free to reach out to us, and we'll gladly help.
Best regards.
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