I am attempting to migrate large amounts of data from a non-WP-like CMS into WordPress and I'm trying to find an efficient way to assign batches of posts to a category.wp_set_post_categories()
takes a single post and an array of categories to add it to. Is there anything more efficient than simply looping through an array of post id's and calling wp_set_post_categories()
on each one with a call to the database each time?
在wordpress中有效设置多个帖子的类别
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
1条回答 默认 最新
- dqsw7529 2018-03-27 05:15关注
Your best option may be to run a SQL query to set the category on all of the posts in one go.
global $wpdb; $category = get_category(get_query_var('category')); $term_taxonomy_id = $category->term_taxonomy_id; $wpdb->query(" INSERT INTO $wpdb->term_relationships ( object_id, term_taxonomy_id, term_order ) SELECT ID AS object_id, $term_taxonomy_id AS term_taxonomy_id, 0 AS term_order FROM $wpdb->posts ");
Update: then to update the field that counts the number of posts the category has.
$wpdb->query(" UPDATE $wpdb->term_taxonomy SET `count` = (SELECT COUNT(ID) FROM wp_posts) WHERE term_taxonomy_id = $term_taxonomy_id ");
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报
悬赏问题
- ¥15 全部备份安卓app数据包括密码,可以复制到另一手机上运行
- ¥15 Python3.5 相关代码写作
- ¥20 测距传感器数据手册i2c
- ¥15 RPA正常跑,cmd输入cookies跑不出来
- ¥15 求帮我调试一下freefem代码
- ¥15 matlab代码解决,怎么运行
- ¥15 R语言Rstudio突然无法启动
- ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
- ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
- ¥15 用windows做服务的同志有吗