prepare("SELECT COUNT(*) FROM files WHERE $whereSql"); $countStmt->execute($bind); $total = (int)$countStmt->fetchColumn(); $pages = max(1, (int)ceil($total / $perPage)); if ($page > $pages) $page = $pages; $sql = "SELECT f.*, u.display_name AS uploader_name FROM files f LEFT JOIN users u ON f.uploader_id = u.id WHERE $whereSql ORDER BY f.created_at DESC LIMIT $perPage OFFSET $offset"; $stmt = $pdo->prepare($sql); $stmt->execute($bind); $files = $stmt->fetchAll(PDO::FETCH_ASSOC); // ========== 分类列表 ========== $cats = $pdo->query("SELECT name FROM file_categories ORDER BY sort ASC")->fetchAll(PDO::FETCH_COLUMN); // ========== 辅助函数 ========== function file_icon(string $mime, string $filename): string { $map = [ 'pdf' => '📄', 'doc' => '📝', 'docx' => '📝', 'xls' => '📊', 'xlsx' => '📊', 'csv' => '📊', 'ppt' => '📽️', 'pptx' => '📽️', 'zip' => '🗜️', 'rar' => '🗜️', '7z' => '🗜️', 'gz' => '🗜️', 'jpg' => '🖼️', 'jpeg'=> '🖼️', 'png' => '🖼️', 'gif' => '🖼️', 'webp' => '🖼️', 'svg' => '🎨', 'mp4' => '🎬', 'webm' => '🎬', 'mov' => '🎬', 'mp3' => '🎵', 'wav' => '🎵', 'flac' => '🎵', ]; $ext = strtolower(pathinfo($filename, PATHINFO_EXTENSION)); return $map[$ext] ?? '📁'; } function is_previewable(string $mime, string $filename = ''): bool { $ext = strtolower(pathinfo($filename, PATHINFO_EXTENSION)); // 原生支持 if (in_array($mime, ['image/jpeg','image/png','image/gif','image/webp','image/svg+xml','image/bmp', 'video/mp4','video/webm','audio/mpeg','audio/wav','application/pdf'], true)) return true; // 扩展名支持（更准） if (in_array($ext, ['jpg','jpeg','png','gif','webp','bmp','svg', 'mp4','webm','mov','mp3','wav','flac','ogg', 'pdf','txt','csv','md','json','xml', 'doc','docx','xls','xlsx','ppt','pptx','odt','ods','odp'], true)) return true; return false; } function fmt_size(int $b): string { if ($b >= 1024*1024*1024) return round($b/1024/1024/1024, 2) . ' GB'; if ($b >= 1024*1024) return round($b/1024/1024, 2) . ' MB'; if ($b >= 1024) return round($b/1024, 1) . ' KB'; return $b . ' B'; } ?>

共个文件 · 搜索「」 · 类别「」

📭

暂无文件

	文件名	大小	上传者	上传时间	下载	操作
	60 ? mb_substr($f['filename'], 0, 57) . '...' : $f['filename']) ?>				⬇️	👁️ 预览 ⬇️ 下载

1): ?>