I have built a mysql driven table using wpdatatables and would like to enable users to add rows directly from your table form. However, I would like to manually create/modify the mysql insert/update statement as multiple tables are affected.
What would be the preferred way to achieve this? Thanks.
There is no easy way to achieve this. In this moment you need to hardcode your solution in that file and I can't guarantee that we will not change it. Maybe the simplest way would be to implement hook where you find suitable and then to send it to us for revision. If we find it appropriate we will include it in future versions of our plugin
Hi,
I have built a mysql driven table using wpdatatables and would like to enable users to add rows directly from your table form. However, I would like to manually create/modify the mysql insert/update statement as multiple tables are affected.
What would be the preferred way to achieve this? Thanks.
Navin
Hi Navin,
Thank you for your purchase.
Sorry but can you please describe me a little bit more or send me some example/screenshots so I can give you my suggestion.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi Navin,
We do not have option to edit more than one MySQL table at a time. You can find more on this in our Documentation.
If you are skillful with code and want to try to extend our code so it will be able to do it in your particular case, please find this file:
../wp-content/plugins/wpdatatables/controllers/wdt_ajax_actions.php
and in it function called wdtSaveTableFrontend that is responsible for saving fronted edited data to the database.
Hi Navin,
There is no easy way to achieve this. In this moment you need to hardcode your solution in that file and I can't guarantee that we will not change it. Maybe the simplest way would be to implement hook where you find suitable and then to send it to us for revision. If we find it appropriate we will include it in future versions of our plugin