query('SELECT n.id, n.title, n.summary, n.created_at, n.category_id, n.slug,
COALESCE(c.name, "默认分类") as category_name,
(SELECT image_path FROM news_images WHERE news_id = n.id LIMIT 1) as image_path
FROM news n
LEFT JOIN news_categories c ON n.category_id = c.id
WHERE n.published = 1
ORDER BY n.created_at DESC
LIMIT 12');
$newsList = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($newsList as $news) {
$newsId = $news['id'];
$title = htmlspecialchars($news['title']);
$summary = htmlspecialchars($news['summary']);
$category = htmlspecialchars($news['category_name']);
$date = date('Y-m-d', strtotime($news['created_at']));
$imagePath = $news['image_path'] ? $news['image_path'] : '../static/picture/news-' . (($newsId % 6) + 1) . '.jpg';
echo '
';
echo '
';
}
} catch (Exception $e) {
// 如果连接失败，显示静态数据
?>
';
echo '  . ')
';
echo '
';
echo '';
echo ' ' . $category . '';
echo '
';
echo ' ' . $title . '
'; echo '' . $date . '
'; echo '' . $summary . '
'; echo ' 阅读更多'; echo '