是否可以连接到多个数据库E.g.database1，database2 [英] is it possible to connect to multiple database E,g. database1, database2

问题描述

是否可以连接到多个数据库?例如.数据库1，数据库2".

is it possible to connect to multiple database? E,g. "database1, database2".

如果不可能，任何人都可以向我展示如何连接多个数据库.

if is not possible, anyone can show me how to connect, multiple database.

$db_host        = 'localhost';
$db_user        = 'username';
$db_pass        = 'password';
$db_database        = 'username_database1, username_database2'; 

/* End config */


$link = @mysql_connect($db_host,$db_user,$db_pass) or die('Unable to establish a DB connection');

mysql_set_charset('utf8');
mysql_select_db($db_database,$link);

谢谢.

推荐答案

是的，以前已经回答了这个问题，但是您应该尝试使用 mysqli .

Yes this question has been answered before, but you should try to use mysqli instead.

PHP mysql 扩展正式在5.5中弃用了

The PHP mysql extension is officially deprecated in 5.5

下面的代码适用于计划使用 mysqli (程序形式)连接到多个数据库的人员.您可以检查它是否确实适用于多个数据库.

The code below is for those planning to use mysqli (procedural-form) to connect to multiple database. You can check to see that it does indeed work with more than one database.

$db1 = @mysqli_connect('hostname', 'username', 'password', 'DB1');
$db2 = @mysqli_connect('hostname', 'username', 'password', 'DB2');
$obj1 = array();
$obj2 = array();
if  ($res = mysqli_query($db1, 'SHOW TABLES')) {
    while ($obj = mysqli_fetch_object ( $res )) $obj1[] = $obj;
    mysqli_free_result ( $res );
}
if  ($res = mysqli_query($db2, 'SHOW TABLES')) {
    while ($obj = mysqli_fetch_object ( $res )) $obj2[] = $obj;
    mysqli_free_result ( $res );
}
var_dump($obj1);
echo '<hr/>';
var_dump($obj2);
echo '<hr/>';
@mysqli_close($db1);
@mysqli_close($db2);
die('');

这篇关于是否可以连接到多个数据库E.g.database1，database2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！