Re: [PHP-DB] Connecting to more than 2 databases from a single PHP script.
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
[PHP-DB] Connecting to more than 2 databases from a single PHP script.
Hello,
In a single PHP code, I want to connect to two mysql databases with
totally different authentication information. Is it possible?
Right now snippet of my code looks something like this:
?php
.
$conn_1=mysql_connect('host1','user1','pass1');
$conn_2=mysql_connect{'host2','user2','pass2');
$db_list = mysql_list_dbs($conn_2);
while ($row = mysql_fetch_object($db_list)) {
echo $row-Database . \n;
}
?
However when I try to list all the databases in host2, it instead lists
the database in host1.
host1 and host2 are different machines and the databases in each of them
are entirely different.
I read that the new_link parameter might be used here but I couldnt figure
out how to do that.
I am new to PHP...so any help would be great!!
-suamya.
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Connecting to more than 2 databases from a single PHP script.
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. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
