描述

! ! ! 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

Deactivate plugin through the ‘Plugins’ menu in WordPress
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?

螢幕截圖

Showing chart in dashboard
Settings

安裝

Upload plugin to the /wp-content/plugins/ folder
Activate the plugin
Edit/Insert SQL Stament in Settings
Watch in dashboard

常見問題

Installation Instructions

Upload plugin to the /wp-content/plugins/ folder
Activate the plugin
Edit/Insert SQL Stament in Settings
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?

評價

OliviaL 2016年9月3日

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.

閱讀全部2個評價

貢獻者及開發者

“Display SQL Stats” 是一個開源的軟體。以下的人對這個外掛作出了貢獻。

Juergen Schulze

將 Display SQL Stats 外掛本地化為台灣繁體中文版。

對開發相關資訊感興趣？

任何人均可瀏覽程式碼、查看 SVN 存放庫，或透過 RSS 訂閱開發記錄。

修改日誌

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

描述