Title: Simple Table Manager
Author: ryo0inoue
Published: <strong>2015年3月3日</strong>
Last modified: 2025年1月19日

---

プラグインを検索

![](https://ps.w.org/simple-table-manager/assets/banner-772x250.png?rev=1134129)

このプラグインは **WordPress の最新3回のメジャーリリースに対してテストされていま
せん**。もうメンテナンスやサポートがされていないかもしれず、最新バージョンの WordPress
で使用した場合は互換性の問題が発生する可能性があります。

![](https://ps.w.org/simple-table-manager/assets/icon-128x128.png?rev=1133727)

# Simple Table Manager

 作者: [ryo0inoue](https://profiles.wordpress.org/ryo0inoue/)

[ダウンロード](https://downloads.wordpress.org/plugin/simple-table-manager.1.6.1.zip)

 * [詳細](https://ja.wordpress.org/plugins/simple-table-manager/#description)
 * [レビュー](https://ja.wordpress.org/plugins/simple-table-manager/#reviews)
 *  [インストール](https://ja.wordpress.org/plugins/simple-table-manager/#installation)
 * [開発](https://ja.wordpress.org/plugins/simple-table-manager/#developers)

 [サポート](https://wordpress.org/support/plugin/simple-table-manager/)

## 説明

Simple Table Manager enables editing table records and exporting them to CSV files
through a minimal database interface from your dashboard.

 * Simply CRUD table contents on your wp-admin screen
 * Search and sort table records
 * No knowledge of MySQL or PHP required
 * Export table records to a CSV file
 * Does not allow users to create tables or change the structure of the table

Simple Table Manager is a tool suited for the initial development phase of a website.
It is ideal when you want to ask someone else with no database expertise to keep
track of table records on your website. This was the motivation for developing this
plugin.

Note that to comply with wordpress.org plugin security guidelines, edited and added
record fields are filtered through wp_kses_post() to prevent sql injection attacks.
In some cases, wanted tags may be filtered out leading to field corruption.

## スクリーンショット

 * [[
 * List records
 * [[
 * Edit record
 * [[
 * Add record
 * [[
 * Settings
 * [[
 * [[

## インストール

 1. Via the Dashboard > Plugins > Add plugin menu page.
 2. Or upload the entire ‘simple-table-manager’ folder to the ‘/wp-content/plugins/’
    directory.
 3. Activate the plugin through the ‘Plugins’ menu in WordPress.
 4. On the plugin’s ‘Settings’ page, select the table you want to view and manage.

Filter call examples for developer use:

// change a value

    ```
    add_filter( 'tstm_list_field', 'custom_list_field_value', 10, 4 );
    function custom_list_field_value( $field_value, $current_table, $column_name, $key_value ) {
      if( 'wppb_options' == $current_table ) {
        if( 'option_value' == $column_name ) {
          if( 7 == $key_value ) {
            if( $field_value ) {
              $field_value = "true";
            } else {
              $field_value = "false";
            }
          }
        }
      }
      return $field_value;
    }
    ```

// change the default text input for radios

    ```
    add_filter( 'tstm_add_field_html', 'custom_field_html', 10, 4 );
    add_filter( 'tstm_edit_field_html', 'custom_field_html', 10, 4 );
    function custom_field_html( $field_html, $current_table, $column_name, $field_value, $key_value = true  ) {
      if( 'wppb_options' == $current_table ) {
        if( 'option_value' == $column_name ) {
          $column_name = urlencode( $column_name );
          if( $field_value ) {
            $field_html = '<input type="radio" name="'.$column_name.'" value="1" checked> Yes<br>';
            $field_html .= '<input type="radio" name="'.$column_name.'" value="0"> No';
          } else {
            $field_html = '<input type="radio" name="'.$column_name.'" value="1"> Yes<br>';
            $field_html .= '<input type="radio" name="'.$column_name.'" value="0" checked> No';      
          }
        }
      }
      return $field_html;
    }
    ```

// change the default text input for a checkbox

    ```
    add_filter( 'tstm_add_field_html', 'custom_field_html', 10, 5 );
    add_filter( 'tstm_edit_field_html', 'custom_field_html', 10, 5 );
    function custom_field_html( $field_html, $current_table, $column_name, $field_value, $key_value = true ) {
      if( 'wppb_options' == $current_table ) {
        if( 'option_value' == $column_name ) {
          if( 7 == $key_value ) {
            $checked = $field_value ? 'checked' : '';
            $field_html = '<input type="hidden" name="'.$column_name.'" value="0">'.PHP_EOL;
            $field_html .= '<input type="checkbox" name="'.$column_name.'" value="1" '.$checked.'>'.PHP_EOL;
          }
        }
      }
      return $field_html;
    }
    ```

## FAQ

### How can I add a new table or field by using the plugin?

You can’t. Use ‘full featured’ plugins or phpMyAdmin if you need full access to 
the database.

## 評価

![](https://secure.gravatar.com/avatar/66a8a47f602abde4abcce9823ae8bce20ba199511fc987cd77f4b707a0cf1f71?
s=60&d=retro&r=g)

### 󠀁[Does exactly what it says!](https://wordpress.org/support/topic/does-exactly-what-it-says-245/)󠁿

 [johnsalomon](https://profiles.wordpress.org/johnsalomon/) 2023年3月22日

Easy and lightweight. Nice!

![](https://secure.gravatar.com/avatar/f648e440340f94fb6b5b6b1156e46e76f21ac6fbd8a0d1134cdd180b77c84b01?
s=60&d=retro&r=g)

### 󠀁[Great!!!](https://wordpress.org/support/topic/great-13888/)󠁿

 [moderworks](https://profiles.wordpress.org/moderworks/) 2021年10月24日

All I can say

![](https://secure.gravatar.com/avatar/da5b5dc8cba07487d05354a9c155364f6676728cdf26924ea85fe5e693605482?
s=60&d=retro&r=g)

### 󠀁[Great for non-techy admin to maintain data.](https://wordpress.org/support/topic/great-for-non-techy-admin-to-maintain-data/)󠁿

 [Peter Lawrenson](https://profiles.wordpress.org/lorro/) 2016年9月3日

As advertised, this plugin is great for a non-techy admin to create and edit data,
and I recommended the plugin for this purpose. I used phpMyAdmin to setup the table
and then used the plugin to create the initial set of records. There are no display
facilities with the plugin so I a used a bit of custom code. Only 2 lines are needed
to fetch the data into a php function: global $wpdb; $results = $wpdb->get_results('
SELECT * FROM wp_mytable', ARRAY_N ); The plugin will allow access to only one table
at a time, but its easy to switch between tables. Thanks for sharing.

![](https://secure.gravatar.com/avatar/a11cfa63cfb88a7d917fb776718dc5e3e58673d9b9d49dc0372d928260e76d8c?
s=60&d=retro&r=g)

### 󠀁[pick calender on form](https://wordpress.org/support/topic/pick-calender-on-form/)󠁿

 [rizkykiki](https://profiles.wordpress.org/rizkykiki/) 2016年9月3日

I wish type date can pick calender on form

 [ 4件のレビューをすべて表示 ](https://wordpress.org/support/plugin/simple-table-manager/reviews/)

## 貢献者と開発者

Simple Table Manager はオープンソースソフトウェアです。以下の人々がこのプラグイン
に貢献しています。

貢献者

 *   [ ryo0inoue ](https://profiles.wordpress.org/ryo0inoue/)
 *   [ Peter Lawrenson ](https://profiles.wordpress.org/lorro/)

[“Simple Table Manager” をあなたの言語に翻訳しましょう。](https://translate.wordpress.org/projects/wp-plugins/simple-table-manager)

### 開発に興味がありますか ?

[コードを閲覧](https://plugins.trac.wordpress.org/browser/simple-table-manager/)
するか、[SVN リポジトリ](https://plugins.svn.wordpress.org/simple-table-manager/)
をチェックするか、[開発ログ](https://plugins.trac.wordpress.org/log/simple-table-manager/)
を [RSS](https://plugins.trac.wordpress.org/log/simple-table-manager/?limit=100&mode=stop_on_copy&format=rss)
で購読してみてください。

## 変更履歴

#### 1.6.1 (2025-01-14)

 * Changes to meet wordpress.org plugin security guidelines
 * Checked to work with WordPress 6.7

#### 1.6.0 (2023-11-26)

 * Enhanced security and other changes to comply with wordpress.org plugin guidelines.
 * Checked to work with WordPress 6.4

#### 1.5.6 (2023-07-23)

 * WHERE clause construction refactored
 * Checked to work with WordPress 6.2

#### Version 1.5.5 (2022-01-20)

 * Function “stm_load_textdomain” renamed to remove conflict with course-editor 
   plugin.

#### Version 1.5.4 (2021-10-24)

 * New feature: Option in the settings tab to restrict plugin access to administrators(
   Defaults to “Authors” and better capabilities)

#### Version 1.5.3 (2021-10-19)

 * Tested with WP 5.8
 * Translation file updated

#### Version 1.5.2 (2021-03-15)

 * Added a setting to pretty print any unserialized arrays on the Edit tab
 * Added a filter example to show how to setup a checkbox input with the plugin
 * Tested with WP v5.7 & PHP v8.0.2

#### Version 1.5.1 (2021-03-04)

 * Version 1.5.0 upload was corrupted. Re-uploaded.

#### Version 1.5.0 (2021-03-04)

 * Changes by: lorro
 * New feature – User can select a sub-set of fields to show. Enables wide tables
   to fit the screen.
 * New feature – Filters for List table field display and for Edit and Add field
   html. See Installation section for use.
 * Redesigned interface
 * Tested with WordPress 5.6.2
 * Updated readme.txt

#### Version 1.4 (2020-09-07)

 * Changes by: lorro
 * Fixed errors if column names have spaces.
 * Date fields have a date picker in the Edit and Add screens.
 * Time fields have a time picker in the Edit and Add screens.
 * Works if the primary column is not the first column
 * Edit and Add screens show data types.
 * Minor styling improvements.
 * Tested with WordPress 5.5.1
 * Updated readme.txt

#### Version 1.3 (2019-08-20)

 * Changes by: lorro
 * Fix error on activation if database prefix is not “wp_”
 * Fix CSV Export.
 * Fix $order not found error.
 * Make all strings translation-ready.
 * Cosmetic changes

#### Version 1.2 (2016-01-15)

 * Author: Ryo Inoue
 * Enabled handling of non-integer primary keys.

#### Version 1.1 (2015-05-02)

 * Author: Ryo Inoue
 * Added feature to auto-adjust input text fields according to data type.
 * Enabled insert and retrieval of data containing special chars.
 * Rearranged files for a loosely MVC structure.
 * Fixed a few minor bugs.

#### Version 1.0 (2015-03-03)

 * Author: Ryo Inoue
 * First release

## メタ

 *  バージョン **1.6.1**
 *  最終更新日 **1年前**
 *  有効インストール数 **400+**
 *  WordPress バージョン ** 6.2またはそれ以降 **
 *  検証済み最新バージョン: **6.7.5**
 *  PHP バージョン ** 7.3またはそれ以降 **
 *  言語
 * [English (US)](https://wordpress.org/plugins/simple-table-manager/)
 * タグ
 * [crud](https://ja.wordpress.org/plugins/tags/crud/)[database](https://ja.wordpress.org/plugins/tags/database/)
   [export](https://ja.wordpress.org/plugins/tags/export/)[mysql](https://ja.wordpress.org/plugins/tags/mysql/)
   [table](https://ja.wordpress.org/plugins/tags/table/)
 *  [詳細を表示](https://ja.wordpress.org/plugins/simple-table-manager/advanced/)

## 評価

 5つ星中4.8つ星

 *  [  3 5-星レビュー     ](https://wordpress.org/support/plugin/simple-table-manager/reviews/?filter=5)
 *  [  1 4-星レビュー     ](https://wordpress.org/support/plugin/simple-table-manager/reviews/?filter=4)
 *  [  0 3-星レビュー     ](https://wordpress.org/support/plugin/simple-table-manager/reviews/?filter=3)
 *  [  0 2-星レビュー     ](https://wordpress.org/support/plugin/simple-table-manager/reviews/?filter=2)
 *  [  0 1-星レビュー     ](https://wordpress.org/support/plugin/simple-table-manager/reviews/?filter=1)

[Your review](https://wordpress.org/support/plugin/simple-table-manager/reviews/#new-post)

[すべてのレビューを見る](https://wordpress.org/support/plugin/simple-table-manager/reviews/)

## 貢献者

 *   [ ryo0inoue ](https://profiles.wordpress.org/ryo0inoue/)
 *   [ Peter Lawrenson ](https://profiles.wordpress.org/lorro/)

## サポート

意見や質問がありますか ?

 [サポートフォーラムを表示](https://wordpress.org/support/plugin/simple-table-manager/)