schema_name = $schema_name; $this->table_name = $table_name; $wpda_data_dictionary = new WPDA_Dictionary_Exist($this->schema_name, $this->table_name); if ( !$wpda_data_dictionary->table_exists() ) { echo '
' . esc_attr__( 'ERROR: Invalid table name or not authorized', 'wp-data-access' ) . '
'; return; } $this->engine = WPDA_Dictionary_Lists::get_engine( $this->schema_name, $this->table_name ); $wpdadb = WPDADB::get_db_connection( $this->schema_name ); if ( null === $wpdadb ) { /* translators: %s = database name */ wp_die( sprintf( esc_attr__( 'ERROR - Remote database %s not available', 'wp-data-access' ), esc_attr( $this->schema_name ) ) ); } $query = "show full columns from `{$wpdadb->dbname}`.`{$this->table_name}`"; $this->table_structure = $wpdadb->get_results( $query, 'ARRAY_A' ); $this->wpda_list_columns = WPDA_List_Columns_Cache::get_list_columns( $this->schema_name, $this->table_name ); ?>
Settings for ``.``
tab_settings(); ?>
table_name, $this->schema_name ); if ( isset( $settings_db[0]['wpda_table_settings'] ) ) { $settings_db_custom = json_decode( $settings_db[0]['wpda_table_settings'] ); $sql_dml = 'UPDATE'; } else { $settings_db_custom = (object) null; $sql_dml = 'INSERT'; } if ( has_filter( 'wpda_add_column_settings' ) ) { // Use filter $column_settings_add_column = apply_filters( 'wpda_add_column_settings', null ); } if ( isset( $column_settings_add_column ) && is_array( $column_settings_add_column ) ) { $array_valid = true; foreach ( $column_settings_add_column as $add_column ) { if ( !isset( $add_column['label'] ) || !isset( $add_column['hint'] ) || !isset( $add_column['name_prefix'] ) || !isset( $add_column['type'] ) || !isset( $add_column['default'] ) || !isset( $add_column['disable'] ) ) { $array_valid = false; break; } } if ( !$array_valid ) { $column_settings_add_column = array(); } } else { $column_settings_add_column = array(); } $row_count_is_configurable = 'innodb' === strtolower( $this->engine ) || 'federated' === strtolower( $this->engine ) || 'connect' === strtolower( $this->engine ) || $this->engine === null; ?>
    schema_name, $this->table_name, $this->table_structure ); ?>

    • table_settings->row_count_estimate_value ) ) { $row_count_estimate_value = $settings_db_custom->table_settings->row_count_estimate_value; } ?>


      Performs real row count if estimate <= . Uses estimated row count if estimate > .

      table_settings->query_buffer_size ) ) { echo 'value="' . esc_attr( $settings_db_custom->table_settings->query_buffer_size ) . '"'; } ?> />



    • wpda_list_columns->get_table_column_headers(); $media_pool = WPDA_Media_Model::get_pool(); $media_cols = array(); if ( isset( $media_pool[$this->schema_name][$this->table_name] ) ) { $media_cols = $media_pool[$this->schema_name][$this->table_name]; } foreach ( $this->table_structure as $column ) { $label_list_table = $this->wpda_list_columns->get_column_label( $column['Field'] ); $label_data_entry = ( isset( $columns[$column['Field']] ) ? $columns[$column['Field']] : '' ); $option = ( isset( $media_cols[$column['Field']] ) ? $media_cols[$column['Field']] : '' ); ?>
      '; } ?> wpda_list_columns->get_table_primary_key(); if ( in_array( $column['Field'], $primary_key ) ) { // phpcs:ignore -- 8.1 proof echo 'disabled="disabled" title="Not available for key columns"'; } } if ( 'checkbox' === $add_column['type'] ) { $column_name = $add_column['name_prefix'] . esc_attr( $column['Field'] ); if ( isset( $settings_db_custom->custom_settings->{$column_name} ) ) { echo ( $settings_db_custom->custom_settings->{$column_name} ? 'checked' : '' ); } else { echo esc_attr( $add_column['default'] ); } } ?> >'; } ?>

    • settings_tab_dynamic_hyperlinks( $settings_db_custom ); do_action( 'wpda_append_table_settings' ); ?>