Page 1 of 1
Solved: How to open 2 mysql databases in php
Posted: Thu Aug 16, 2012 6:50 am
by mister_v
Hi,
I want to access 2 MYSQL databases from the same php script.
Without closing one and opening the other one.
I want to select queries from both databases at the same time.
Thanks
Re: How to open 2 mysql databases in php
Posted: Thu Aug 16, 2012 9:05 am
by chris
You can add a 4th parameter in mysql_connect,
this will open a new separated connection.
Code: Select all
$dbconn1 = mysql_connect($hostname, $username, $password);
$dconn2 = mysql_connect($hostname, $username, $password, true);
mysql_select_db('database1', $dbconn1);
mysql_select_db('database2', $dbconn2);
$result1=mysql_query("Select * FROM table",$dbconn1);
$line1=mysql_fetch_array($result1, MYSQL_NUM);
$result2=mysql_query("Select * FROM tableOtherDB",$dbconn2);
$line2=mysql_fetch_array($result2, MYSQL_NUM);
Perhaps a better way is to use mysqli
(You need to compile php with it)
Code: Select all
$mysqli1 = new mysqli($hostname, $username, $password, 'database1');
$mysqli2 = new mysqli($hostname, $username, $password, 'database2');
$result1=mysqli_query($mysqli1,"Select * FROM table");
$result2=mysqli_query($mysqli2,"Select * FROM tableOtherDB");
$line1=mysqli_fetch_array($result1, MYSQL_NUM);
$line2=mysqli_fetch_array($result2, MYSQL_NUM);
Re: How to open 2 mysql databases in php
Posted: Thu Aug 16, 2012 6:19 pm
by mister_v
Thanks
Didn't know about the 4th parameter true.