PHP & MySQL Blog App with Admin Panel Tutorial From Scratch - PHP & MySQL Tutorial for Beginners

This beginner tutorial guides learners through building a functioning CRUD blog application with PHP and MySQL. It covers database setup, authentication and access control, user and category management, post management, blog pages, and search functionality.

Syllabus

Intro Project Overview
XAMPP Installation
Minor Frontend Changes
Creating Blog Folder & Installing Extensions
Project Folder/Files Structure & Configurations
Creating Database blog
Creating Database User egator
Connecting Project To Database blog
Creating Users Table
User Account Registration Signup
User Login Sign in and Access Control
Creating/Adding Users Author/Admin
Displaying/Fetching Users on Manage Users Page
Updating/Editing Users
Deleting User
Creating Categories Table
Creating/Adding Categories
Displaying/Fetching Categories on Manage Categories Page
Updating/Editing Categories
Deleting Categories
Creating Posts Table
Creating/Adding Posts
Displaying/Fetching Posts on Manage Posts Page
Updating/Editing Posts
Deleting Posts
Delete Posts Thumbnail when user is deleted
Set posts category to uncategorized when category is deleted
Displaying/Fetching Posts on Home Page
Single Post Page
Category Posts Page
Blog Page
Searching Post
Final Tests