Displaying SQL result data as graphical chart on the dashboard with use of Google Chart Tools.
Download from WordPress repository.
- adding/removing SQL statements more stylish
- fix bug on automatic detection of column types
- better formatting of debug information
- only enrich header when on dashboard
- fixing small bug on min/max values when using more than one barcharts
- placing automatic max/min values on barcharts for better visualisation
- bug fix on emtpy results
- switch charts on/off
- bug fix on wrong date display
- Check on WordPress 3.6.1
- New chart types: Bar Chart
- auto detecting of column types: date, number, string
- Use different chart types (Pie Chart, Scatter Chart, Bubble Chart)
- Use multiple SQL statments and charts
- Tested with WP 3.6
- New default demo SQL to demonstrate how to insert additional columns
- NEW: Notepad function to store different SQL statement, ideas or whatever
- first test version
Hello, do you intend to update your plugin to be able to use your SQL charts via shortcodes ? I would really enjoy to be able to display charts inside a post/page rather than in the dashboard ?
I think I could give it a try.
Check out the next version
I love your plugin for WordPress. I initially tried to use a view from a different database to the wordpress database but the data did not show up. There were no error codes or anything when I tried this. The only thing that I could think of is that maybe it was the Google Fusion part that could use the View table I had created in the WordPress db.
I finally got smart and granted the wordpress user access to the other database and it worked like you said it would in your FAQs.
Glad, you worked it out for you.
After installing your plugin I get the following error :
Warning: in_array() expects parameter 2 to be array, string given in C:\xampp\htdocs\wordpress2\wp-content\plugins\display-sql-stats\display-stats-admin.php on line 165
Could you help ?
that’s not an error. it’s a warning, it does not influence a correct working of the plugin. this just means that your webserver’s settings are too sensitive