prepare("SELECT id FROM article_categories WHERE slug = ?");
$stmt->execute([$categorySlug]);
$cat = $stmt->fetch();
if($cat) {
$where .= " AND a.category_id = ?";
$params[] = $cat['id'];
}
}
$currentCategory = null;
if($categorySlug) {
$stmt = $db->prepare("SELECT * FROM article_categories WHERE slug = ?");
$stmt->execute([$categorySlug]);
$currentCategory = $stmt->fetch();
}
// 获取总数
$stmt = $db->prepare("SELECT COUNT(*) FROM articles a $where");
$stmt->execute($params);
$total = $stmt->fetchColumn();
$totalPages = ceil($total / $perPage);
// 获取文章列表
$offset = ($page - 1) * $perPage;
$stmt = $db->prepare("SELECT a.*, ac.name as category_name
FROM articles a
LEFT JOIN article_categories ac ON a.category_id = ac.id
$where
ORDER BY a.is_featured DESC, a.created_at DESC
LIMIT $perPage OFFSET $offset");
$stmt->execute($params);
$articles = $stmt->fetchAll();
// 获取所有分类
$stmt = $db->query("SELECT ac.*, COUNT(a.id) as article_count
FROM article_categories ac
LEFT JOIN articles a ON ac.id = a.category_id AND a.is_published = 1
GROUP BY ac.id
ORDER BY ac.sort_order");
$categories = $stmt->fetchAll();
// 获取侧边栏广告
$stmt = $db->prepare("SELECT * FROM ads WHERE position_id = 3 AND is_active = 1
AND (start_date IS NULL OR start_date <= CURDATE())
AND (end_date IS NULL OR end_date >= CURDATE()) LIMIT 1");
$stmt->execute();
$sidebarAd = $stmt->fetch();
?>
<?php echo $currentCategory ? htmlspecialchars($currentCategory['name']) : '文章'; ?> - <?php echo SITE_NAME; ?>