开发者 | ka2 |
---|---|
更新时间 | 2016年9月28日 14:12 |
捐献地址: | 去捐款 |
PHP版本: | 4.0 及以上 |
WordPress版本: | 4.6.1 |
版权: | GPLv2 or later |
版权网址: | 版权信息 |
custom-database-tables
directory to the /wp-content/plugins/
directoryThis 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.
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".
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.
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.
In most cases, that's cause of the jQuery file conflict. Therefore please try to do procedures as follows:
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 ); }
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>
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 );
cdbt_select_clause_optimaize
for filtering the select clause of SQL query.