douhu2898 2018-03-26 23:05
浏览 48
已采纳

在wordpress中有效设置多个帖子的类别

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?

  • 写回答

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 在获取boss直聘的聊天的时候只能获取到前40条聊天数据
  • ¥20 关于URL获取的参数,无法执行二选一查询
  • ¥15 液位控制,当液位超过高限时常开触点59闭合,直到液位低于低限时,断开
  • ¥15 marlin编译错误,如何解决?
  • ¥15 有偿四位数,节约算法和扫描算法
  • ¥15 VUE项目怎么运行,系统打不开
  • ¥50 pointpillars等目标检测算法怎么融合注意力机制
  • ¥20 Vs code Mac系统 PHP Debug调试环境配置
  • ¥60 大一项目课,微信小程序
  • ¥15 求视频摘要youtube和ovp数据集