Hi youthak,
Thank you for the purchase.

It is possible to create wpDataTable by using do_shortcode WordPress function. Like that you can dynamically change PHP variable that you will pass to the wpDataTable as %var1%.

That would look like something like this:

do_shortcode('[wpdatatable id=1 var1=' . $variable . ']');

Hi youthak,

This is the way how you can change %var1% before calling do_shortcode. You just have to change $variable based on some your logic that you will use. You just need to create custom page template where you will assign some value to $variable and then use do_shortcode function to create wpDataTable with dynamic %var1%.

"Also is it possible to create datachart from mysql query in php code?"
- I didn't understand this quite well. Can you please explain this in more details?

Hi youthak,

When you make wpdatatable with dynamical variable  var1, you have to make the chart from that table and turn on "Charts data filtering" on Data range tab. (attachment)

Best regards.

Hi youthak,

When this "Charts data filtering" is ticked, you must have table and chart in the same post or page.

If you don't want table to be visible, you can hide with CSS.

Best regards