There are two ways to connect multiple MySQL databases to one web page:
- Using MySQLi (MySQL Enhanced)
- Using PDO (PHP Data Objects)
- MySQLi procedural syntax:
$link = mysqli_connect (“host_name”, “user_name”, “password”, “database_name”); - MySQLi object oriented syntax:
$link = new mysqli (“host_name”, “user_name”, “password”, “database_name”); - PDO (PHP Data Objects) syntax:
$pdo = new PDO (“mysql: host = host_name; dbname = database_name”, “user_name”, “password”);
// PHP program for connecting multiple MySQL databases
// into one web page
// Connect the first database
// Database name = > database1
// Default username for localhost = > root
// The default password for localhost is ’ ’ (none) $link1 = mysqli_connect ( "localhost" , "root" , "" , "database1" ) ;
// Test the connection if ( $link1 = = true) { echo " database1 Connected Successfully " ; } else { die ( "ERROR: Could not connect" . mysqli_connect_error()); } echo "
" ;
// Connect the first database
// Database name = > database1 $link2 = mysqli_connect ( "localhost" , "root" , "" , "database2" );
// Test the connection if ( $link2 = = true) { echo " database2 Connected Successfully " ; } else { die ( "ERROR: Could not connect" . mysqli_connect_error()); } echo "
Display the list of all Databases:
" ;
// Database connection $link = mysqli_connect ( ’localhost’ , ’root’ , ’ ’ );
// List all database names $res = mysqli_query ( $link , "SHOW DATABASES" ); while ( $row = mysqli_fetch_assoc ( $res )) { echo $row [ ’Database’ ]. "
" ; }
?> Output:
