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: