Linux 软件免费装
Banner图

Custom DataBase Tables

开发者 ka2
更新时间 2016年9月28日 14:12
捐献地址: 去捐款
PHP版本: 4.0 及以上
WordPress版本: 4.6.1
版权: GPLv2 or later
版权网址: 版权信息

标签

export import database select table update delete CSV insert truncate create drop custom database tables MySQL alter table

下载

0.9.5 0.9.6 1.0.0 1.1.0 1.1.10 1.1.11 1.1.12 1.1.13 1.1.14 1.1.15 1.1.2 1.1.3 1.1.4 1.1.5 1.1.6 1.1.8 1.1.9 2.0.0 2.0.1 2.0.10 2.0.11 2.0.12 2.0.2 2.0.3 2.0.4 2.0.6 2.0.7 2.0.8 2.0.9 2.1.31 1.1.7 2.0.5 2.1.32 2.1.33 2.1.34

详情介绍:

WordPress database is easy to use with simple, but if you want to handle the data that does not conform to the provided initial table structure, or considering the use of as the CMS, you should create a newly table as a better case. This plugin provides the ability to be able to add a new table freely in the database (direct on MySQL) of WordPress in such a case, and can be management of data in a simple user interface. However, since the plugin version 2.x, you need to be PHP version 5.4 or more on the environment. When you use the various shortcodes, built-in methods, and APIs that is provided a rich on this plugin, WordPress might be transformed into a powerful CMS. Please see here for more documentation of the plugin.

安装:

  1. Upload custom-database-tables directory to the /wp-content/plugins/ directory
  2. 通过WordPress的的“Plugins”菜单激活插件
  3. Navigate to the Custom DB Tables submenu in setting menu
That's it. Now you can easily start creating custom table in database of WordPress If needed, please install the legacy version any it is from here. Also, lastest legacy version is 1.1.15.

屏幕截图:

  • On this plugin, you will be able to manipulate various tables of the database from wordpress management screen.
  • You can create free their own table in the database.
  • Your database creation can be intuitively designed with a drag-and-drop.
  • Since version 2, you can also manage the core tables that is built in WordPress.
  • You can easily operate data in any tables via simply and useful interface.
  • By the multi-functional shortcodes, you are able to provide any tables to the front-end visitors.
  • With the Web API features, you will be able to allow table operation from other than your own site.
  • Sorry, please use the previous version 1.x if your environment has PHP 5.3 or less.
  • The legacy version of the plugin is possible to get from [here](https://downloads.wordpress.org/plugin/custom-database-tables.1.1.15.zip).

升级注意事项:

2.1.31 Minor upgrade version 2.1 has improved the user experience. 2.0.8 Hotfix of fixing the bug that had set an invalid select clause in select query. 2.0.6 Because there had improvemented around the session, please use after you delete your browser's cache and Cookie once.

其他记录:

All official development on this plugin is on GitHub. Published version will bump here on WordPress.org. You can find the repository at https://github.com/ka215/cdbt. Detailed documentation has published at the site of author. If you are free, Please try to qv. (Sorry, for about documentation will be only the Japanese version currently.)

常见问题:

Can not activate the latest plugin

This plugin must be working environment of PHP 5.4 since version 2. Please use the version 1 system in previous environment of PHP 5.3. You can be downloaded past versions from here.

Does this plugin create table on direct mysql?

Yes, 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".

Is there any limit of the scope of the table?

You need a table that is managed by the plug-in is an "ID" is the primary key. The column that contains the update date and registration date of the line will also be necessary. Column These keys are added automatically when you create a table.

Can put table that have 100,000 or more rows?

There is no particular restriction on the amount of data that is stored in a table. Processing performance on a table with a large number of rows will depend on the structure such as a table or database server. However, you should enable the "Ajax Loading" in the shortcode's options if you want to handle the table that has a large amount of data by the shortcodes.

What should we do when there is not displayed the data via shortcode?

In most cases, that's cause of the jQuery file conflict. Therefore please try to do procedures as follows:

  1. Go to the "General Settings" tab on the "CDBT Plugin Options" screen.
  2. Uncheck the checkbox of "jQuery" in the "Front-end Screen" column at the "Loading Resources" item of the "Advanced Plugin Settings".
  3. Click the "Save Changes" button.
Note: you should change in the "Administration Screen" column at above step 2 If the same trouble is occurred in the tables management screen.

How do we use the shortcode at the outer the post content?

The shortcodes of this plugin basically work within the post content. If you want to work the shortcodes outside of the post content (as direct built-in template, or in the widget), you should insert code below. if ( ! is_admin() ) { global $cdbt; add_action( 'init', array( $cdbt, 'cdbt_pre_shortcode_render' ), 10, 2 ); }

How can we protect the "wp-admin" directory by using as like ".htaccess"?

Because this plugin is working all Ajax processing via the "wp-admin/admin-ajax.php", only that file in the ".htaccess" must have been to be able to access. In that case, please add a description of the following to the ".htaccess" under the "wp-admin". <FilesMatch "(admin-ajax.php)$"> Satisfy Any Order allow,deny Allow from all Deny from none </FilesMatch>

How shall we act on if using custom permalink structure?

When you use this plugin on the site that has custom permalink structure as like "your-domain/custom-path/wp-admin", you should add code of filter hook below. function my_cdbt_shortcode_custom_component_options( $component_options, $shortcode_name, $table ){ if ( is_admin() && $shortcode_name === "cdbt-edit" ) { $component_options['actionUrl'] = admin_url( str_replace( '/wp-admin', '', $component_options['actionUrl'] ) ); } return $component_options; } add_filter( 'cdbt_shortcode_custom_component_options', 'my_cdbt_shortcode_custom_component_options', 10, 3 );

更新日志:

2.1.34 2.1.33 2.1.32 2.1.31 2.0.12 2.0.11 2.0.10 2.0.9 2.0.8 2.0.7 2.0.6 2.0.5 2.0.4 2.0.3 2.0.2 2.0.1 2.0.0 1.1.15 1.1.14 1.1.13 1.1.12 1.1.11 1.1.10 1.1.9 1.1.8 1.1.7 1.1.6 1.1.5 1.1.4 1.1.3 1.1.2 1.1.1 1.1.0 1.0.0 0.9.6 0.9.5 0.9.1