WordPress.org

Plugin Directory

Display SQL Stats

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

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

Requires: 2.7 or higher
Compatible up to: 4.1.5
Last Updated: 2014-12-22
Active Installs: 80+

Ratings

5 out of 5 stars

Support

0 of 1 support threads in the last two months have been resolved.

Got something to say? Need help?

Compatibility

+
=
Not enough data

0 people say it works.
0 people say it's broken.

100,1,1