Linux 软件免费装
Banner图

Simple Table Manager

开发者 ryo0inoue
lorro
Ryo Inoue
更新时间 2025年1月20日 07:50
PHP版本: 7.3 及以上
WordPress版本: 6.7
版权: GPLv3
版权网址: 版权信息

标签

export database table mysql crud

下载

1.1 1.3 1.4 1.6.1

详情介绍:

Simple Table Manager enables editing table records and exporting them to CSV files through a minimal database interface from your dashboard. 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.

安装:

  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; }

屏幕截图:

  • Edit record
  • Add record
  • Settings

升级注意事项:

= 1.6.1 (2025-01-14)
  • Changes to meet wordpress.org plugin security guidelines
  • Checked to work with WordPress 6.7

常见问题:

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.

更新日志:

1.6.1 (2025-01-14) 1.6.0 (2023-11-26) 1.5.6 (2023-07-23) Version 1.5.5 (2022-01-20) Version 1.5.4 (2021-10-24) Version 1.5.3 (2021-10-19) Version 1.5.2 (2021-03-15) Version 1.5.1 (2021-03-04) Version 1.5.0 (2021-03-04) Version 1.4 (2020-09-07) Version 1.3 (2019-08-20) Version 1.2 (2016-01-15) Version 1.1 (2015-05-02) Version 1.0 (2015-03-03)