這個外掛並未在最新的 3 個 WordPress 主要版本上進行測試。開發者可能不再對這個外掛進行維護或提供技術支援,並可能會與更新版本的 WordPress 產生使用上的相容性問題。

Database Browser

外掛說明

Ever needed to check some data in one of your WordPress database tables, but don’t have PHPMyAdmin available? Now you can easily query your data and export it in HTML, XML, CSV, SQL (insert statements) and JSON formats with a simple plugin.

There are other options, for example you can write your own ‘where’ and ‘order by’ clauses, and pagination is built-in. You can also see the complete query run against your database. And you can even save queries with custom names, so if there are queries you use a lot they are only a click away.

螢幕擷圖

  • The database browser form

安裝方式

  1. Upload plugin-name.php to the /wp-content/plugins/ directory, or install from the Plugin browser
  2. Activate the plugin through the ‘Plugins’ menu in WordPress

常見問題集

Installation Instructions
  1. Upload plugin-name.php to the /wp-content/plugins/ directory, or install from the Plugin browser
  2. Activate the plugin through the ‘Plugins’ menu in WordPress
Can I delete my data?

Yes, it is possible to delete or modify data using the custom query, ‘Where’ and ‘Order by’ boxes. Be careful.

Who can export the data?

Only people with export permisions – the people who can run your WordPress export file.

使用者評論

2017 年 6 月 27 日
Usually I troubleshoot databases using phpMyAdmin, but this week I'm helping someone with a site whose hosting doesn't give me access to that. I need to see raw DB contents, and wasn't looking forward to writing a bunch of custom PHP/MySQL queries. Then I found this plugin. Thank you for writing it. What a time saver. Obviously it's doesn't have nearly as many features as phpMyAdmin, and I'm fine with that. This is a great, simple way inspect (and apparently update) the WP DB.
2017 年 1 月 24 日
This plugin is perfect for what I needed. I was able to see the database table containing my user login information (subscribers) and look up a suspicious IP address by exporting the table as a CSV and looking at it in a spreadsheet. Great! I just made a donation to the developer and I am very happy with what this plugin allowed me to do. Thank you again.
2016 年 11 月 26 日
I'll leave this at five stars for now. I PLAN to install this, but haven't yet. For now, I'll justify the review on the basis of documentation and a useful change log. Ahem.
2016 年 11 月 17 日
Quickly query the database, unused to hosting-> phpmyadmin, now a long time
閱讀全部 12 則使用者評論

參與者及開發者

以下人員參與了開源軟體〈Database Browser〉的開發相關工作。

參與者

將 Database Browser 外掛本地化為台灣繁體中文版

對開發相關資訊感興趣?

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

變更記錄

1.4.2 (2017/01/29)

Fixed deprecation error messages.

1.4.1 (2017/01/10)

Tested with WordPress 4.7.

1.4 (2016/10/16)

Added UTF decoding, as per suggestion by @darktek (https://wordpress.org/support/topic/exporting-into-csv-character-error/)
Added unit tests for output methods

1.3 (2015/04/20)

Enabled plugin to handle non-standard plugin folders. Tested up to 4.2.

1.2 (2014/03/28)

Added functionality to save queries with custom names
Rewrote much of the plugin
Reconfigured the UI
Added Spanish translation (thanks to Andrew at http://www.webhostinghub.com/)

1.1.4 (2013/05/29)

Fixed load_plugin_textdomain() call so translations will work properly.

1.1.3 (2013/01/05)

Fixed incorrect $wpdb->prepare() call.

1.1.2 (2011/10/11)

Fixed SQL for column names which are keywords.

1.1.1 (2011/01/04)

Fixed incorrect link for CSV download. Changed table cell styling. Removed pagination links for custom queries. Removed SQL_CALC_FOUND_ROWS in custom queries.

1.1 (2010/12/22)

Added the ability to run custom queries, and export the results. Also added nonce security (thanks to Julio from Boiteaweb.fr). Added Plugin Register.

1.0 (2010/12/06)

Initial version committed.