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
1 view
80
13
3 weeks ago 00:00:00 1
Enshrouded.#15.НЕТ..ТЕПЕРЬ ТОЧНО ЗА БАРДОМ)
4 weeks ago 00:00:23 1
Карельский танец КРУУГА
1 month ago 00:20:08 1
11월 월간견적 가성비 게이밍 조립PC 컴퓨터 견적 | 9800X3D, 7800X3D 재고보유 | 전원만 켜세요
1 month ago 00:03:48 1
[ 中國話 Chinese ] Official Music Video
1 month ago 00:01:06 2
송재림 사망 직전까지 괴롭힌 악질 사생팬? 계정 삭제후 돌연 잠적 [지금이뉴스] / YTN
1 month ago 00:43:45 1
Feux au Canada, provoqués ??
1 month ago 00:01:28 1
Как не передавать демонические качества своим детям
1 month ago 00:12:45 1
Как легально пиратство продавали !
1 month ago 00:00:53 2
СВИДЕТЕЛЬСТВО И БЛАГОВЕСТИЕ. ПРИЗЫВ К ПОКАЯНИЮ.
1 month ago 01:16:11 1
ХИМЕРНИЙ КРАЙ | Останній єдиноріг світу. Українські масони. Містика осіннього сонцестояння
1 month ago 00:28:23 1
Чтение Библии на 10 Ноября: Псалом 131, Евангелие от Иоанна 8, Книга Иеремии 39, 52
1 month ago 00:09:39 1
Рок-энциклопедия. Arch Enemy. История группы
1 month ago 00:05:10 10
Warhammer online: [ROR] Коротко и о главном
1 month ago 00:04:27 1
DJ AURM - Hold Me Tight
1 month ago 00:28:46 1
КАК УБРАТЬ ЖИВОТ / АЛЕКСЕЙ КОВАЛЬКОВ О ЖИВОТЕ / ВИДЫ ОЖИРЕНИЯ / КАК УБРАТЬ ЖИР НА ЖИВОТЕ
1 month ago 00:01:18 1
ORIVISION New Launch - 4 Channels HEVC HDMI Encoder EH1304
1 month ago 00:13:58 1
Заклинание-Охрана от порчи на все 24 часа
1 month ago 00:01:20 1
Borderlands 3. Черный Рынок от Мориса. С 7 по 14 ноября.
1 month ago 00:08:10 1
DIY 🎀 Бесподобные новогодние бантики из репсовой ленты.. Рекомендую на все 💯🔥. Легко повторить ...
1 month ago 00:02:59 1
В РФ нет государственных чиновников!
1 month ago 00:04:51 1
КАПИТАЛИЗМ И СОЦИАЛИЗМ ЭКОНОМИЧЕСКИЙ АСПЕКТ-1
1 month ago 00:01:37 1
Видео беса выходящего из человека
1 month ago 00:08:25 2
DIY 🎀 Посмотрите какие новогодние бантики. Готовимся к праздникам 🎀Getting ready for the New Year
1 month ago 00:03:46 1
1UP X GRIFTERS CODE -- VERY GOOD GUYS (OFFICIAL HD VERSION AGGROTV)