';
blog_foot(); exit;
}
$total = (int) db_val(
"SELECT COUNT(DISTINCT p.id) FROM posts p
INNER JOIN post_categories pc ON pc.post_id=p.id
WHERE pc.category_id=? AND p.status='published' AND p.deleted_at IS NULL",
[$cat['id']]
);
$pg = paginate($total, $postsPerPage, $page);
$posts = db_query(
"SELECT DISTINCT p.id, p.title, p.slug, p.excerpt, p.published_at, p.featured_image_id,
p.reading_time_minutes, p.primary_category_id,
u.display_name AS author_name
FROM posts p
INNER JOIN post_categories pc ON pc.post_id=p.id
LEFT JOIN users u ON u.id=p.author_id
WHERE pc.category_id=? AND p.status='published' AND p.deleted_at IS NULL
ORDER BY p.published_at DESC
LIMIT ? OFFSET ?",
[$cat['id'], $postsPerPage, $pg['offset']]
);
$pageTitle = $cat['meta_title'] ?: ($cat['name'] . ' — ' . $siteName);
blog_head($pageTitle, $siteName, $siteTagline, $cat['meta_description'] ?: '');
?>
';
blog_foot(); exit;
}
$total = (int) db_val(
"SELECT COUNT(*) FROM post_tags pt INNER JOIN posts p ON p.id=pt.post_id
WHERE pt.tag_id=? AND p.status='published' AND p.deleted_at IS NULL",
[$tag['id']]
);
$pg = paginate($total, $postsPerPage, $page);
$posts = db_query(
"SELECT p.id, p.title, p.slug, p.excerpt, p.published_at, p.featured_image_id,
p.reading_time_minutes, u.display_name AS author_name
FROM posts p
INNER JOIN post_tags pt ON pt.post_id=p.id
LEFT JOIN users u ON u.id=p.author_id
WHERE pt.tag_id=? AND p.status='published' AND p.deleted_at IS NULL
ORDER BY p.published_at DESC LIMIT ? OFFSET ?",
[$tag['id'], $postsPerPage, $pg['offset']]
);
blog_head('Tag: ' . $tag['name'] . ' — ' . $siteName, $siteName, $siteTagline);
?>
![<?= h($post['title']) ?>](<?= h($featImgUrl) ?>)
![<?= h($p['title']) ?>](<?= h($imgUrl) ?>)