phpcms转dede

<?php
// 连接 phpCMS 数据库
$phpcms_db = new mysqli('localhost', 'phpcms_user', 'phpcms_pass', 'phpcms_db');
if ($phpcms_db->connect_error) {
    die("连接失败: " . $phpcms_db->connect_error);
}

// 连接 DedeCMS 数据库
$dedecms_db = new mysqli('localhost', 'dedecms_user', 'dedecms_pass', 'dedecms_db');
if ($dedecms_db->connect_error) {
    die("连接失败: " . $dedecms_db->connect_error);
}

// 查询 phpCMS 文章数据
$sql = "SELECT * FROM phpcms_articles";
$result = $phpcms_db->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        // 插入数据到 DedeCMS
        $insert_sql = "INSERT INTO dedecms_archives (typeid, title, writer, pubdate, sortrank, lastpost, clicks, inputtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
        $stmt = $dedecms_db->prepare($insert_sql);
        $stmt->bind_param("isssisss", $row['typeid'], $row['title'], $row['writer'], $row['pubdate'], $row['sortrank'], $row['lastpost'], $row['clicks'], $row['inputtime']);
        $stmt->execute();
    }
}

$phpcms_db->close();
$dedecms_db->close();
?>