// 假设从Laravel的articles表迁移到WordPress的posts表
$laravelArticles = DB::connection('laravel_db')->table('articles')->get();

foreach ($laravelArticles as $article) {
    $post_id = wp_insert_post([
        'post_title'   => $article->title,
        'post_content' => $article->content,
        'post_status'  => 'publish',
        'post_type'    => 'post',
        'post_date'    => $article->created_at,
    ]);
    
    // 添加自定义字段
    update_post_meta($post_id, 'custom_field', $article->custom_field);
}

$laravelUsers = DB::connection('laravel_db')->table('users')->get();

foreach ($laravelUsers as $user) {
    $user_id = wp_insert_user([
        'user_login' => $user->username,
        'user_pass'  => $user->password, // 注意密码加密方式可能不同
        'user_email' => $user->email,
        'display_name' => $user->name,
    ]);
    
    // 可能需要处理角色和权限转换
}

// Laravel到WordPress的完整迁移脚本示例
require_once('wp-load.php'); // 加载WordPress环境

// 连接Laravel数据库
$laravelDb = new PDO('mysql:host=localhost;dbname=laravel_db', 'username', 'password');

// 迁移文章
$articles = $laravelDb->query("SELECT * FROM articles")->fetchAll(PDO::FETCH_OBJ);

foreach ($articles as $article) {
    // 检查是否已迁移
    if (!post_exists($article->title)) {
        $post_id = wp_insert_post([
            'post_title'   => $article->title,
            'post_content' => $article->content,
            'post_status'  => 'publish',
            'post_type'    => 'post',
            'post_date'    => $article->created_at,
            'post_author'  => 1, // 默认管理员
        ]);
        
        // 迁移分类
        $categories = $laravelDb->query("SELECT * FROM article_category WHERE article_id = {$article->id}")->fetchAll(PDO::FETCH_OBJ);
        $wp_cats = [];
        foreach ($categories as $cat) {
            $category = $laravelDb->query("SELECT * FROM categories WHERE id = {$cat->category_id}")->fetch(PDO::FETCH_OBJ);
            $wp_cat_id = category_exists($category->name);
            if (!$wp_cat_id) {
                $wp_cat_id = wp_create_category($category->name);
            }
            $wp_cats[] = $wp_cat_id;
        }
        wp_set_post_categories($post_id, $wp_cats);
        
        // 迁移标签
        $tags = $laravelDb->query("SELECT * FROM article_tag WHERE article_id = {$article->id}")->fetchAll(PDO::FETCH_OBJ);
        $wp_tags = [];
        foreach ($tags as $tag) {
            $tag_data = $laravelDb->query("SELECT * FROM tags WHERE id = {$tag->tag_id}")->fetch(PDO::FETCH_OBJ);
            $wp_tags[] = $tag_data->name;
        }
        wp_set_post_tags($post_id, implode(',', $wp_tags));
        
        // 迁移自定义字段
        update_post_meta($post_id, 'views', $article->views);
    }
}

echo "文章迁移完成！";