query("SELECT p.*, c.name AS category_name
FROM blog_posts p
LEFT JOIN blog_categories c ON p.category_id = c.id
ORDER BY p.created_at DESC")->fetchAll();
$totalPublished = 0;
$totalDrafts = 0;
foreach ($posts as $p) {
if ($p['status'] === 'published') $totalPublished++;
else $totalDrafts++;
}
$categories = $db->query("SELECT COUNT(*) FROM blog_categories")->fetchColumn();
// Flash message
$flash = $_SESSION['flash'] ?? '';
unset($_SESSION['flash']);
?>
Dashboard - Blog Admin
