shopnc连接多个数据库

<?php
// 数据库配置
$dbConfigs = [
    'db1' => [
        'host' => 'localhost',
        'user' => 'user1',
        'password' => 'password1',
        'database' => 'database1',
    ],
    'db2' => [
        'host' => 'localhost',
        'user' => 'user2',
        'password' => 'password2',
        'database' => 'database2',
    ],
];

// 连接数据库
$connections = [];
foreach ($dbConfigs as $key => $config) {
    $connections[$key] = new PDO(
        "mysql:host={$config['host']};dbname={$config['database']}",
        $config['user'],
        $config['password']
    );
}

// 使用数据库连接
$db1 = $connections['db1'];
$db2 = $connections['db2'];

// 示例查询
$stmt1 = $db1->query("SELECT * FROM table1");
$stmt2 = $db2->query("SELECT * FROM table2");

// 处理查询结果
while ($row = $stmt1->fetch(PDO::FETCH_ASSOC)) {
    // 处理数据
}

while ($row = $stmt2->fetch(PDO::FETCH_ASSOC)) {
    // 处理数据
}
?>