What are some best practices for efficiently querying multiple databases in PHP?

When querying multiple databases in PHP, it is best to establish separate database connections for each database to ensure efficient querying and prevent conflicts. This can be achieved by creating multiple instances of the PDO class, each pointing to a different database. By using try-catch blocks to handle any potential connection errors, you can ensure a smooth querying process across multiple databases. 

try {
    $db1 = new PDO('mysql:host=localhost;dbname=database1', 'username', 'password');
    $db2 = new PDO('mysql:host=localhost;dbname=database2', 'username', 'password');

    // Query database 1
    $query1 = $db1->query('SELECT * FROM table1');
    $result1 = $query1->fetchAll();

    // Query database 2
    $query2 = $db2->query('SELECT * FROM table2');
    $result2 = $query2->fetchAll();

    // Process results
    // ...

} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

Keywords

MySQL PostgreSQL PDO database connection query optimization

Related Questions