Build Real World Website with PHP, PDO & MySQL

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Introduction

Lecture 2: Environment Setup

Chapter 2: Basics introduction to Prepared Statements

Lecture 1: Introduction to prepared statements

Lecture 2: Connect to database

Lecture 3: Reading data

Lecture 4: Inserting data

Lecture 5: Updating data

Lecture 6: Deleting data

Chapter 3: Task List Project with Prepared Statements

Lecture 1: Project setup

Lecture 2: Creating database and database table

Lecture 3: Database connection and creating reuse able component

Lecture 4: Displaying dynamic users

Lecture 5: Adding new user

Lecture 6: Deleting user (Bad Approach)

Lecture 7: Deleting user (Good Approach)

Lecture 8: Editing user

Chapter 4: PDO : PHP Data Object

Lecture 1: Configuration

Lecture 2: Basics introduction to PDO

Lecture 3: Setting up PDO, Database & Database connection

Lecture 4: Fetching data from database using PDO

Lecture 5: Inserting data using PDO

Lecture 6: Updating data using PDO

Lecture 7: Deleting data using PDO

Chapter 5: Task List Project with PDO

Lecture 1: Project setup

Lecture 2: Creating database & database table

Lecture 3: Database connection & reuse able component

Lecture 4: Displaying user from database

Lecture 5: Adding new user

Lecture 6: Deleting user

Lecture 7: Editing user

Chapter 6: Project : Blogging System with CMS – Front End

Lecture 1: Project Setup

Lecture 2: Creating database and database table

Lecture 3: Creating Reuse-able Component

Lecture 4: Making Categories Dynamic

Lecture 5: Working with posts

Lecture 6: URL Rewriting

Lecture 7: Work with single post (Post details page)

Lecture 8: Single post continue

Lecture 9: Work with Category posts

Lecture 10: Category post continue

Lecture 11: Let's build a search engine

Lecture 12: Pagination home

Lecture 13: Pagination home ( Next, Prev, Active)

Lecture 14: Pagination for search page

Lecture 15: URL Rewriting Removing(categories)

Lecture 16: Pagination for category page

Lecture 17: Pagination continue

Lecture 18: Working with comments

Lecture 19: Post specific comments

Lecture 20: Comments continue

Chapter 7: Project : Blogging System with CMS – Back End

Lecture 1: Creating Reuse-able Component

Lecture 2: Back End Authentication

Lecture 3: Working with posts

Lecture 4: Inserting new post

Lecture 5: Editing post

Lecture 6: Editing post update

Lecture 7: Edit post continue

Lecture 8: Deleting post

Lecture 9: Working with categories

Lecture 10: Working with comments – Last Lecture