Descripción

Simple Table Manager permite editar los registros de las tablas de la base de datos y exportarlos a archivos CSV con una interfaz de base de datos minimalista desde tu escritorio.

Simplemente los contenidos de la tabla en CRUD en tu pantalla de wp-admin
Buscar y ordenar los registros de tabla
No requiere conocimiento en MySQL o PHP
Exporta los registros de la tabla a un archivo CSV
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.

Capturas

Instalación

A través de la página del menú «Escritorio > Plugins > Añadir plugin»
O sube la carpeta «simple-table-manager» completa al directorio «/wp-content/plugins/»
Activa el plugin desde el menú ‘Plugins’ de WordPress
On the plugin’s ‘Settings’ page, select the table you want to view and manage.

Ejemplos de llamada al filtro para su uso por los desarrolladores:

// cambia un valor

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

// cambia la entrada de texto por defecto para las casillas de radio

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

// cambia la entrada de texto por defecto para la casilla de verificación

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

¿Cómo puedo añadir una nueva tabla o campo usando el plugin?: No puedes. Usa plugins con funciones adecuadas o phpMyAdmin si necesitas acceso completo a la base de datos.

Reseñas

johnsalomon 22 de marzo de 2023

Easy and lightweight. Nice!

moderworks 24 de octubre de 2021

All I can say

Lorro 3 de septiembre de 2016

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.

rizkykiki 3 de septiembre de 2016

I wish type date can pick calender on form

Leer todas las 4 reseñas

Colaboradores y desarrolladores

«Simple Table Manager» es un software de código abierto. Las siguientes personas han colaborado con este plugin.

Traduce «Simple Table Manager» a tu idioma.

¿Interesado en el desarrollo?

Revisa el código , echa un vistazo al repositorio SVN o suscríbete al registro de desarrollo por RSS.

Registro de cambios

1.7.0 (2026-09-19)

Improved handling of data types
Limited validation of user’s input on the Edit and Add tabs
‘enum’ data type supported
Multisite admins can limit the tables shown in the table selector to one site
Checked to work with WordPress 7.1

1.6.1 (2025-01-19)

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)

Renombrada función «stm_load_textdomain» para eliminar el conflicto con el plugin de edición de cursos.

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)

Probado con WP 5.8
Actualizado el archivo de traducción

Version 1.5.2 (2021-03-15)

Added a setting to pretty print any unserialised arrays on the Edit tab
Added a filter example to show how to setup a checkbox input with the plugin
Probado con WP v5.7 y 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.7.0 (2026-09-19) =
Improved handling of data types
Limited validation of user’s input on the Edit and Add tabs
‘enum’ data type supported
Multisite admins can limit the tables shown in the table selector to one site
Checked to work with WordPress 7.1

Does exactly what it says!

Great!!!

Great for non-techy admin to maintain data.

pick calender on form