The quickest way to add WordPress Charts from Database - MYSQL | Iqonic Design the quickest way to add wordpress charts from database - mysql The quickest way to add WordPress Charts from Database – MYSQL 284877 quick

The quickest way to add WordPress Charts from Database – MYSQL

Introduction

In this article, I’ll show you the quickest way to add WordPress charts from Database – MYSQL and PHP.

As we learned earlier what is dynamic data? and what are the commonly used data sources, it’s time to use them. In this blog, we will convert our static chart to dynamic using “SQL Builder” 

  • Follow the below steps for learning how to convert static data charts into dynamic using “SQL Builder” – 

Step 1 –  Selecting the Chart 

the quickest way to add wordpress charts from database - mysql The quickest way to add WordPress Charts from Database – MYSQL Step 1 Select the type of chart

Open the Graphina – WordPress chart plugin and select the chart where you want to display the data of google sheet.

For example, choose the Line chart 

Step 2 – Changing Data option from Manual to Dynamic 

the quickest way to add wordpress charts from database - mysql The quickest way to add WordPress Charts from Database – MYSQL 1 1

Select the chart data option and change the time from “manual” to “dynamic” and we can see the message of the no data available that’s because we have not selected the data source till now. 

Step 3 – Changing Dynamic Data to SQL

the quickest way to add wordpress charts from database - mysql The quickest way to add WordPress Charts from Database – MYSQL 2 4

Select the dynamic data option and change the type to “SQL builder”

the quickest way to add wordpress charts from database - mysql The quickest way to add WordPress Charts from Database – MYSQL Blog img 5

There we will have the space to write the query Now you will see the changes in the chart.

Step 4 – Selection Of table

the quickest way to add wordpress charts from database - mysql The quickest way to add WordPress Charts from Database – MYSQL 3 4

Click on “select mode,” there is an option for the table too. So select a table.

the quickest way to add wordpress charts from database - mysql The quickest way to add WordPress Charts from Database – MYSQL 4 5

Click on “select table,” it will show multiple tables listed in the dropdown list.

the quickest way to add wordpress charts from database - mysql The quickest way to add WordPress Charts from Database – MYSQL Blog img 8

Select one table from the list and then the result can be seen instantly

Step 5 – Final Step of Adding WordPress from Database to SQL

the quickest way to add wordpress charts from database - mysql The quickest way to add WordPress Charts from Database – MYSQL 5 2

In the final step click on the “external” in SQL builder.

the quickest way to add wordpress charts from database - mysql The quickest way to add WordPress Charts from Database – MYSQL 10 3

Now after choosing External Option we will select the data table from the below dropdown. 

the quickest way to add wordpress charts from database - mysql The quickest way to add WordPress Charts from Database – MYSQL 8 1

Click on the option “WordPress 2” and then edit SQL Raw query

the quickest way to add wordpress charts from database - mysql The quickest way to add WordPress Charts from Database – MYSQL 7 2

And then from below in the “Y-axis column”, select that we want to be in the column. Data can be seen from external in our line chart 

the quickest way to add wordpress charts from database - mysql The quickest way to add WordPress Charts from Database – MYSQL 9 3

And then you can see the data of SQL Builder is displayed with the least amount of effort.

the quickest way to add wordpress charts from database - mysql The quickest way to add WordPress Charts from Database – MYSQL Blog img 12

Hereby, all the steps are covered for adding WordPress Charts from Database – SQL 

As we have seen many commonly used data sources in the previous blogs, we will see all of that one by one nicely and how to use it in Graphina.

Conclusion

Now, you have the knowledge on how to create WordPress Charts from Database – MYSQL. You will learn more with us, while you have the nicest product of our Graphina – WordPress Pugin

Make Sure to Subscribe to our newsletter for the latest theme, templates, and tools to let you Structure and Fortunate Web-project without any sedulous dealing with coding skills. Don’t Forget to Subscribe to our Youtube channel to get an instant video tutorial. Follow us on Facebook and Instagram to get Quick Tips, Educational Posts, infographics, and a lot more. 

Was this article helpful?
YesNo