multipls db connections?

[Anon]

Hi!

I just would like to know that, for PHP, is it possible to connect to multiple DBs at once. Would it know which table of the databases an sql statement is referring to?

eg. pseudo code:

connect(); // to db1 which contains table_A, table_B
connect(); // to db2 which contains table_C

query("select some,stuff from table_A where 1");

query("select this, and , that from table_B, table_C where 1");

would the above work?

thank you

[[deleted]]

Yes, As long as the databasenames or usernames are different.

PHP does connection pooling, you cannot open two connections to one database using the same username. If you do try to open a second connection using the same data, you will get a pointer to the first connection. (you will have one connection with two resource-idntifiers pointing to it)

The databasename or the username must be different.