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”.

thanks for reply.
can you please help me with this problem?
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\wp-content\plugins\custom-database-tables\templates\cdbt-public-list.php on line 73

https://topmedia.az/?p=2159

I can’t fix the error. what can be the reason and how to fix that?

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.

thank you.
it worked!

From where i can read more about the shortcodes that this plugin use? I only saw 3 codes about show,entry and edit. is there any additional shortcodes?

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.

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

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

thank you so much!
but the document is opening blank on my computer ?? and if it’s in Japaniese then it’s another problem for me :))

Please help me on 2 minor issue

1) How hide the table name that’s shown about the table?
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.

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"]

thank you so much for such a fantastic support!
Good luck!