Dynamic charts from MySQL

[ad_1]

I have an external MySQL database that has forecasts from the year 2020 to 2028. I am trying to create a page that will dynamically load the data for the specific requested forecast. For example, going to page site.com/forecasts/forecast1 would load the chart for the first forecast and site/forecasts/forecast2 would take me to the same page but with the second forecast in the chart

I am currently using the plugin wpDataTables to load the data from the database but I am.unsure on how to create these multiple pages that use the same template

I am happy to do this without additional URLs as well if it’s easier to do it from something like a drop down list.

Hope this makes sense!

Thanks in advance!

[ad_2]

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer