Display SQL Stats

Description

! ! ! S T I L L B E T A ! ! !

Displaying SQL result data as graphical chart on your blog (shortcodes) or your dashboard with use of Google Chart Tools.

Remove plugin

1. Deactivate plugin through the ‘Plugins’ menu in WordPress
2. Delete plugin through the ‘Plugins’ menu in WordPress

It’s best to use the build in delete function of wordpress. That way all the stored data will be removed and no orphaned data will stay.

To do

More translations. Does someone wants to help?

Screenshots

Installation

1. Upload plugin to the /wp-content/plugins/ folder
2. Activate the plugin
3. Edit/Insert SQL Stament in Settings
4. Watch in dashboard

FAQ

Installation Instructions

1. Upload plugin to the /wp-content/plugins/ folder
2. Activate the plugin
3. Edit/Insert SQL Stament in Settings
4. Watch in dashboard

variable #user_login#

Use SQL statements with #user_login# to be replaced by user login on the fly
Eg. SELECT * FROM wp_users WHERE user_login=’#user_login#;’
Will only give one line whith the result of the current user login, where
SELECT * FROM wp_users;
will give you all lines

What about the shortcode?

[dsscode no=x title=”My Title” width=”100%” height=”400″ pagesize=”50″]
x is the number of your SQL statement
title is the title
width, use percent values oder just figures which will be treated as picxel, leave empty for full width of 100%
height=”400″, same as above
pagesize=”50″: The number of rows in each page (only with charttype table)

Can I access other databases than wordpress database?

Yes, but you have the grant your user access (better only select rights) to the database. Than you can use “SELECT * FROM database.table;” as you are used to. Be careful this might cause security risks.

Where can I find more information on Google Charts?

Google Charts

How can I support you?

Post a comment on Display SQL Stats

What is the plugin page?

Display SQL Stats

Do you have other plugins?

Check out my other WordPress Plugins

Where do I post my feedback?

Post it at the plugin page: Display SQL Stats

Reviews

Intuitive, easy to use and does the job

OliviaL September 3, 2016

Interestingly, the plugin does not requires me to specify x and y axes, but somehow it figures out. I guess user would have to put the x axis values in the first column and y axis values in the following columns. I’ve tried several charts-making plugins. I would have to say this is exactly the one I needed. There are some other charts-making plugins are quite popular, but you can barely do anything with their free versions.

Contributors & Developers

Changelog

0.9.5.1(2017/05/15)

• tested with WP 4.7.4
• google source only included in front end if needed by short code

0.9.5(2016/04/13)

• tested with WP 4.5
• replaced deprecated function get_currentuserinfo with wp_get_current_user

0.9.4.2(2015/09/13)

• tested von WP 4.3
• remove more unnecessary warning messages

0.9.4.1(2014/12/22)

• tested von WP 4.1
• remove unnecessary warning message

0.9.4 (2014/12/12)

• default settings: width and height
• new statements are always attached at the end to keep numbering straight.

0.9.3 (2014/12/10)

• More settings for shortcode table (see faqs)
• Added variable #user_login# to be replaced with user login name on the fly (see faqs)

0.9.2 (2014/12/10)

• New chart type: Table (a pure, sortable, smart table)
• added title to shortcode

0.9.1 (2014/07/06)

• typo
• handling of session error during activation

0.9.0 (2014/07/06)

• Now with shortcodes to place your graphics everywhere (read FAQ section)

0.8.2 (2014/05/17)

• fix of small bug on empty values

0.8.1 (2014/04/27)

• deleting of unnecessary warning message

0.8 (2014/04/27)

• allow user with different roles to see results on dashboard

0.7 (2014/02/05)

• adding/removing SQL statements more stylish

0.6.5 (2013/12/27)

• fix bug on automatic detection of column types
• better formatting of debug information

0.6.4 (2013/11/08)

• only enrich header when on dashboard

0.6.3.1 (2013/10/17)

• fixing small bug on min/max values when using more than one barcharts

0.6.3 (2013/10/15)

• placing automatic max/min values on barcharts for better visualisation

0.6.2 (2013/09/14)

• bug fix on emtpy results
• switch charts on/off

0.6.1 (2013/09/14)

• bug fix on wrong date display

0.6 (2013/09/14)

• Check on WordPress 3.6.1
• New chart types: Bar Chart
• auto detecting of column types: date, number, string

0.5 (2013/09/10)

• Use different chart types (Pie Chart, Scatter Chart, Bubble Chart)

0.4 (2013/08/21)

• Use multiple SQL statments and charts

0.3 (2013/08/17)

• Tested with WP 3.6
• New default demo SQL to demonstrate how to insert additional columns

0.2 (2013/04/25)

• NEW: Notepad function to store different SQL statement, ideas or whatever

0.1 (2013/04/16)

• first test version