// Function to close queries and database connection
function closeDatabase($resultSets, $connection) {
try {
// Free result sets
if (is_array($resultSets)) {
foreach ($resultSets as $resultSet) {
if ($resultSet) {
mysqli_free_result($resultSet);
}
}
}
// Close the database connection
if ($connection) {
mysqli_close($connection);
}
echo "All queries and connections closed successfully.";
} catch (Exception $e) {
echo "Error closing database resources: " . $e->getMessage();
}
}