query("SELECT COUNT(*) FROM posts WHERE status = 'published' AND is_public = 1 AND (published_at IS NULL OR published_at <= NOW())");
$totalPosts = (int) $stmt->fetchColumn();
$totalPages = ceil($totalPosts / POSTS_PER_PAGE);
// 获取文章列表（置顶优先，按时间倒序）
$stmt = $db->prepare("
SELECT p.*, u.nickname, u.avatar
FROM posts p
LEFT JOIN users u ON p.user_id = u.id
WHERE p.status = 'published' AND p.is_public = 1 AND (p.published_at IS NULL OR p.published_at <= NOW())
ORDER BY p.is_pinned DESC, COALESCE(p.published_at, p.created_at) DESC
LIMIT ? OFFSET ?
");
$stmt->execute([POSTS_PER_PAGE, $offset]);
$posts = $stmt->fetchAll();
// 获取每篇文章的标签
if (!empty($posts)) {
$postIds = array_column($posts, 'id');
$placeholders = implode(',', array_fill(0, count($postIds), '?'));
$tagStmt = $db->prepare("
SELECT pt.post_id, t.name, t.slug
FROM post_tags pt
JOIN tags t ON pt.tag_id = t.id
WHERE pt.post_id IN ($placeholders)
");
$tagStmt->execute($postIds);
$tagMap = [];
while ($row = $tagStmt->fetch()) {
$tagMap[$row['post_id']][] = $row;
}
}
$pageTitle = '时间流';
$pageDesc = getSetting('site_desc', '网络上的一个私人房间');
include ROOT_PATH . '/includes/header.php';
?>
nights_stay
这里还什么都没有...
夜深了，写点什么吧
次浏览
· chat_bubble_outline