What are the best practices for handling multiple database connections in PHP scripts?

When handling multiple database connections in PHP scripts, it is important to establish separate database connections for each database to prevent conflicts and ensure data integrity. One common approach is to create separate instances of the PDO class for each database connection and use them accordingly in your script. 

// First database connection
$dsn1 = 'mysql:host=localhost;dbname=database1';
$username1 = 'username1';
$password1 = 'password1';
$pdo1 = new PDO($dsn1, $username1, $password1);

// Second database connection
$dsn2 = 'mysql:host=localhost;dbname=database2';
$username2 = 'username2';
$password2 = 'password2';
$pdo2 = new PDO($dsn2, $username2, $password2);

// Example query for first database
$query1 = $pdo1->query('SELECT * FROM table1');
$result1 = $query1->fetchAll();

// Example query for second database
$query2 = $pdo2->query('SELECT * FROM table2');
$result2 = $query2->fetchAll();

Keywords

database connections PHP scripts PDO mysqli error handling

Related Questions