How can i access in two different databases at the same time, i mean can i implement a search from database1 and save for example the id or another information to a database2?
People are also looking for solutions to the problem: apache - PHP file include - permission denied on Windows 7
Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.
Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.
Find the answer in similar questions on our website.
Answer
Solution:
If you have a user account that can access both databases, just prefix the database name:
as far as I know, you can even do JOINs, although I don't know about possible performance implications.
If you do not have a mySQL account that can access both databases, it's not possible.
Answer
Solution:
Yes. PHP has a few MySQL extensions. However, if you're just getting started, look at the MySQL functions for this. Specifically
mysql_connect()andmysql_select_db()could be used to create separate connections to different databases or switch between them on the same connection.