0) {
$whereClauses[] = "s.category_id = ?";
$params[] = $categoryFilter;
$types .= 'i';
}
$where = implode(' AND ', $whereClauses);
// 分页计算
$offset = ($currentPage - 1) * ITEMS_PER_PAGE;
// 获取SVG数据
$sql = "SELECT SQL_CALC_FOUND_ROWS
s.id, s.title, s.content, s.created_at,
u.username, c.name AS category_name
FROM ".DB_PREFIX."svgs s
JOIN ".DB_PREFIX."users u ON s.user_id = u.id
JOIN ".DB_PREFIX."categories c ON s.category_id = c.id
WHERE $where
ORDER BY s.created_at DESC
LIMIT ? OFFSET ?";
$params[] = ITEMS_PER_PAGE;
$params[] = $offset;
$types .= 'ii';
$stmt = $pdo->prepare($sql);
$stmt->execute($params);
$svgs = $stmt->fetchAll();
// 获取总数
$total = $pdo->query("SELECT FOUND_ROWS()")->fetchColumn();
$totalPages = ceil($total / ITEMS_PER_PAGE);
// 获取分类列表
$categories = $pdo->query("SELECT * FROM ".DB_PREFIX."categories ORDER BY name")->fetchAll();
// 获取用户收藏状态
$favorites = [];
if (is_logged_in())) {
$stmt = $pdo->prepare("SELECT svg_id FROM ".DB_PREFIX."favorites WHERE user_id = ?");
$stmt->execute([$_SESSION['user_id']]);
$favorites = $stmt->fetchAll(PDO::FETCH_COLUMN);
}
?>
SVG素材库
暂时没有公开素材，你可以成为第一个上传者！
1): ?>