Turn Your SQL Queries to Beautiful Dynamic Charts- Pie, Line, Area, Donut, Bar Charts with date/input filters.
The plugin can create beautiful 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.
Give any name to your report.
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
You can use multiple SQL queries too. Just split them by ; sign. You can also 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.
After update/save you will see needed shortcode below there. You can use that shortcode anywhere in your website: in pages, posts, widgets etc.
Just check “Show table-view data below the graph” in order to get table-list view below each chart.
Using “Dynamic Filters” you can create dynamic variables inside SQL code. It also creates corresponding dynamic input form above each chart.
Use this format: variable_name~default_value~variable_label~variable_type | variable_name~default_value~variable_label~variable_type etc.
For example if to put
limit_tag~10~Count~number | post_date_tag~2010-07-05 17:25:18~Date Published~date,
then you can use this SQL code
select * from wp_posts where post_date<{post_date_tag} limit {limit_tag}
in SQL CODE field.
{post_date_tag} and {limit_tag} would be replaced with dynamic variables.
So, the plugin will automatically recognize it and put corresponding selectboxes above the chart.
https://guaven.com/my-sql-charts/
https://guaven.com/my-sql-charts/#docs
Your votes really helps us. Thanks.
= 2.3.5=
= 2.3.4=
= 2.3.3=
= 2.3.2=
= 2.3.1=
= 2.3.0=
Added: One new chart – Polar Area
Added: New small feature – Round Y Axis tick values
Improvement: Hashing DB Remote password
= 2.2.2=
Added: Custom color support for PIE charts
Added: Insert custom chart parameters via Shortcode attributes
= 2.2.1=
= 2.2.0=
Added width-height support
Added “Zero point” to line chart
Bugfixes
= 2.1.2=
New feature: Remote Database Connection
Setting custom & fixed colors for charts
Small improvement in table-view component
= 2.1.1=
Fixed small bug in Area Charts
Chart library has been updated to the latest version
= 2.1.0=
Dynamic filters added: You can use dynamic date/number/text filters at frontend.
Table-view support added.
= 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=
= 1.0.2=
= 1.0.5=
Added WP 4.7 compatibility
Fixed “multiple charts in one page” issue.