ka2

Sorry for my late reply.

Sorry to trouble you, please tell me the full statements of SQL which is displayed in a modal dialog for confirmation of when you will be creating a table.

Thank you,

Hi there,
Thank you for your inquiry.

That is, do you want to output the only values of the “properties” column into the horizontal row?

So, it is feasible if you use a PHP script.
For example is as follow:

global $cdbt;

$data = $cdbt->get_data( 'your_table_name', 'properties' );

$html = '<table class="table table-bordered"><tr>';
foreach ($data as $value) {
  $html .= sprintf('<td>%s</td>', $value->properties);
}
$html .= '</tr></table>';

echo $html;

Do you have become the answer you desire?

Thank you for your inquiry.

Currently,there are many desire to decorate the some specific columns of data listed in the same as you want. It is difficult in the specification of the current plugin, but you can respond by modifying the source of the plugin as described below.
As an example, we will introduce the case of short codes [cdbt-view].

Firstly, please open the file of wp-content/plugins/custom-database-tables/templates/cdbt-public-list.php by using text editor.

Please add the following one line to the 189 line.

$val = apply_filters( 'cdbt_view_cell', $val, $data_id, $key, $table_name );

After adding the above line, source looks like follow:

if (!empty($exclude_cols) && in_array($key, $exclude_cols)) {
  continue;
} else {
  $val = apply_filters( 'cdbt_view_cell', $val, $data_id, $key, $table_name );
  $list_rows .= '<td>'. $val .'</td>';
}

Next, open the function.php of your theme (wp-content/themes/*****/functions.php), you can add as follows:

function my_decorate_cell( $cell_value, $data_id, $column_name, $table_name ) {
  if ( $table_name == 'your_table_name' && $column_name == 'target_column_name' ) {
    if ( !empty($cell_value) ) {
      $cell_value = sprintf('<a href="%s">%s</a>', $cell_value, $cell_value);
    }
  }

  return $cell_value;
}
add_filter( 'cdbt_view_cell', 'my_decorate_cell', 10, 4 );

In the above example, There will be enclosed the value of the “your_column_name” column of “your_table_name” table at <a> tag.

Also, the same demand with you wants is quite large.
So in the next version, I’m going to add this filter hook to the cell output of all short code.

Thank you,

Thank you very much for reporting.
And, I’m so sorry for not replying sooner.

Unfortunately, it’s a bug. I’m sorry. When you used the attribute of “bootstrap_style=false” in shortcodes, There should be not render a modal block.

Please wait a while until this plugin is released the next version, I will fixed a bug.

I try to include my original button to rendered page by a shortcode of [cdbt-view].

For example if table is as follows:

CREATE TABLE wp_int_test (
  ID int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  col int(11) NOT NULL,
  created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'created datetime',
  updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'updated datetime',
  PRIMARY KEY (ID)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8

The html contents in body of post is follows:

[cdbt-view table="wp_int_test" display_search="false" display_list_num="false" enable_sort="false" exclude_cols="created"]

<script>
function refresh_page() {
  location.reload();
}
</script>

In the “templates/cdbt-public-list.php” on the directory of cdbt plugin, I have customized as follows:

# 189 to 190 lines
  $output = apply_filters('cdbt_view_column_value', $val, $table_name, $key);
  $list_rows .= '<td>'. $output .'</td>';

Then, In the “functions.php” of using theme, I have added as follows:

add_filter('cdbt_view_column_value', 'add_my_button', 10, 4);
function add_my_button($val, $table_name, $column_name, $id) {
  if ($table_name == 'wp_int_test' && $column_name == 'col') {
    $increase_query = sprintf('UPDATE %s SET %s = %d WHERE ID = %d', $table_name, $column_name, intval($val)+1, intval($id));
    $increase_button = do_shortcode(sprintf('[cdbt-submit table="%s" label="%s" query="%s" final="refresh_page" add_class="%s"]', $table_name, '+', $increase_query, 'default btn-xs'));

    $decrease_query = sprintf('UPDATE %s SET %s = %d WHERE ID = %d', $table_name, $column_name, intval($val)-1, intval($id));
    $decrease_button = do_shortcode(sprintf('[cdbt-submit table="%s" label="%s" query="%s" final="refresh_page" add_class="%s"]', $table_name, '-', $decrease_query, 'default btn-xs align-left'));

    $val = sprintf('%s <p class="pull-right">%s%s</p>', $val, $increase_button, $decrease_button);
  }
  return $val;
}

By the above as, you can make a list of pages that you can change the value by added buttons of “+” or “-” to the particular column.

Screenshot image of the sample is here.

Hmmm,

If you can hardcoded into the sources of the plugin, you may try to embed directly button into the file of the following.

– This contents is rendered by shortcode
templates/cdbt-public-edit.php : 269 to 273 lines

– This contents is rendered on admin panel
templates/cdbt-edit.php : 216 to 220 lines

The event of clicking on the button add as JavaScript in the “lib/cdbt.scripts.php”. In this way, you can add the processing and yourself button that you want.

Hi there, thank you for your inquiry.

It’s really too bad, but your both hopes is not possible in the current plugin.

However, I also would like to support advanced data retrieval as query of “JOIN” in the future. I was surprised to your fantastic idea of including the custom button to the data rows. Its your idea will be stock for additional future functionality.

Thank you,