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!
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
Part 1 (Frontend): https://morioh.com/p/a03cef0af009
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
Subscribe: https://www.youtube.com/@EGATORTUTORIALS/featured
#php #mysql
