What are the potential issues when trying to access two different databases within a single PHP script?

When trying to access two different databases within a single PHP script, the potential issues may arise due to conflicting connection settings or database configurations. To solve this, you can create separate database connection objects for each database and specify the connection settings individually for each database. 

// First database connection
$host1 = 'localhost';
$user1 = 'username1';
$pass1 = 'password1';
$dbname1 = 'database1';

$connection1 = new mysqli($host1, $user1, $pass1, $dbname1);

// Second database connection
$host2 = 'localhost';
$user2 = 'username2';
$pass2 = 'password2';
$dbname2 = 'database2';

$connection2 = new mysqli($host2, $user2, $pass2, $dbname2);

// Example query using the first database connection
$query1 = "SELECT * FROM table1";
$result1 = $connection1->query($query1);

// Example query using the second database connection
$query2 = "SELECT * FROM table2";
$result2 = $connection2->query($query2);

// Close connections
$connection1->close();
$connection2->close();

Keywords

MySQL PostgreSQL database connection PHP script SQL injection

Related Questions