php - 如何同时连接两个mysql数据库

Question

我在名为 connect.php 的文件中使用它:

$username_mysql = "root";
$password_mysql = "";
$database_mysql = "bdd_imvert";
//$database_mysql = "imprimvert_renouvellement";
$db = @mysql_connect($hostname_mysql, $username_mysql, $password_mysql) or die(mysql_error());
mysql_select_db($database_mysql,$db);

$hostnameivert_mysql = "localhost";
$usernameivert_mysql = "root";
$passwordivert_mysql = "";
$databaseivert_mysql = "ivert";
//$database_mysql = "imprimvert_renouvellement";
$db1 = @mysql_connect($hostnameivert_mysql, $usernameivert_mysql, $passwordivert_mysql) or die(mysql_error());
mysql_select_db($databaseivert_mysql,$db1);`

我将其包含在包含以下内容的页面中:

$sql = "select * from ivert_users where id=".GetSQLValueString($user_id,"int");
$re = @mysql_query($sql,$db)

但是，当我这样做时，我收到错误:

'ivert.ivert_users' does not exist

我不确定为什么会出现此错误，任何帮助将不胜感激。

Answer 1

你的代码没有问题。我尝试了同样的方法，它对我有用。你的查询肯定有问题。因为您的错误消息显示连接已发生，但您的查询返回了错误。引用这个可能有帮助。

或者第二个原因可能是您没有为第一个数据库定义主机。

<?php 

$hostnameivert_mysql = "localhost";
$username_mysql      = "root";
$password_mysql      = "pma";
$database_mysql      = "olivenation";
$db                  = @mysql_connect($hostname_mysql, $username_mysql, $password_mysql) or die(mysql_error());

mysql_select_db($database_mysql,$db);

echo ("<pre>");print_r($db);echo("</pre>");

$hostnameivert_mysql = "localhost";
$usernameivert_mysql = "root";
$passwordivert_mysql = "pma";
$databaseivert_mysql = "practical";

$db1=@mysql_connect($hostnameivert_mysql, $usernameivert_mysql, $passwordivert_mysql) or die(mysql_error());

mysql_select_db($databaseivert_mysql,$db1);

echo ("<pre>");print_r($db1);echo("</pre>");

$sql = "select * from product_master where id=1";
$re  = @mysql_query($sql,$db);

echo ("<pre>");print_r(mysql_fetch_array($re));echo("</pre>");

$sql = "select * from users";
$re  = @mysql_query($sql,$db1);

echo ("<pre>");print_r(mysql_fetch_array($re));echo("</pre>");

?>