PHP & MySQL Blog App with Admin Panel Tutorial From Scratch - PHP & MySQL Tutorial For Beginners
Hostinger Discount: https://www.hostg.xyz/SH8cs

Responsive React Portfolio Website with Theme Customization (FULL COURSE): https://www.udemy.com/course/react-js-portfolio-website-with-theme-customization/?referralCode=91FE72E9328ADD7A3214

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): https://www.youtube.com/watch?v=dgfHwfC6bWE


Buy Me A Coffee: https://www.buymeacoffee.com/egator
Become a patron: https://patreon.com/egator
Source Code, Assets & SQL Dump (Database Tables): https://www.buymeacoffee.com/egator/e/77678
Images: https://github.com/egattor/php-mysql-blog-assets


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