Title: MySQl database
Last modified: August 22, 2016

---

# MySQl database

 *  Resolved [mastaliyev](https://wordpress.org/support/users/mastaliyev/)
 * (@mastaliyev)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/mysql-database-11/)
 * hi. does your plugin create table on mysql?
    i mean does it has ability to be
   connected to MySQL table so i can read table content?
 * [https://wordpress.org/plugins/custom-database-tables/](https://wordpress.org/plugins/custom-database-tables/)

Viewing 8 replies - 1 through 8 (of 8 total)

 *  Plugin Author [ka2](https://wordpress.org/support/users/ka2/)
 * (@ka2)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/mysql-database-11/#post-5336362)
 * 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”.
 *  Thread Starter [mastaliyev](https://wordpress.org/support/users/mastaliyev/)
 * (@mastaliyev)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/mysql-database-11/#post-5336366)
 * 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
 * [http://topmedia.az/?p=2159](http://topmedia.az/?p=2159)
 * I can’t fix the error. what can be the reason and how to fix that?
 *  Plugin Author [ka2](https://wordpress.org/support/users/ka2/)
 * (@ka2)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/mysql-database-11/#post-5336368)
 * 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.
 *  Thread Starter [mastaliyev](https://wordpress.org/support/users/mastaliyev/)
 * (@mastaliyev)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/mysql-database-11/#post-5336374)
 * 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?
 *  Plugin Author [ka2](https://wordpress.org/support/users/ka2/)
 * (@ka2)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/mysql-database-11/#post-5336380)
 * 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/](http://ka2.org/cdbt/documentation/shortcodes/)
 * Is currently short code, there are only three that are introduced in the above
   page.
 *  Thread Starter [mastaliyev](https://wordpress.org/support/users/mastaliyev/)
 * (@mastaliyev)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/mysql-database-11/#post-5336382)
 * 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.
 *  Plugin Author [ka2](https://wordpress.org/support/users/ka2/)
 * (@ka2)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/mysql-database-11/#post-5336384)
 * 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"]`
 *  Thread Starter [mastaliyev](https://wordpress.org/support/users/mastaliyev/)
 * (@mastaliyev)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/mysql-database-11/#post-5336386)
 * thank you so much for such a fantastic support!
    Good luck!

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘MySQl database’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/custom-database-tables_e4e2e2.svg)
 * [Custom DataBase Tables](https://wordpress.org/plugins/custom-database-tables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/custom-database-tables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/custom-database-tables/)
 * [Active Topics](https://wordpress.org/support/plugin/custom-database-tables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/custom-database-tables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/custom-database-tables/reviews/)

 * 8 replies
 * 2 participants
 * Last reply from: [mastaliyev](https://wordpress.org/support/users/mastaliyev/)
 * Last activity: [11 years, 7 months ago](https://wordpress.org/support/topic/mysql-database-11/#post-5336386)
 * Status: resolved