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.
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?
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.
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