blocks|key|1707209|text|您需要将布尔值true作为可选的第四个参数传递给mysql_connect()。有关详细信息，请参阅PHP's+mysql_connect()+documentation。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1707210|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/mysql_connect^0|1E|Z|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You'll need to pass a boolean true as the optional fourth argument to mysql_connect(). See <a href="http://php.net/mysql_connect" rel="noreferrer">PHP's mysql_connect() documentation</a> for more info.

blocks|key|1707264|text|我建议使用两个连接处理程序。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1707265|+++$old+=+mysql_connect('old.database.com',+'user',+'pass);
+++mysql_select_db('old_db',+$old);


+++$new+=+mysql_connect('new.database.com','user','pass);
+++mysql_select_db('new_db',+$new)

+++//+run+select+query+on+$old
+++//+run+matching+insert+query+on+$new|code-block|syntax|javascript|1707266|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I would suggest using two connection handlers

<pre><code> $old = mysql_connect('old.database.com', 'user', 'pass);
 mysql_select_db('old_db', $old);


 $new = mysql_connect('new.database.com','user','pass);
 mysql_select_db('new_db', $new)

 // run select query on $old
 // run matching insert query on $new
</code></pre>

blocks|key|1707299|text|卢卡斯是对的。我假设这两个数据库都托管在同一主机上。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1707300|或者，您可以只创建1个db连接，并根据需要继续交换数据库。下面是伪代码。|1707301|$db_conn+=+connect_db(host,+user,+pwd);
mysql_select_db('existing_db',+$db_conn);
+--+do+selects+and+scrub+data+--
mysql_select_db('new_db',+$db_conn);
--+insert+the+required+data+--|code-block|syntax|javascript|1707302|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Lucas is correct. I assume that both the databases are hosted on the same host.

Alternatively, you can create only 1 db connection and keep swapping the databases as required. Here is pseudo code.

<pre><code>$db_conn = connect_db(host, user, pwd);
mysql_select_db('existing_db', $db_conn);
 -- do selects and scrub data --
mysql_select_db('new_db', $db_conn);
-- insert the required data --
</code></pre>

blocks|key|1492363|text|如果您的数据库用户可以访问这两个数据库，并且它们位于同一台服务器上，则可以使用一个连接，并且只需在表名之前指定要使用的数据库。示例：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1492364|SELECT+column
FROM+database.table|code-block|syntax|javascript|1492365|根据您需要做的事情，您也许能够执行INSERT+INTO并节省大量处理时间。|offset|length|style|CODE|1492366|INSERT+INTO+database1.table+(column)
SELECT+database2.table.column
FROM+database2.table|1492367|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.0/en/insert-select.html^0|0|0|H|B|H|B|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@$I|Z|J|10|K|L]]|9|@$I|11|J|12|1|13]]|A|$]]|$1|M|3|N|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

If your database user has access to both databases and they are on the same server, you can use one connection and just specify the database you want to work with before the table name. Example:

<pre><code>SELECT column
FROM database.table
</code></pre>

Depending on what you need to do, you might be able to do an <a href="http://dev.mysql.com/doc/refman/5.0/en/insert-select.html" rel="noreferrer"><code>INSERT INTO</code></a> and save a bunch of processing time.

<pre><code>INSERT INTO database1.table (column)
SELECT database2.table.column
FROM database2.table
</code></pre>

blocks|key|1492421|text|如果可以，可以使用PDO:您可以打开任意数量的数据库连接。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1492422|另外，假设您一遍又一遍地执行相同的查询，则可以使用预准备语句。|1492423|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

If it's an option, use PDO: you can have as many database connections open as you like.

Plus, assuming your executing the same queries over and over, you can use prepared statements.

blocks|key|1707439|text|通过以下代码，您可以轻松地同时使用两个数据库：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1707440|<?php
++define('HOST',+"YOURHOSTNAME");
++define('USER',+"YOURHOSTNAME");
++define('PASS',+"YOURHOSTNAME");
++define('DATABASE1',+"NAMEOFDATABASE1");
++define('DATABASE2',+"NAMEOFDATABASE2");

++$DATABASE1++=+mysqli_connect(HOST,+USER,+PASS,+DATABASE1);
++$DATABASE2++=+mysqli_connect(HOST,+USER,+PASS,+DATABASE2);
++if(!$DATABASE1){
++++++die("DATABASE1+CONNECTION+ERROR:+".mysqli_connect_error());
+++}
++if(!$DATABASE2){
++++++die("DATABASE2+CONNECTION+ERROR:+".mysqli_connect_error());
+++}


+++$sql+=+"SELECT+*+FROM+TABLE";+++/*+You+can+use+your+own+query+*/

+++$DATABASE1_QUERY+=+mysqli_query($DATABASE1,+$sql);
+++$DATABASE2_QUERY+=+mysqli_query($DATABASE2,+$sql);

+++$DATABASE1_RESULT+=+mysqli_fetch_assoc($DATABASE1_QUERY);
+++$DATABASE2_RESULT+=+mysqli_fetch_assoc($DATABASE2_QUERY);

+++/*+SHOW+YOUR+RESULT+HERE+WHICH+DATABASE+YOU+WANT+FROM+*/
+++echo++$DATABASE1_RESULT['id'];
+++echo++$DATABASE2_RESULT['id'];


++/*After+complete+your+all+work+don't+forgot+about+close+database+connections*/
++mysqli_close($DATABASE1);
++mysqli_close($DATABASE2);
++++++?>|code-block|syntax|javascript|1707441|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can easily use 2 databases in same time with following Codes:

<pre><code>&lt;?php
 define('HOST', "YOURHOSTNAME");
 define('USER', "YOURHOSTNAME");
 define('PASS', "YOURHOSTNAME");
 define('DATABASE1', "NAMEOFDATABASE1");
 define('DATABASE2', "NAMEOFDATABASE2");

 $DATABASE1 = mysqli_connect(HOST, USER, PASS, DATABASE1);
 $DATABASE2 = mysqli_connect(HOST, USER, PASS, DATABASE2);
 if(!$DATABASE1){
 die("DATABASE1 CONNECTION ERROR: ".mysqli_connect_error());
 }
 if(!$DATABASE2){
 die("DATABASE2 CONNECTION ERROR: ".mysqli_connect_error());
 }


 $sql = "SELECT * FROM TABLE"; /* You can use your own query */

 $DATABASE1_QUERY = mysqli_query($DATABASE1, $sql);
 $DATABASE2_QUERY = mysqli_query($DATABASE2, $sql);

 $DATABASE1_RESULT = mysqli_fetch_assoc($DATABASE1_QUERY);
 $DATABASE2_RESULT = mysqli_fetch_assoc($DATABASE2_QUERY);

 /* SHOW YOUR RESULT HERE WHICH DATABASE YOU WANT FROM */
 echo $DATABASE1_RESULT['id'];
 echo $DATABASE2_RESULT['id'];


 /*After complete your all work don't forgot about close database connections*/
 mysqli_close($DATABASE1);
 mysqli_close($DATABASE2);
 ?&gt;
</code></pre>

blocks|key|1707519|text|第一次连接两个数据库|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1707520|$database1+=+mysql_connect("localhost","root","password");
$database2+=+mysql_connect("localhost","root","password");|code-block|syntax|javascript|1707521|现在选择数据库|1707522|$database1_select+=+mysql_select_db("db_name_1")+or+die("Can't+Connect+To+Database",$database1);
$database_select+=+mysql_select_db("db_name_2")+or+die("Can't+Connect+To+Database",$database2);|1707523|现在，如果我们想运行查询，然后在最后指定数据库名称，如下所示，|1707524|$select+=+mysql_query("SELECT+*+FROM+table_name",$database1);|1707525|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

First Connect Two Database

<pre><code>$database1 = mysql_connect("localhost","root","password");
$database2 = mysql_connect("localhost","root","password");
</code></pre>

Now Select The Database 

<pre><code>$database1_select = mysql_select_db("db_name_1") or die("Can't Connect To Database",$database1);
$database_select = mysql_select_db("db_name_2") or die("Can't Connect To Database",$database2);
</code></pre>

Now if we want to run query then specify database Name at the end like,

<pre><code>$select = mysql_query("SELECT * FROM table_name",$database1);
</code></pre>

I am trying to connect to 2 databases on the same instance of MySQL from 1 PHP script.

At the moment the only way I've figured out is to connect to both databases with a different user for each.

I am using this in a migration script where I am grabbing data from the original database and inserting it into the new one, so I am looping through large lists of results.

Connecting to 1 database and then trying to initiate a second connection with the same user just changes the current database to the new one.

Any other ideas?

How to connect to 2 databases at the same time in PHP

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在尝试连接到2个数据库上的同一实例的MySQL从1php脚本。目前，我想出的唯一方法是使用不同的用户连接到这两个数据库。我在一个迁移脚本中使用它，我从原始数据库中获取数据并将其插入到新数据库中，因此我循环遍历大型结果列表。连接到1个数据库，然后尝试启动与同一用户的第二个连接，只会将当前数据库更改为新数据库。还有其他...

问如何在PHP中同时连接两个数据库
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在PHP中同时连接两个数据库EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在PHP中同时连接两个数据库
EN