Change language

How to connect multiple MySQL databases on one web page?

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 ( "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:

Shop

Best laptop for Sims 4

$

Best laptop for Zoom

$499

Best laptop for Minecraft

$590

Best laptop for engineering student

$

Best laptop for development

$

Best laptop for Cricut Maker

$

Best laptop for hacking

$890

Best laptop for Machine Learning

$950

Latest questions

NUMPYNUMPY

psycopg2: insert multiple rows with one query

12 answers

NUMPYNUMPY

How to convert Nonetype to int or string?

12 answers

NUMPYNUMPY

How to specify multiple return types using type-hints

12 answers

NUMPYNUMPY

Javascript Error: IPython is not defined in JupyterLab

12 answers

Wiki

Python OpenCV | cv2.putText () method

numpy.arctan2 () in Python

Python | os.path.realpath () method

Python OpenCV | cv2.circle () method

Python OpenCV cv2.cvtColor () method

Python - Move item to the end of the list

time.perf_counter () function in Python

Check if one list is a subset of another in Python

Python os.path.join () method