我网站上的永久链接经常中断。我发现这是由我创建的插件引起的。
该插件基本上创建了一个带有自定义字段的自定义帖子类型，并存储在wp posts和wp post meta表中。
我听说这是因为我正在将它们保存到wp post表中。那么，如何将它们保存到不同的表中呢？我该怎么从那张桌子上拿出来呢。我可以通过传统的PHP和MySQL方式来实现，但我想利用WordPress函数。这能做到吗？
创建自定义帖子类型和分类的代码
function dwwp_register_post_type(){
$singular = \'Speaker\';
$plural = \'Speakers\';
$labels = array(
\'name\' => $plural,
\'singular_name\' => $singular,
\'add_name\' => \'Add New\',
\'add_new_item\' => \'Add New \'.$singular,
\'edit\' => \'Edit\',
\'edit_item\' => \'Edit \'.$singular,
\'new_item\' => \'New \'.$singular,
\'view\' => \'View \'.$singular,
\'view_item\' => \'View \'.$singular,
\'search_term\' => \'Search \'.$plural,
\'parent\' => \'Parent \'.$singular,
\'not_found\' => \'No \'.$plural.\' Found\',
\'not_found_in_trash\' => \'No \'.$plural.\' in Trash\',
);
$args = array(
\'labels\' => $labels,
\'public\' => true,
\'publicly_queryable\' => true,
\'exclude_from_search\' => false,
\'show_in_nav_menus\' => true,
\'show_ui\' => true,
\'show_in_menu\' => true,
\'show_in_admin_bar\' => true,
\'menu_position\' => 6,
\'menu_icon\' => \'dashicons-businessman\',
\'can_export\' => true,
\'delete_with_user\' => false,
\'hierarchical\' => false,
\'has_archive\' => true,
\'query_var\' => true,
\'capability_type\' => \'post\',
\'map_meta_cap\' => true,
\'rewrite\' => array(
\'slug\' => \'speakers\',
\'with_front\' => true,
\'pages\' => true,
\'feeds\' => true,
),
\'supports\' => array(
\'title\',
//\'editor\',
//\'author\',
//\'custom-fields\',
\'thumbnail\'
)
);
register_post_type(\'speakers\', $args);
}
add_action(\'init\', \'dwwp_register_post_type\');
function dwwp_register_taxonomy(){
$plural = \'Years\';
$singular = \'Year\';
$labels = array(
\'name\' => $plural,
\'singular_name\' => $singular,
\'search_items\' => \'Search \'.$plural,
\'popular_items\' => \'Popular \'.$plural,
\'all_items\' => \'All \'.$plural,
\'parent_item\' => null,
\'parent_item_colon\' => null,
\'edit_item\' => \'Edit \'.$singular,
\'update_item\' => \'Update \'.$singular,
\'add_new_item\' => \'Add New \'.$singular,
\'new_item_name\' => \'New \'.$singular.\' Name\',
\'separate_items_with_commas\' => \'Separate \'.$plural.\' with commas\',
\'add_or_remove_items\' => \'Add or Remove \'.$plural,
\'choose_from_most_used\' => \'Choose from the most used \'.$plural,
\'not_found\' => \'No \'.$plural.\' found\',
\'menu_name\' => $plural,
);
$args = array(
\'hierarchical\' => true,
\'labels\' => $labels,
\'show_ui\' => true,
\'show_admin_column\' => true,
\'update_count_callback\' => \'_update_post_term_count\',
\'query_var\' => true,
\'rewrite\' => array(
\'slug\' => \'year\'
)
);
register_taxonomy(\'year\', \'speakers\', $args);
}
add_action(\'init\', \'dwwp_register_taxonomy\');
现在，我为所有演讲者创建了3个自定义字段：简短描述、完整描述和年份是自定义分类法。要从输入字段存储在数据库中的代码
function dwwp_add_custom_metabox(){
add_meta_box(\'dwwp_meta\', \'Speakers Description\', \'dwwp_meta_callback\', \'speakers\', \'normal\', \'core\');
}
add_action(\'add_meta_boxes\', \'dwwp_add_custom_metabox\');
function dwwp_meta_callback( $post ){
wp_nonce_field(basename(__FILE__), \'dwwp_speakers_nonce\');
$dwwp_stored_meta = get_post_meta($post->ID);
?>
<div class="meta-th">
<div class="meta-th">
<span>Short Description</span>
</div>
<div class="meta-editor"></div>
<?php
$content = get_post_meta($post->ID, \'short-description\', true);
$editor = \'short-description\';
$settings = array(
\'textarea_rows\' => 5,
);
wp_editor($content, $editor, $settings);
?>
</div>
<div class="meta-th">
<div class="meta-th">
<span>Long Description</span>
</div>
<div class="meta-editor"></div>
<?php
$content = get_post_meta($post->ID, \'long-description\', true);
$editor = \'long-description\';
$settings = array(
\'textarea_rows\' => 10,
);
wp_editor($content, $editor, $settings);
?>
</div>
<?php }
function dwwp_meta_save($post_id){
$is_autosave = wp_is_post_autosave($post_id);
$is_revision = wp_is_post_revision($post_id);
$is_valid_nonce = (isset($_POST[\'dwwp_speakers_nonce\']) && wp_verify_nonce($_POST[\'dwwp_speakers_nonce\'], basename(__FILE__))) ? \'true\' : \'false\' ;
if ($is_autosave || $is_revision || !$is_valid_nonce){
return;
}
if (isset($_POST[\'short-description\'])){
update_post_meta($post_id, \'short-description\', sanitize_text_field($_POST[\'short-description\']));
}
if (isset($_POST[\'long-description\'])){
update_post_meta($post_id, \'long-description\', sanitize_text_field($_POST[\'long-description\']));
}
}
add_action(\'save_post\', \'dwwp_meta_save\');
然后在网格中显示扬声器，并在其他位置显示其详细信息。用于创建要在其他位置显示的快捷码的代码
<?php
/*
==============================================
Display the speakers in a grid system
==============================================
*/
function speakers_grid_display($atts, $content = null){
$atts = shortcode_atts(
array(
\'years\' => array(\'2018\', \'2017\', \'2016\')
), $atts
);
$return_args[] = \'<div id="section3">
<div class="animation-element slide slide-left testimonial">
<div class="row text-center">
<h1 class="heading-1">Speakers</h1>
</div>
</div>
<div class="container gal-container">\';
$args = array(
\'post_type\' => \'speakers\',
\'orderby\' => \'menu_order\',
\'order\' => \'ASC\',
\'post_per_page\' => -1,
\'tax_query\' => array(
array(
\'taxonomy\' => \'year\',
\'field\' => \'name\',
\'terms\' => $atts[\'years\']
),
),
);
$speakers_list = new WP_Query($args);
if ($speakers_list->have_posts()):
while ($speakers_list->have_posts()): $speakers_list->the_post();
$return_args[] = \'<div class="gal-item show_info">
<div class="box" style="background-image: url(\'.get_the_post_thumbnail_url(get_the_ID()).\')">
<div class="overlay">
<div class="text">
<span class="name">\'.get_the_title().\'</span>
<br />
</div>
</div>
</div>
</div>\';
endwhile;
endif;
$return_args[] = \'</div></div>\';
$args = join($return_args);
return $args;
}
add_shortcode(\'speakers-grid-display\', \'speakers_grid_display\');
/*
=============================================================
Display speakers with pop ups
=============================================================
*/
function speakers_popup($atts, $content = null){
$atts = shortcode_atts(
array(
\'years\' => array(\'2018\', \'2017\', \'2016\')
), $atts
);
$return_args[] = \'<div id="section3">
<div class="animation-element slide slide-left testimonial">
<div class="row text-center">
<h1 class="heading-1">Speakers</h1>
</div>
</div>
<div class="container gal-container">\';
$args = array(
\'post_type\' => \'speakers\',
\'orderby\' => \'menu_order\',
\'order\' => \'ASC\',
\'post_per_page\' => -1,
\'tax_query\' => array(
array(
\'taxonomy\' => \'year\',
\'field\' => \'name\',
\'terms\' => $atts[\'years\']
),
),
);
$speakers_list = new WP_Query($args);
$i = 1;
if ($speakers_list->have_posts()):
while ($speakers_list->have_posts()): $speakers_list->the_post();
$return_args[] = \'<a href="#" data-target="#div\'.$i.\'" class="gal-item show_info">
<div class="box" style="background-image: url(\'.get_the_post_thumbnail_url(get_the_ID()).\')">
<div class="overlay">
<div class="text">
<span class="name">\'.get_the_title().\'</span>
<br />
</div>
</div>
</div>
</a>\';
$i++;
endwhile;
endif;
$return_args[] = \'</div></div>\';
$speakers_list = new WP_Query($args);
$i = 1;
if ($speakers_list->have_posts()):
while ($speakers_list->have_posts()): $speakers_list->the_post();
$return_args[] = \'<div id="div\'.$i.\'" class="show_speakers_info" style="display:none;">
<div class="profile-header-container">
<div class="profile-header-img">
<img src="\'.get_the_post_thumbnail_url(get_the_ID()).\'" />
<!-- badge -->
<div class="profile-heading">
<h3 class="heading-2">\'.get_the_title().\'</h3>
<em>\'.get_post_meta(get_the_ID(), "short-description", true).\'</em>
</div>
</div>
</div>
<div class="text-justify">
\'.get_post_meta(get_the_ID(), "long-description", true).\'
</div>
</div>\';
$i++;
endwhile;
endif;
$return_args = join($return_args);
return $return_args;
}
add_shortcode(\'speakers-popup\', \'speakers_popup\');
然后我创建了另一个页面来重新排列演讲者列表
<?php
//Add submenu
function dwwp_add_submenu_page(){
add_submenu_page(
\'edit.php?post_type=speakers\',
\'Reorder Speakers\',
\'Reorder Speakers\',
\'manage_options\',
\'reorder_speakers\',
\'reorder_callback\'
);
}
add_action(\'admin_menu\', \'dwwp_add_submenu_page\');
//Reorder speakers
function reorder_callback(){
$args = array(
\'post_type\' => \'speakers\',
\'orderby\' => \'menu_order\',
\'order\' => \'ASC\',
\'no_found_rows\' => true,
\'update_post_term_cache\' => false,
\'post_per_page\' => 50
);
$speakers_list = new WP_Query($args);?>
<div id="speakers-sort" class="sort">
<div id="icon-job-admin" class="icon32"><br/></div>
<h2>Reorder Speakers
<img src = "<?php echo esc_url(admin_url() .\'/images/loading.gif\'); ?>" alt="loading.gif" id="loading-animation" ></h2>
<?php
if ($speakers_list->have_posts()): ?>
<ul id="custom-type-list">
<?php
while ($speakers_list->have_posts()): $speakers_list->the_post();
?>
<li id="<?php the_id(); ?>">
<?php the_title(); ?>
</li>
<?php endwhile; ?>
</ul>
<?php else: ?>
<p>No Speakers</p>
<?php endif; ?>
</div>
<?php
}
function dwwp_save_reorder(){
if (!check_ajax_referer(\'wp-speakers-order\', \'security\')){
return wp_send_json_error(\'Invalid Nonce\');
}
if (!current_user_can(\'manage_options\')){
return wp_send_json_error( \'You are not allowed to do this.\' );
}
$order = $_POST[\'order\'];
$count = 0;
foreach( $order as $item_id ){
$post = array(
\'ID\' => (int)$item_id,
\'menu_order\' => $count
);
wp_update_post($post);
$count++;
}
wp_send_json_success(\'Post Saved.\');
}
add_action(\'wp_ajax_save_post\', \'dwwp_save_reorder\');
最后在索引页中，代码是
<?php
/*
Plugin Name: Speakers
Plugin URI: Speakers
Author: Speakers
Version: 1.0.0
*/
if (!defined(\'ABSPATH\')){
exit;
}
require ( plugin_dir_path(__FILE__) . \'speakers_custom_post_type.php\' );
require ( plugin_dir_path(__FILE__) . \'speakers_custom_meta_box.php\' );
require ( plugin_dir_path(__FILE__) . \'speakers_reorder_submenu.php\' );
require ( plugin_dir_path(__FILE__) . \'speakers_shortcode.php\');
function dwwp_admin_enqueue_scripts(){
global $pagenow, $typenow;
if ($typenow == \'speakers\'){
wp_enqueue_style(\'dwwp-admin-css\', plugins_url(\'css/style.css\', __FILE__));
wp_enqueue_script(\'dwwp-admin-js\', plugins_url(\'js/style.js\', __FILE__), array( \'jquery\' , \'jquery-ui-datepicker\' ), \'1.0.0\', true);
}
if (($pagenow == \'post.php\' || $pagenow == \'post-new.php\') && $typenow == \'speakers\'){
wp_enqueue_style(\'dwwp-admin-css\', plugins_url(\'css/style.css\', __FILE__));
wp_enqueue_script(\'dwwp-admin-js\', plugins_url(\'js/reorder.js\', __FILE__), array( \'jquery\' , \'jquery-ui-datepicker\' ), \'1.0.0\', true);
}
if ($pagenow == \'edit.php\' && $typenow == \'speakers\'){
wp_enqueue_script(\'dwwp-reorder-admin-js\', plugins_url(\'js/reorder.js\', __FILE__), array( \'jquery\' , \'jquery-ui-sortable\' ), \'1.0.0\', true);
wp_localize_script(\'dwwp-reorder-admin-js\', \'WP_SPEAKERS_LISTING\', array(
\'security\' => wp_create_nonce(\'wp-speakers-order\'),
\'success\' => __(\'Speakers sort order has been saved.\'),
\'failure\' => __(\'There was an error saving the sort order, or you do not have priviledges\')
));
}
}
add_action(\'admin_enqueue_scripts\', \'dwwp_admin_enqueue_scripts\');
