query("SELECT tc.*, COUNT(t.id) as tool_count
FROM tool_categories tc
LEFT JOIN tools t ON tc.id = t.category_id AND t.is_active = 1
GROUP BY tc.id
ORDER BY tc.sort_order");
$categories = $stmt->fetchAll();
// 获取热门工具
$stmt = $db->query("SELECT t.*, tc.name as category_name
FROM tools t
LEFT JOIN tool_categories tc ON t.category_id = tc.id
WHERE t.is_active = 1
ORDER BY t.is_popular DESC, t.usage_count DESC
LIMIT 8");
$popularTools = $stmt->fetchAll();
// 获取精选文章
$stmt = $db->query("SELECT a.*, ac.name as category_name
FROM articles a
LEFT JOIN article_categories ac ON a.category_id = ac.id
WHERE a.is_published = 1
ORDER BY a.is_featured DESC, a.view_count DESC
LIMIT 4");
$featuredArticles = $stmt->fetchAll();
// 获取顶部广告
$stmt = $db->prepare("SELECT * FROM ads WHERE position_id = 1 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();
$topAd = $stmt->fetch();
// 获取侧边栏广告
$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 SITE_NAME; ?> - 实用的在线工具箱
prepare("SELECT * FROM tools WHERE category_id = ? AND is_active = 1 ORDER BY sort_order LIMIT 8");
$stmt->execute([$category['id']]);
$tools = $stmt->fetchAll();
if(empty($tools)) continue;
?>