Suppose you want to check the connectivity of multiple MySQL servers, and connect to the servers in a loop. Here are two example code snippets. One that uses a for loop and one using a foreach loop.
Table of Contents
show
Connect to multiple MySQL servers in a foreach loop
function checkMysql() {
$mysql_nodes = array(
"server-01",
"server-02",
"server-03",
"server-04",
"server-05",
"server-06",
"server-07",
"server-08",
"server-09",
"server-10",
"server-11"
);
foreach ($mysql_nodes as $mysql_node) {
$mysqli = new mysqli($mysql_node, "username", "passw0rd", "database");
if($result = $mysqli->query("SHOW TABLES")) {
echo $mysql_node. "checked";
mysqli_free_result($result);
}
$mysqli->close();
}
}
Connect to multiple MySQL servers in a for loop
function checkMysql() {
$mysql_nodes = array(
"server-01",
"server-02",
"server-03",
"server-04",
"server-05",
"server-06",
"server-07",
"server-08",
"server-09",
"server-10",
"server-11"
);
for ($i = 0; $i < sizeof($mysql_nodes); ++$i) {
$mysqli = new mysqli($mysql_node, "username", "passw0rd", "database");
if($result = $mysqli->query("SHOW TABLES")) {
echo $mysql_node. "checked";
mysqli_free_result($result);
}
$mysqli->close();
}
}
Rate this post!