How to connect to multiple MySQL Databases in PHP

How to connect to multiple MySQL Databases in PHP

Sometimes, we may connect to multiple MySQL databases in a PHP project. We need to write multiple mysql_connect and mysql_select_db. However, some children's shoes always call the last database.

In fact, the correct method is:

// Database 1

$ Conn1 = mysql_connect ('localhost: 100', 'root', '123', true );

Mysql_select_db ('db1', $ conn1 );

Mysql_query ('set names utf8 ');

// Database 2

$ Conn2 = mysql_connect ('localhost: 100', 'root', '123', true );

Mysql_select_db ('db2 ', $ conn2 );

Mysql_query ('set names utf8 ');

The principle is to set the "new_link" parameter to true in the mysql_connect function and force a new connection.

Mysql_connect Function

Resource mysql_connect ([string server [, string username [, string password [, bool new_link [, int client_flags])