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

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn to build a fully functional CRUD Blog Application with an Administrator Panel using PHP and MySQL in this comprehensive tutorial. Develop a user registration and login system with access control, create and manage posts, users, and categories. Follow step-by-step instructions to set up the project, connect to a database, and implement features such as user authentication, content management, and search functionality. Gain hands-on experience in frontend and backend development, database design, and PHP programming while creating a responsive and dynamic blog platform from scratch.

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