How to Connect Multiple Databases using PDO in PHP

In this article, we are going to Connect Multiple Databases using PDO in PHP. This is a short article on how to connect multiple databases in the same query using the PDO in MySQL. First, we are going to recall the older mysql_extension on how to create a query connection in multiple databases to MySQL.

Query of the older mysql_extension in multiple databases.

As you can see in the source code above, it's all the same MySQL connection that we are used in all through query. And, that's the query for the old mysql_extension in PHP. However, in the PDO query, there's a little bit different when we are going to construct the multiple databases connection in MySQL.

Query using PDO in MySQL.

This is the PDO query for the multiple databases connection in the MySQL. Hope that this article will help you a lot. Share us your thoughts and comments below. Thank you so much for dropping by and reading this tutorial post. For more updates, don’t hesitate and feel free to visit this website more often and please share this with your friends or email me at [email protected]. Practice Coding. Thank you very much.