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

PHP & MySQL Blog App with Admin Panel Tutorial From Scratch - PHP & MySQL Tutorial For Beginners Hostinger Discount: Responsive React Portfolio Website with Theme Customization (FULL COURSE): In this project tutorial, I’m going to teach you how to create a fully functioning CRUD Blog Application with an Administrator Panel/Dashboard using PHP and MySQL. This project features a user registration and login system with access control, creating posts, updating posts, deleting posts, adding users, updating users, deleting users, creating categories, updating categories, deleting categories, and more! As usual, no steps will be skipped in this tutorial, I’m going to walk you all through to the end! Part 1 (Frontend): Buy Me A Coffee: Become a patron: Source Code, Assets & SQL Dump (Database Tables): Images: Timestamps: 00:00:00 Intro (Project Overview) 00:42:45 XAMPP Installation 00:46:42 Minor Frontend Changes 00:49:10 Creating Blog Folder & Installing Extensions 00:55:10 Project Folder/Files Structure & Configurations 01:34:35 Creating Database (blog) 01:35:25 Creating Database User (egator) 01:38:00 Connecting Project To Database (blog) 01:45:17 Creating Users Table 01:49:35 User Account Registration (Signup) 02:52:55 User Login (Sign in) and Access Control 03:32:00 Creating/Adding Users (Author/Admin) 04:02:00 Displaying/Fetching Users on Manage Users Page 04:15:00 Updating/Editing Users 04:34:35 Deleting User 04:53:35 Creating Categories Table 04:54:55 Creating/Adding Categories 05:14:10 Displaying/Fetching Categories on Manage Categories Page 05:20:24 Updating/Editing Categories 05:36:40 Deleting Categories 05:45:30 Creating Posts Table 05:53:40 Creating/Adding Posts 06:26:06 Displaying/Fetching Posts on Manage Posts Page 06:47:35 Updating/Editing Posts 07:11:02 Deleting Posts 07:22:20 Delete Posts Thumbnail when user is deleted 07:32:20 Set posts category to uncategorized when category is deleted 07:36:48 Displaying/Fetching Posts on Home Page 08:07:10 Single Post Page 08:12:50 Category Posts Page 08:21:22 Blog Page 08:26:35 Searching Post 08:35:17 Final Tests #php #mysql #projecttutorial