RSK World - PHP Blog System | Posts, Categories, Comments, Admin Panel & RSS | RSK World

PHP Blog Categories MySQL Admin

PHP Blog System provides full CRUD for posts, categories (many-to-many), comments with moderation, user roles (admin/author/user), featured images, rich text editor (Quill), unique slugs, scheduled publishing, search (title/excerpt/content), RSS feed, author & archive pages, password reset (1h token), sidebar with category counts. Admin: posts (draft/publish, featured image, categories), categories CRUD, users, comment moderation (approve/spam). By rskworld.in.

If you find this PHP Blog System useful, you can support with a small contribution.

Secure Fast Trusted

Pay via UPI QR

Scan or tap an amount to auto-generate

₹

Open UPI app

GPay PhonePe Paytm

Download PHP Blog System

Posts, Categories & Comments

Full CRUD for posts with slug, excerpt, meta description, featured image, draft/publish, scheduled publishing. Categories CRUD; many-to-many post–category. Comments with approve/spam workflow.

Posts: title, slug (unique), excerpt, content (Quill), featured image, status, published_at
ensureUniqueSlug() – auto-appends -2, -3 if slug exists; handleFeaturedImageUpload() for uploads
Categories: admin/categories.php CRUD; assign multiple categories per post
Comments: pending/approved/spam; admin comments auto-approved; CSRF on comment form
install.php one-click setup; database/schema.sql with prefix

Project Structure & Files

config/database.php, database.local.php; includes/init.php, header.php, footer.php, sidebar.php; index, post, search, author, archive, feed; admin posts, categories, users, comments.

index.php – home, category filter, pagination; post.php – single post, related, comments
search.php – full-text in title/excerpt/content; author.php, archive.php by month
feed.php – RSS 2.0; login, register, forgot_password, reset_password, logout
admin/ – index (dashboard), posts.php, categories.php, users.php, comments.php
database/schema.sql – users, posts, comments, categories, post_categories, password_reset_tokens

Login, Session & Security

Session-based login, roles (admin/author/user). password_hash/verify, prepared statements, escape() for output. requireLogin(), requireAdmin() in init.php.

Login – email/password; session stores user_id, username, email, full_name, role
Admin panel protected by requireAdmin(); redirect to install.php if tables missing
Comment form – CSRF token, hash_equals validation
Password reset – token in password_reset_tokens, 1h expiry; reset_password.php?token=

Authors & Public Pages

Author page (author.php?username=) lists author posts. Archive by month. Sidebar with category counts on index, post, search. Related posts on single post (by category, then recent).

author.php – paginated posts by user; archive.php – year/month with archive sidebar
Sidebar – categories with post counts; includes/sidebar.php included when categories exist
Related posts – same categories first, then fill to 5 with latest
View count incremented on single post view

Database & Config

PDO MySQL; prefixed tables. database.local.php for local (Laragon); database.php for production. getDBConnection(), tbl(), getBaseUrl(), getUploadsUrl().

config/database.php – loads database.local.php if present; TABLE_PREFIX
Tables: users, posts, comments, categories, post_categories, password_reset_tokens
Auto-create database on connection if missing (1049); install.php runs schema
Default admin: admin@rskworld.in / admin123 (change in production)

What You Get

Full PHP blog source: config, includes, public pages, admin panel, schema, README, INSTALL, CONFIGURATION, STRUCTURE, CHANGELOG.

Complete source – php-blog-system/ folder with all PHP, config, database, assets
assets/css/style.css, assets/js/main.js; uploads/ for featured images
Documentation: README, INSTALL, CONFIGURATION, STRUCTURE, CONTRIBUTING, LICENSE
Bootstrap 5, Font Awesome, Quill editor in admin
© 2026 Molla Samser (RSK World).

Blog Application

PHP 7.4+, MySQL 5.7+. Run install.php once or import schema.sql; set config/database.php or database.local.php; open index.php or admin/.

php-blog-system/ – main app folder (index, post, search, author, archive, feed)
index.php – home; post.php?slug= – single post; search.php?q=; author.php?username=
admin/ – dashboard, posts (CRUD, Quill, featured image, categories), categories, users, comments
login.php, register.php, forgot_password.php, reset_password.php
Author: Molla Samser | rskworld.in

Helpers & Functions

includes/init.php: getBaseUrl(), getAdminUrl(), escape(), generateSlug(), ensureUniqueSlug(), handleFeaturedImageUpload(), isPostVisible(), isLoggedIn(), isAdmin(), requireLogin(), requireAdmin().

escape() – htmlspecialchars for output; generateSlug() from title
ensureUniqueSlug($slug, $excludePostId) – unique post slugs
isPostVisible($post) – published and (published_at in past or null)
getUploadsPath(), getUploadsUrl() for featured images

Project Features

Posts CRUD, categories, comments, user roles, featured images, search, RSS, archive, author pages, password reset, admin panel, Quill editor, scheduled posts.

Blog – home, single post, search, author, archive, RSS feed, sidebar categories
Auth – register, login, logout, forgot/reset password (1h token)
Admin – posts (draft/publish, schedule, featured image, categories), categories, users, comments
SEO – meta description per post, RSS link in header
Security – password_hash, PDO prepared statements, CSRF, escape()