Title: SQL Chart Builder
Author: Guaven Labs
Published: <strong>Èrèlé  25, 2016</strong>
Last modified: Ẹrẹ́nà 13, 2026

---

Ṣàwárí àwọn plugin

![](https://ps.w.org/sql-chart-builder/assets/banner-772x250.png?rev=2343690)

![](https://ps.w.org/sql-chart-builder/assets/icon-256x256.png?rev=2343690)

# SQL Chart Builder

 Láti ọwọ́ [Guaven Labs](https://profiles.wordpress.org/elvinhaci/)

[Ṣe ìgbàsílẹ̀](https://downloads.wordpress.org/plugin/sql-chart-builder.2.3.8.zip)

 * [Àwọn àlàyé](https://yor.wordpress.org/plugins/sql-chart-builder/#description)
 * [Àwọn àgbéyẹ̀wò](https://yor.wordpress.org/plugins/sql-chart-builder/#reviews)
 *  [Ìgbéwọlẹ̀](https://yor.wordpress.org/plugins/sql-chart-builder/#installation)
 * [Ìdàgbàsókè](https://yor.wordpress.org/plugins/sql-chart-builder/#developers)

 [Ìrànlọ́wọ́](https://wordpress.org/support/plugin/sql-chart-builder/)

## Àpèjúwe

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Ìtumọ̀ Yorùbá: ″ arg1=”11Ìtumọ̀ Yorùbá: ″] 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 Ìtumọ̀ Yorùbá: – any single name you want.
 * default_value Ìtumọ̀ Yorùbá: – default value when no any variable chosen by a
   user
 * variable_label Ìtumọ̀ Yorùbá: – Label which would be visible at a form above 
   the chart
 * variable_type Ìtumọ̀ Yorùbá: – 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.

#### Website

[https://guaven.com/my-sql-charts/](https://guaven.com/my-sql-charts/)

#### Documentation

[https://guaven.com/my-sql-charts/#docs](https://guaven.com/my-sql-charts/#docs)

#### Bug Submission and Forum Support

[Contact Page](https://guaven.com/contact/solution-request/)

#### Please Vote if you liked our plugin

Your votes really helps us. Thanks.

### Available Filters

apply_filters( ‘guaven_sqlcharts_table_empty_cell’);

apply_filters(‘guaven_sqlcharts_pre_print_vars’);

apply_filters( ‘guaven_sqlcharts_final_output’);

apply_filters(‘guaven_sqlcharts_rendered_sql’);

## Àwọn àwòrán ìbòjú

[⌊Screenshot 1⌉⌊Screenshot 1⌉[

Screenshot 1

[⌊Screenshot 2⌉⌊Screenshot 2⌉[

Screenshot 2

[⌊Screenshot 3⌉⌊Screenshot 3⌉[

Screenshot 3

[⌊Screenshot 4⌉⌊Screenshot 4⌉[

Screenshot 4

[⌊Screenshot 5⌉⌊Screenshot 5⌉[

Screenshot 5

[[

## Àwọn ìdí

Plugin yìí pèsè 1 ìdí.

 *   My SQL Charts

## Ìgbéwọlẹ̀

 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.

## Àwọn àgbéyẹ̀wò

![](https://secure.gravatar.com/avatar/8f2d58db9fc9555d3b7a171bef4e8146513ab295a7d5ddabc59953485eeb1c2f?
s=60&d=retro&r=g)

### 󠀁[Great lightweight plugin for visualizations](https://wordpress.org/support/topic/great-leightweight-plugin-for-visualizations/)󠁿

 [pamal](https://profiles.wordpress.org/pamal/) Ògún 15, 2023

Great free plugin with very fast support when needed, good performance, lightweight.
Absolutely recommended.My favorite for real time visualizations of information from
wordpress database. I use it instead of embedding Google Looker Studio reports.

![](https://secure.gravatar.com/avatar/705ebfbddc2fc4e45fb4ff16f9374b79bfa45f678e364bc15bbfad01b4ea29e9?
s=60&d=retro&r=g)

### 󠀁[Be careful, wait for update](https://wordpress.org/support/topic/be-careful-wait-for-update/)󠁿

 [eicken71](https://profiles.wordpress.org/eicken71/) Èrèlé 12, 2023 3 àwọn ìdáhùn

Current version of SQL Chart Builder not compatible with PHP 8 and WP 6.1.1. It 
will block your website immediately after installing.

![](https://secure.gravatar.com/avatar/d56433bf9950965b06a0b8f7df030dd4a29bc863d2e5b5f969d56d41aa0bad68?
s=60&d=retro&r=g)

### 󠀁[Highly recommended chart plugin](https://wordpress.org/support/topic/highly-recommened-chart-plugin/)󠁿

 [speleo](https://profiles.wordpress.org/speleo/) Ọwẹ́wẹ̀ 26, 2022

A very powerful yet simple to use solution to display chart data directly from SQL
queries. Support is first class and very quick if required. I road tested a number
of other plugins before choosing SQL Chart Builder and this was definately the leader.
110% recommend.

![](https://secure.gravatar.com/avatar/37ab0ea9af9469ffb02c564d535aeec7e1a2c0cf21a31d9721d120b038443b9b?
s=60&d=retro&r=g)

### 󠀁[how to show values directly on a bar chart](https://wordpress.org/support/topic/how-to-show-values-directly-on-a-bar-chart/)󠁿

 [missvanna](https://profiles.wordpress.org/missvanna/) Ọwẹ́wẹ̀ 23, 2022

how to show values directly on a bar chart

![](https://secure.gravatar.com/avatar/4cbf878c8b25afdc523752ed26c42f035b372024997cbff45c34a3bf0d86b866?
s=60&d=retro&r=g)

### 󠀁[Very easy to create charts directly from DB](https://wordpress.org/support/topic/very-easy-to-create-charts-directly-from-db/)󠁿

 [tnightingale](https://profiles.wordpress.org/tnightingale/) Ògún 11, 2022

This plugin is exactly what I was looking for Ìtumọ̀ Yorùbá: – a way to display 
charts of user data on a membership site. ItÌtumọ̀ Yorùbá: ’s the only plugin I 
could find in the repository that makes charts directly from sql, without requiring
a pro version or adding a ton of other functionality. After a quick run through 
of the SQL tutorials on W3Schools, I was creating just the charts I needed. Will
be using this on other sites.

![](https://secure.gravatar.com/avatar/83a6982227f434e2012c5f67649c72e0820d7421e324503cdaac5f34d517a5b6?
s=60&d=retro&r=g)

### 󠀁[mySql connectivity](https://wordpress.org/support/topic/mysql-connectivity/)󠁿

 [raypierce](https://profiles.wordpress.org/raypierce/) Agẹmọ 6, 2022

This is a great plugin with great support and help. I needed assistance and they
were right there with the solution. Too many of these plugins offer next to nothing
in their free version and then say upgrade to the PRO version to do stuff you really
want to do. This plugin does what those ask a premium for. As soon as this plugin
develops a pro version, IÌtumọ̀ Yorùbá: ’m getting on board!! I tried a bunch of
the chart plugins and this one worked great out of the box. Skip the others.

 [ Ka gbogbo àwọn àgbéyẹ̀wò 21 ](https://wordpress.org/support/plugin/sql-chart-builder/reviews/)

## Àwọn Olùkópa & Olùgbéejáde

“SQL Chart Builder” jẹ́ ètò ìṣàmúlò orísun ṣíṣí sílẹ̀. Àwọn ènìyàn wọ̀nyí ti ṣe 
ìkópa sí plugin yìí.

Àwọn Olùkópa

 *   [ Guaven Labs ](https://profiles.wordpress.org/elvinhaci/)

[Túmọ̀ “SQL Chart Builder” sí èdè rẹ.](https://translate.wordpress.org/projects/wp-plugins/sql-chart-builder)

### Ṣe o nífẹ̀ẹ́ sí ìdàgbàsókè?

[Ṣàwárí koodu](https://plugins.trac.wordpress.org/browser/sql-chart-builder/), ṣàyẹ̀wò
[ibi ìpamọ́ SVN](https://plugins.svn.wordpress.org/sql-chart-builder/), tàbí ṣe 
àgbékalẹ̀ sí [àkọsílẹ̀ ìdàgbàsókè](https://plugins.trac.wordpress.org/log/sql-chart-builder/)
nípasẹ̀ [RSS](https://plugins.trac.wordpress.org/log/sql-chart-builder/?limit=100&mode=stop_on_copy&format=rss).

## Àkọsílẹ̀ àwọn àyípadà

= 2.3.8=
 * Security fix: Patched SQL injection vulnerability in Dynamic Filter 
Variables feature. User-supplied GET parameters are now properly sanitized using
sanitize_text_field() and esc_sql(), and the () bypass loophole has been removed
for user input. Credits: WPScan team for responsible disclosure.

= 2.3.7=
 * Fixed small security issue * More escape/sanitize related security improvements

= 2.3.5=

 * 2 bug fixes on chart rendering X axis values

= 2.3.4=

 * Backend improvements on existing features

= 2.3.3=

 * Fixed: PHP warning issue

= 2.3.2=

 * Added: Enable/disable Stackedness of bar charts

= 2.3.1=

 * Added: Enable/disable Legend section in Charts

= 2.3.0=

 * Added: One new chart Ìtumọ̀ Yorùbá: – Polar Area
 * Added: New small feature Ìtumọ̀ Yorùbá: – 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.

## Àkójọpọ̀ Meta

 *  Ẹ̀yà **2.3.7.2**
 *  Ìgbàgbọ́hùn tó kẹ́yìn **oṣù 3 sẹ́yìn**
 *  Àwọn ìgbéwọlẹ̀ tó ṣiṣẹ́ **500+**
 *  Ẹ̀yà WordPress ** 5.0.0 tàbí ju bẹ́ẹ̀ lọ **
 *  Dánwò dé **6.9.4**
 *  Èdè
 * [English (US)](https://wordpress.org/plugins/sql-chart-builder/)
 * Àwọn àmì
 * [charts](https://yor.wordpress.org/plugins/tags/charts/)[mysql](https://yor.wordpress.org/plugins/tags/mysql/)
   [sql](https://yor.wordpress.org/plugins/tags/sql/)[visualizer](https://yor.wordpress.org/plugins/tags/visualizer/)
 *  [Ìwòye Tó Péye](https://yor.wordpress.org/plugins/sql-chart-builder/advanced/)

## Àwọn ìbò

 3.9 lára àwọn ìràwọ̀ 5.

 *  [  14 5-star reviews     ](https://wordpress.org/support/plugin/sql-chart-builder/reviews/?filter=5)
 *  [  0 4-star reviews     ](https://wordpress.org/support/plugin/sql-chart-builder/reviews/?filter=4)
 *  [  1 3-star review     ](https://wordpress.org/support/plugin/sql-chart-builder/reviews/?filter=3)
 *  [  2 2-star reviews     ](https://wordpress.org/support/plugin/sql-chart-builder/reviews/?filter=2)
 *  [  4 1-star reviews     ](https://wordpress.org/support/plugin/sql-chart-builder/reviews/?filter=1)

[Your review](https://wordpress.org/support/plugin/sql-chart-builder/reviews/#new-post)

[See all reviews](https://wordpress.org/support/plugin/sql-chart-builder/reviews/)

## Àwọn Olùkópa

 *   [ Guaven Labs ](https://profiles.wordpress.org/elvinhaci/)

## Ìrànlọ́wọ́

Nǹkan wà tí o fẹ́ sọ? Ṣé o nílò ìrànlọ́wọ́?

 [Wo àpéjọ ìrànlọ́wọ́](https://wordpress.org/support/plugin/sql-chart-builder/)

## Ṣe ìtọrẹ

Ṣé o fẹ́ ṣe àtìlẹ́yìn fún ìlọsíwájú plugin yìí?

 [ Ṣe ìtọrẹ sí plugin yìí ](https://guaven.com/service/small-thankyou-premium-support-service/)