connect_error) {
die("Connection failure:" . $conn->connect_error);
}
// Query to get the database size
$sql = "SELECT table_schema AS 'Database',
ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS 'Size (MB)'
FROM information_schema.TABLES
WHERE table_schema = 'dbs12345678'
GROUP BY table_schema";
$result = $conn->query($sql);
// If there are results
if ($result->num_rows > 0) {
// Get back the database size
$row = $result->fetch_assoc();
echo "
Size of the database: " . $row['Size (MB)'] . " MB (" . number_format($row['Size (MB)'] / 1024, 6) . " GB)
";
} else {
echo "
Unable to retrieve the database size.
";
}
// Close the connection
$conn->close();
?>