MySQl database

Hi there
Yes, you can create tables in a MySQL database and manage that’s tables while use this plugin.
However, in the current version plugin can connect to only a MySQL database was installed of WordPress, yet. In other words, it can connect only a MySQL database connection settings are defined in “wp-config.php”.

Because the table structure and execution environment is unknown, complete advice I can not. When I read your error message, I noticed loop does not seem to rotate because the argument is not an array.
Depending on the version of PHP, it might deployment of a formula by function is not possible in the argument of the foreach.

So, sorry to trouble, but you might potentially be resolved by renovation as follows: the line 73 of ”cdbt-public-list.php”.

Original source:

foreach (array_shift($total_data) as $key => $val) {
  if ($key == 'COUNT(*)') {
    $total_data = intval($val);
    break;
  }
}

To customized source:

if (is_array($total_data)) {
  $total_data = array_shift($total_data);
  foreach ($total_data as $key => $val) {
    if ($key == 'COUNT(*)') {
      $total_data = intval($val);
      break;
    }
  }
} else {
  $total_data = 0;
}

If your situation to improve, I will reflect the release of bug fix version of the next.

Hi, I’m glad you been improved!

I wrote documentation for detailed specifications of the shortcodes just today. However, there is no excuse, because it is the Japanese article.

http://ka2.org/cdbt/documentation/shortcodes/

Is currently short code, there are only three that are introduced in the above page.

Yes, is answer.

1) How hide the table name that’s shown about the table?

Please add attribute of “display_title” in shortcode.
example:
[cdbt-view table="table_name" display_title="false"]

2) How hide the “No.” column? My table does not have that column,that’s why i don’t know what to write in order to exclude that.

Please add attribute of “display_list_num” in shortcode.
example:
[cdbt-view table="table_name" display_list_num="false"]