How to connect multiple MySQL databases on one web page?

PHP

This article explains how to connect multiple MySQL databases to one web page. This is useful for accessing data from multiple databases. 
There are two ways to connect multiple MySQL databases to one web page:
  • Using MySQLi (MySQL Enhanced)
  • Using PDO (PHP Data Objects)
Syntax:
  • 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”);
Program:This program uses MySQLi to connect multiple databases on one web page.
// 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 (< / code> "ERROR: Could not connect" . mysqli_connect_error()); } echo "< br >" ;  
// 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 (< / code> "ERROR: Could not connect" . mysqli_connect_error()); } echo "< br > < br > Display the list of all Databases: < br >" ;  
// 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` ]. "< br >" ; }  
?>
Output:



Get Solution for free from DataCamp guru