我需要将特定标签/类别中的所有post\\u内容替换为我所需的内容。是他们的插件来完成它,还是他们的查询来完成它。我厌倦了手工操作,这是他们实现它的一种方式。
bulk post_content update
2 个回复
SO网友:Álex Acuña Viera
这就是我的意思:
<?php
$tochange = get_posts(\'numberposts=-1&post_type=any&category_name=category-name-you-want-to-change\');
foreach($tochange as $post){
setup_postdata($post);
$contentchange = \'\'; /*here you do the magic, string replace or whathever you want to do*/
$tochange = array();
$tochange[\'ID\'] = $post->ID;
$tochange[\'post_content\'] = $contentchange;
$out = wp_update_post($tochange);
unset($tochange);
}
wp_reset_query();
?>
SO网友:Ezhil
<?php
function update_post_do()
{
global $wpdb;
$wpdb->query("UPDATE wp_posts p
INNER JOIN wp_term_relationships AS tr ON (p.ID = tr.object_id)
INNER JOIN wp_term_taxonomy AS tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id
AND tt.taxonomy = \'your_category\' AND tt.term_id
IN ( 1 )) SET p.post_content = \'your content\'");
}
add_action(\'init\',\'update_post_do\');
?>
提及要更新的类别、id和内容结束