$id]); db_exec('UPDATE blog_posts SET published=:p WHERE id=:id', ['p'=>$cur?0:1,'id'=>$id]); } if ($do === 'delete' && $id) { // Delete cover image file if exists $img = db_value('SELECT cover_image FROM blog_posts WHERE id=:id', ['id'=>$id]); if ($img) { $path = __DIR__ . '/../' . ltrim($img, '/'); if (file_exists($path)) @unlink($path); } db_exec('DELETE FROM blog_posts WHERE id=:id', ['id'=>$id]); header('Location: blog.php?msg=deleted'); exit; } header('Location: blog.php'); exit; } $q = trim($_GET['q'] ?? ''); $filter = $_GET['filter'] ?? 'all'; $where = ['1=1']; $params = []; if ($filter === 'published') $where[] = "published=1"; if ($filter === 'draft') $where[] = "published=0"; if ($q !== '') { $where[] = "(title LIKE :q1 OR excerpt LIKE :q2 OR author LIKE :q3)"; $params['q1'] = '%'.$q.'%'; $params['q2'] = '%'.$q.'%'; $params['q3'] = '%'.$q.'%'; } $posts = db_all( 'SELECT id, slug, title, excerpt, published, author, posted_at, cover_image, tags, created_at, updated_at FROM blog_posts WHERE '.implode(' AND ',$where).' ORDER BY posted_at DESC, created_at DESC LIMIT 200', $params ); $counts = [ 'all' => (int)db_value('SELECT COUNT(*) FROM blog_posts'), 'published' => (int)db_value('SELECT COUNT(*) FROM blog_posts WHERE published=1'), 'draft' => (int)db_value('SELECT COUNT(*) FROM blog_posts WHERE published=0'), ]; ?>

Blog Posts

+ New post

All Published Drafts

📝

No posts yet. Write your first post →

Cover	Title	Author	Date	Tags	Status	Actions
	…			—		Edit · View · ·

post.