Title: Display SQL Stats Author: Juergen Schulze Published: 16 Tháng 4, 2013 Last modified: 15 Tháng 5, 2017 --- Tìm kiếm plugin Plugin này **chưa được cập nhật với 3 phiên bản mới nhất của WordPress**. Nó có thể không được hỗ trợ và bảo trì, và có thể xung đột với các phiên bản WordPress mới nhất. ![](https://s.w.org/plugins/geopattern-icon/display-sql-stats.svg) # Display SQL Stats Bởi [Juergen Schulze](https://profiles.wordpress.org/1manfactory/) [Tải về](https://downloads.wordpress.org/plugin/display-sql-stats.zip) * [Chi tiết](https://vi.wordpress.org/plugins/display-sql-stats/#description) * [Đánh giá](https://vi.wordpress.org/plugins/display-sql-stats/#reviews) * [Cài đặt](https://vi.wordpress.org/plugins/display-sql-stats/#installation) * [Nhà phát triển](https://vi.wordpress.org/plugins/display-sql-stats/#developers) [Hỗ trợ](https://wordpress.org/support/plugin/display-sql-stats/) ## Mô tả ! ! ! 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 1. Deactivate plugin through the ‘Plugins’ menu in WordPress 2. 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? ## Ảnh màn hình [⌊Showing chart in dashboard⌉⌊Showing chart in dashboard⌉[ Showing chart in dashboard [⌊Thiết lập⌉⌊Thiết lập⌉[ Thiết lập ## Cài đặt 1. Upload plugin to the `/wp-content/plugins/` folder 2. Activate the plugin 3. Edit/Insert SQL Stament in Settings 4. Watch in dashboard ## Hỏi đáp ### 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](https://developers.google.com/chart/) ### How can I support you? Post a comment on [Display SQL Stats](http://1manfactory.com/dss) ### What is the plugin page? [Display SQL Stats](http://1manfactory.com/dss) ### Do you have other plugins? Check out my other [WordPress Plugins](https://profiles.wordpress.org/1manfactory) ### Where do I post my feedback? Post it at the plugin page: [Display SQL Stats](http://1manfactory.com/dss) ## Đánh giá ![](https://secure.gravatar.com/avatar/0f90d067a229711e82bf72e9185878da93dd6c08343205cf0b5a836f5c883991? s=60&d=retro&r=g) ### 󠀁[Intuitive, easy to use and does the job](https://wordpress.org/support/topic/intuitive-easy-to-use-and-does-the-job/)󠁿 [OliviaL](https://profiles.wordpress.org/olivial/) 3 Tháng 9, 2016 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. [ Đọc tất cả 2 đánh giá ](https://wordpress.org/support/plugin/display-sql-stats/reviews/) ## Người đóng góp & Lập trình viên “Display SQL Stats” là mã nguồn mở. Những người sau đã đóng góp vào plugin này. Những người đóng góp * [ Juergen Schulze ](https://profiles.wordpress.org/1manfactory/) [Dịch “Display SQL Stats” sang ngôn ngữ của bạn.](https://translate.wordpress.org/projects/wp-plugins/display-sql-stats) ### Muốn tham gia phát triển? [Duyệt code](https://plugins.trac.wordpress.org/browser/display-sql-stats/), check out [SVN repository](https://plugins.svn.wordpress.org/display-sql-stats/), hoặc theo dõi [nhật ký phát triển](https://plugins.trac.wordpress.org/log/display-sql-stats/) qua [RSS](https://plugins.trac.wordpress.org/log/display-sql-stats/?limit=100&mode=stop_on_copy&format=rss). ## Nhật ký thay đổi #### 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 ## Meta * Phiên bản **0.9.5.1** * Cập nhật lần cuối **9 năm trước** * Số lượt cài đặt **10+** * Phiên bản WordPress ** 2.7 hoặc cao hơn ** * Đã kiểm tra lên đến **4.7.35** * Ngôn ngữ * [English (US)](https://wordpress.org/plugins/display-sql-stats/) * Thẻ * [chart](https://vi.wordpress.org/plugins/tags/chart/)[charts](https://vi.wordpress.org/plugins/tags/charts/) [google chart](https://vi.wordpress.org/plugins/tags/google-chart/)[mysql](https://vi.wordpress.org/plugins/tags/mysql/) * [Nâng cao](https://vi.wordpress.org/plugins/display-sql-stats/advanced/) ## Đánh giá 5 trên 5 sao. * [ 2 5-star reviews ](https://wordpress.org/support/plugin/display-sql-stats/reviews/?filter=5) * [ 0 4-star reviews ](https://wordpress.org/support/plugin/display-sql-stats/reviews/?filter=4) * [ 0 3-star reviews ](https://wordpress.org/support/plugin/display-sql-stats/reviews/?filter=3) * [ 0 2-star reviews ](https://wordpress.org/support/plugin/display-sql-stats/reviews/?filter=2) * [ 0 1-star reviews ](https://wordpress.org/support/plugin/display-sql-stats/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/display-sql-stats/reviews/#new-post) [Xem tất cả đánh giá](https://wordpress.org/support/plugin/display-sql-stats/reviews/) ## Những người đóng góp * [ Juergen Schulze ](https://profiles.wordpress.org/1manfactory/) ## Hỗ trợ Có điều gì muốn nói? cần giúp đỡ? [Xem diễn đàn hỗ trợ](https://wordpress.org/support/plugin/display-sql-stats/) ## Ủng hộ Bạn có muốn hỗ trợ vào sự phát triển của plugin này? [ Ủng hộ plugin này ](http://1manfactory.com/donate)