query('SELECT COUNT(*) AS file_count, SUM(size) AS file_overall_size FROM files');
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
$file_count = $row['file_count'];
$file_size = $row['file_overall_size'];
$suffix = 'MB';
$file_size /= 1024 * 1024; // MB
if ($file_size >= 1024) {
$file_size /= 1024;
$suffix = 'GB';
}
$file_size = sprintf('%.2f%s', $file_size, $suffix);
echo '' ?>