You can still use PDO in order to access as many databases you need
using different handlers. This is a way for e.g.
$dbhost1 = 'localhost';
$dbuser1 = 'test';
$dbpass1 = '12345';
$db1 = 'database_name';
$dbh1 = new PDO('mysql:host='.$dbhost1.';dbname='.$db1, $dbuser1,
$dbpass1);
$dbhost2 = 'database.example.net';
$dbuser2 = 'test';
$dbpass2 = '12345';
$db2 = 'database_name';
$dbh2 = new PDO('mysql:host='.$dbhost2.';dbname='.$db2, $dbuser2,
$dbpass2);
You can query the database buy doing:
$sth = $dbh->prepare($query);
$sth->execute();
Have in mind that mysql is not the only option you have but you should
check the documentation for more info.
http://www.php.net/manual/el/ref.pdo.php
Chris wrote:
Suamya Srivastava wrote:
Hello,
In a single PHP code, I want to connect to two mysql databases with
totally different authentication information. Is it possible?
See http://php.net/mysql_connect - you need to set 'new_link' to true
in the mysql_connect call.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
