How can values from two different databases be combined and manipulated in PHP?

To combine and manipulate values from two different databases in PHP, you can establish connections to both databases using their respective credentials. Then, you can query the databases to retrieve the desired values and store them in variables. Finally, you can perform any necessary operations on these values, such as concatenation, addition, or comparison. 

// Establish connection to first database
$dsn1 = 'mysql:host=localhost;dbname=database1';
$username1 = 'username1';
$password1 = 'password1';
$db1 = new PDO($dsn1, $username1, $password1);

// Establish connection to second database
$dsn2 = 'mysql:host=localhost;dbname=database2';
$username2 = 'username2';
$password2 = 'password2';
$db2 = new PDO($dsn2, $username2, $password2);

// Query first database for value
$stmt1 = $db1->query('SELECT column1 FROM table1');
$value1 = $stmt1->fetchColumn();

// Query second database for value
$stmt2 = $db2->query('SELECT column2 FROM table2');
$value2 = $stmt2->fetchColumn();

// Combine and manipulate values
$result = $value1 . ' ' . $value2;
echo $result;

Keywords

PHP databases SQL data manipulation data integration

Related Questions