SQL Chart Builder

Description

The plugin can create beautiful Local and Google Charts based on your SQL queries, then you can use those charts in any part of your website.
You can use both native wp and non-wp mysql tables in your queries.

  1. Give any name to your report.

  2. Use our preinstalled chart or create new one yourself: choose desired chart type, type sql query,
    enter field names, labels and then press to Publish/Update

  3. You can use multiple SQL queries too. Just split them by ; sign. You can add shortcode argument to SQL query. For example if you
    type “select * from wp_posts where ID>{arg1}” then it you can pass arg1 value to the query with [gvn_schart_2 id=”2″ arg1=”11″] shortcode.

  4. After update/save you will see needed shortcode below there. You can use that shortcode anywhere in your website: in pages, posts, widgets etc.

Website

http://guaven.com/my-sql-charts/

Documentation

http://guaven.com/my-sql-charts/#docs

Bug Submission and Forum Support

http://guaven.com/contact/

Please Vote if you liked our plugin

Your votes really helps us. Thanks.

Screenshots

  • Screenshot 1

  • Screenshot 2

  • Screenshot 3

  • Screenshot 4

Installation

  1. Upload ‘guaven_sqlcharts.zip’ to the ‘/wp-content/plugins/’ directory
  2. Unzip it.
  3. Go to Dashboard/Plugins and Activate the plugin.
  4. Go to “Dashboard/My SQL Charts” to create new charts. You will also see howtouse guide texts there.

Reviews

Great Support

Hi, the solution works great, easy and it is simple.
Wanted to create a donut chart showing a value from the database, where it is displayed as a percentage of the maximum value. Did not know how to get the SQL query correct. Got help in just a couple of days… Great!

Thanks for all of those who made this plugins

I would like to thank you guys for the plugin. I installed it for a small project and without any hassle it works right away.
Very clear notes also given to make sure which axis your are going to put what types of data.

Thank you guys. Keep up the good work.

Read all 4 reviews

Contributors & Developers

“SQL Chart Builder” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

= 2.0.4=

Now you can add custom arguments to the SQL query.

= 2.0.0=

  • New non-Google Local Charts added.

  • Use multiple mysql queries in one graph.

= 1.0.0=

  • Uploaded to WordPress.org

= 1.0.2=

  • Little fixes

= 1.0.5=

  • Added WP 4.7 compatibility

  • Fixed “multiple charts in one page” issue.