SQL Chart Builder

Beskrivelse

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.

Pie chart, Donut chart, Line chart, Bar chart, Column chart, Area chart

How to use

  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 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.

  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.

  5. Just check «Show table-view data below the graph» in order to get table-list view below each chart.

  6. Using «Dynamic Filters» you can create dynamic variables inside SQL code. It also creates corresponding dynamic input form above each chart.

Dynamic filters

Use this format: variable_name~default_value~variable_label~variable_type | variable_name~default_value~variable_label~variable_type etc.

  • variable_name – any single name you want.
  • default_value – default value when no any variable chosen by a user
  • variable_label – Label which would be visible at a form above the chart
  • variable_type – number, text or date
  • ~ is a separator between variable elements.
  • | is a separator between variables

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.

Webside

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

Dokumentasjon

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

Bug Submission and Forum Support

Contact Page

Please Vote if you liked our plugin

Your votes really helps us. Thanks.

Skjermskudd

  • Screenshot 1

  • Screenshot 2

  • Screenshot 3

  • Screenshot 4

  • Screenshot 5

Blokker

Denne utvidelsen gir 1 blokk.

  • My SQL Charts

Installasjon

  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.

Vurderinger

2. mars, 2022
I created report that look so very professional with this plugin. My client is so so happy and say it the best report they seen in their career. If you know how to massage this plugins you will get something that will make your client fall in love with your work.
3. mars, 2022
It's easy to use and produces attractive graphs from simple SQL queries... but it cannot properly display any text on the axis labels that contains "foreign" characters. The name "Röntgen", for example, will be displayed "R & ouml;ntgen", with HTML code descriptions of o-umlaut rather than with the actual ö character. This is a serious defect... but there are no other equivalent graphing plugins available, so one must make do! It's incredibly easy to use and it produces attractive graphs from simple SQL queries: a lot of other plugins tend to require you to supply data in separate text or CSV files. I did once have a problem with the graphs not displaying UTF-8 characters properly on the axes of graphs (so things like 'Röntgen' would be displayed as "R & ouml;ntgen", with HTML code descriptions of o-umlaut rather than with the actual ö character. But that got fixed around version 2.2.0. With that fix in place, there isn't a tool quite like it anywhere else and it has made my personal website much, much more useful in consequence. The support I received back in 2019 was a bit iffy -but the support has improved by leaps and bounds since then, and they would now appear to be responsive and helpful, which is great. Because of the improved support and the fixing of the UTF-8 issue, I've increased my rating for the plugin from an acceptable 3-star to a 'I'm a fan' 5-star one, as of March 3rd 2022.
1. november, 2019
Unfortunately, this plugin is only useful for very specific use-cases, because it supports ONLY two database fields (i.e. X and Y axis, which almost never makes sense for the supported pie chart type but anyway). The external MySQL connector works well, so that part is great, but the shortcode doesn't output the charts and the "preview" doesn't honor the width and height settings. So, this could have been great, with just a little more love and attention. Ah well.
7. mai, 2019
I installed this plugin as it is one of the only (free) ones that lets you populate the charts through SQL in stead of importing data. The charts themselves work fine, and I like the fact that it works with shortcodes. However... 1) when creating the charts, it does not take into account the custom colour, height and width; the outupt is always a huge chart, changing colour all the time 2) when installing the plugin, the Tabs plugin from SiteOrigin stops working. It still displays, but it becomes impossible to modify or add any Tabs. SiteOrigin says the problem lies with the SQL Chart plugin. As I did pay for SiteOrigin, the choice of which one to stop using was swiftly made...
9. april, 2019
Intuitive, provides all the necessary components for linking with other plugins, and the customer support was second to none. He/she/they quickly debugged the code and identified the issue (another plugin) immediately.
Les alle 15 vurderinger

Bidragsytere og utviklere

“SQL Chart Builder” er programvare med åpen kildekode. Følgende personer har bidratt til denne utvidelsen.

Bidragsytere

Endringslogg

= 2.3.1=

  • Added: Enable/disable Legend section in Charts

= 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=

  • Small improvements

= 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=

  • Uploaded to WordPress.org

= 1.0.2=

  • Little fixes

= 1.0.5=

  • Added WP 4.7 compatibility

  • Fixed «multiple charts in one page» issue.