which db connection will be used if connection object not provided in query?

Question

$db1 = mysql_connect('host1', 'user', 'user'); 
$db2 = mysql_connect('host2', 'user', 'user', true); 

mysql_select_db('db1', $db1);
mysql_select_db('db2', $db2);


mysql_query("select * from table1");

You are using [an **obsolete** database API](http://stackoverflow.com/q/12859942/19068) and should use a [modern replacement](http://php.net/manual/en/mysqlinfo.api.choosing.php). — Quentin, Sep 26 '13 at 13:55
i need two servers to try it though. @aldanux Thanks. i am working on existing project so can't use modern replacement. Thanks — user991554, Sep 26 '13 at 13:57
for existing project, do you think i should use PDO in 2-3 files. are you NUTTS — user991554, Sep 27 '13 at 12:16

score 0 · Answer 1 · answered Sep 26 '13 at 15:16

Read the documentation (http://uk1.php.net/manual/en/function.mysql-query.php):

link_identifier

The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect() is assumed. If no such link is found, it will try to create one as if mysql_connect() was called with no arguments. If no connection is found or established, an E_WARNING level error is generated.

So in your case, db2.

which db connection will be used if connection object not provided in query?

1 Answers1