connect_error) {
die("Connection failed: " . $connect->connect_error);
}
// Query to list tables
$test_query = "SHOW TABLES";
$result = $connect->query($test_query);
$tblCnt = 0;
if ($result) {
while ($row = $result->fetch_array()) {
$tblCnt++;
// echo $row[0] . "
\n"; // Optional
}
}
// Output result
if ($tblCnt === 0) {
echo "There are no tables
\n";
} else {
echo "There are $tblCnt tables
\n";
}
// Close connection
$connect->close();
?>