WordPress.org

Plugin Directory

Test out the new Plugin Directory and let us know what you think.

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.5.4
Last Updated: 8 months ago
Active Installs: 100+

Ratings

5 out of 5 stars

Support

Got something to say? Need help?

Compatibility

+
=
Not enough data

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

100,1,1
100,1,1