db multiconnect

[code739]

hi all,

i just want to ask if its possible to have a two or even more database connection in a php run application
like

db_connect---db1
fetch data

db_connect--db2
fetch data
db_close --db2

if its not possible.
how can i get data from other database table
appriciate youre answers.

[|-|x]

You should be able to interact with multiple databases without needing multiple connections open from php. Check out the mysql use command.

You can also reference the databases directly in your query.

SELECT * FROM db1.tableA;
SELECT * FROM db2.tableA;

[code739]

what if they both database dont have the same database server would it be matter?

You can't hot swap dbs if on diff servers unless you include the link resource as a parameter. Mysqli forces you to do this.

This looks interesting:

http://stackoverflow.com/questions/6930230/php-db-class-with-mysqli-which-support-multiple-connections