在PHP中，将2个表中的行从一个数据库复制到另一个数据库中的1个表中

<?php
// 连接源数据库
$sourceHost = 'source_host';
$sourceUser = 'source_user';
$sourcePassword = 'source_password';
$sourceDatabase = 'source_database';

$sourceConnection = new mysqli($sourceHost, $sourceUser, $sourcePassword, $sourceDatabase);
if ($sourceConnection->connect_error) {
    die("连接源数据库失败: " . $sourceConnection->connect_error);
}

// 连接目标数据库
$targetHost = 'target_host';
$targetUser = 'target_user';
$targetPassword = 'target_password';
$targetDatabase = 'target_database';

$targetConnection = new mysqli($targetHost, $targetUser, $targetPassword, $targetDatabase);
if ($targetConnection->connect_error) {
    die("连接目标数据库失败: " . $targetConnection->connect_error);
}

// 查询源数据库表
$sourceTable = 'source_table';
$query = "SELECT * FROM $sourceTable";
$result = $sourceConnection->query($query);

if ($result->num_rows > 0) {
    // 插入目标数据库表
    $targetTable = 'target_table';
    while ($row = $result->fetch_assoc()) {
        $columns = implode(", ", array_keys($row));
        $values = "'" . implode("', '", array_values($row)) . "'";
        $insertQuery = "INSERT INTO $targetTable ($columns) VALUES ($values)";
        $targetConnection->query($insertQuery);
    }
    echo "行复制成功！";
} else {
    echo "没有可复制的行。";
}

// 关闭数据库连接
$sourceConnection->close();
$targetConnection->close();
?>