dedecms远程服务器同步向导

<?php
// 源服务器配置
$source_host = 'source_server_ip';
$source_user = 'source_username';
$source_pass = 'source_password';
$source_db = 'source_database';

// 目标服务器配置
$target_host = 'target_server_ip';
$target_user = 'target_username';
$target_pass = 'target_password';
$target_db = 'target_database';

// 连接源服务器数据库
$source_conn = mysqli_connect($source_host, $source_user, $source_pass, $source_db);
if (!$source_conn) {
    die('连接源服务器数据库失败: ' . mysqli_connect_error());
}

// 连接目标服务器数据库
$target_conn = mysqli_connect($target_host, $target_user, $target_pass, $target_db);
if (!$target_conn) {
    die('连接目标服务器数据库失败: ' . mysqli_connect_error());
}

// 同步数据
$sql = "SELECT * FROM your_table";
$result = mysqli_query($source_conn, $sql);
while ($row = mysqli_fetch_assoc($result)) {
    $insert_sql = "INSERT INTO your_table (column1, column2, column3) VALUES ('" . $row['column1'] . "', '" . $row['column2'] . "', '" . $row['column3'] . "')";
    mysqli_query($target_conn, $insert_sql);
}

mysqli_close($source_conn);
mysqli_close($target_conn);

echo "同步完成";
?>