PHP with PDO and OOP for beginners

Course Curriculum

Chapter 1: Installations and Workspace

Lecture 1: Introduction

Lecture 2: Softwares Needed

Lecture 3: Wampserver Startup Errors

Lecture 4: Server Side vs Client Side

Lecture 5: Database abstraction Layer

Lecture 6: PHP Data Object PDO

Lecture 7: Server Folder

Lecture 8: SQL Injection

Chapter 2: PHP Basics

Lecture 1: Tags

Lecture 2: Echo and Print

Lecture 3: Variables

Lecture 4: IF ELSE Conditions

Lecture 5: Equality and Strict Equality

Lecture 6: Increment and Decrement

Lecture 7: Elseif and Else If

Lecture 8: While and Do-While

Lecture 9: For and Foreach

Lecture 10: Infinite Loops

Lecture 11: Break and continue

Lecture 12: Switch

Lecture 13: Executing specific script portion

Lecture 14: Require once and include once

Lecture 15: And Or Operators

Lecture 16: Indexed Arrays

Lecture 17: Associative Arrays

Lecture 18: Multidimensional Arrays

Lecture 19: Arrays Premade Functions

Lecture 20: Math Functions

Lecture 21: Exercise 1

Lecture 22: Exercise 2

Lecture 23: Exercise 3

Chapter 3: PHP and MySQL

Lecture 1: Error Reporting

Lecture 2: Connections

Lecture 3: Database Design

Lecture 4: Bootstrap Basics

Lecture 5: Name Tags and PHP server

Lecture 6: Login Form

Lecture 7: Post and Get methods

Lecture 8: Variable set function

Lecture 9: Password Encryption

Lecture 10: Query Function

Lecture 11: Prepared Statements

Lecture 12: bindValue() and bindParam()

Lecture 13: Executing Queries

Lecture 14: Functions

Chapter 4: Sessions and Cookies

Lecture 1: Introduction

Lecture 2: Session Information

Lecture 3: Connection file and sessions

Lecture 4: Logout and Destroying session

Lecture 5: Cookies

Lecture 6: Securing login system using password hash

Lecture 7: More super global variables

Chapter 5: AdminPanel Project

Lecture 1: SQL basics

Lecture 2: AdminPanel Interface

Lecture 3: Fetching Columns

Lecture 4: Exercise 4 – Adding users

Lecture 5: Exercise 5 – Part 1

Lecture 6: Exercise 5 – Part 2

Lecture 7: Last Insert ID

Lecture 8: PHP Errors

Chapter 6: Object Oriented Programming in PHP

Lecture 1: Introduction

Lecture 2: Classes

Lecture 3: Properties and Restrictions

Lecture 4: Methods

Lecture 5: Instantiate Classes

Lecture 6: Constructor

Lecture 7: Exercise 6 – OOP Login System

Lecture 8: Exercise 6 – Part 2

Lecture 9: Inheritance

Lecture 10: Exercise 7 – Inheritance

Lecture 11: Overriding and Restrictions

Lecture 12: Interface and Abstract Class

Lecture 13: Static Methods and Properties

Lecture 14: Destructor