dedecms程序更换

<?php
// 连接数据库
$db_old = new mysqli('old_host', 'old_user', 'old_password', 'old_dbname');
$db_new = new mysqli('new_host', 'new_user', 'new_password', 'new_dbname');

// 检查连接
if ($db_old->connect_error || $db_new->connect_error) {
    die('数据库连接失败');
}

// 迁移文章数据
$sql = "SELECT * FROM dede_archives";
$result = $db_old->query($sql);

while ($row = $result->fetch_assoc()) {
    $new_sql = "INSERT INTO dede_archives (typeid, title, writer, pubdate, sortrank, flag, litpic, userip, lastpost, scores, goodpost, badpost, textlink, click) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
    $stmt = $db_new->prepare($new_sql);
    $stmt->bind_param('isssssssiiiiis', $row['typeid'], $row['title'], $row['writer'], $row['pubdate'], $row['sortrank'], $row['flag'], $row['litpic'], $row['userip'], $row['lastpost'], $row['scores'], $row['goodpost'], $row['badpost'], $row['textlink'], $row['click']);
    $stmt->execute();
}

echo "数据迁移完成";

// 关闭连接
$db_old->close();
$db_new->close();
?>