Displaying SQL result data as graphical chart on your blog (shortcodes) or your dashboard with use of Google Chart Tools.
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
[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)
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.
Post a comment on Display SQL Stats
Check out my other WordPress Plugins
Post it at the plugin page: Display SQL Stats
Requires: 2.7 or higher
Compatible up to: 4.3.1
Last Updated: 2015-9-13
Active Installs: 80+
Got something to say? Need help?