Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
12 Videos (1h 1m)
    • Introduction

      1:26
    • Why Use PDO?

      2:11
    • Creating and Connecting to Database

      6:40
    • SELECTING Records

      10:30
    • Fetch All Records and Count

      3:06
    • Commonly Used Fetch Modes

      7:07
    • Prepared Statements and Binding Parameters

      9:48
    • Inserting Records

      6:56
    • Get ID of Last Inserted Record

      2:30
    • Updating Records

      6:23
    • Get Number of Affected Rows

      2:13
    • Deleting Records by ID

      2:20

About This Class

In this course you will learn to perform basic transactions using PHP Data Objects. You will learn about SQL Injection Attacks and you learn to protect the application from these attacks using Prepared Statements.

You will learn to perform basic database operations like SELECT , UPDATE , INSERT , DELETE in a secure way using PHP Data Objects in PDO.

Important Topics which will be covered :

  • Prepared Statements
  • SQL Injections(Attack and Secure)
  • Why to use PDO
  • How Prepared Statements work
  • Fetch Modes in PDO

54

Students

--

Projects

Amir Qureshi

Web and Mobile App Developer