Introduction to the course
  • Welcome to the Course!
  • What is PHP Data Objects (PDO)?
  • Connecting to MySQL Database with PDO
  • Dealing with Errors in PDO
  • Creating a table with PDO
  • Section 1 - Quiz
Basic Crud Operations with PDO
  • Create
  • Read
  • Update
  • Delete
  • How to Review This Course
  • Section 2 - Quiz
Security
  • Parameters and Prepared Statements
  • Binding Parameters to Prepared Statements
  • Section 3 - Quiz
Some Useful PDO Methods
  • Getting the last Inserted ID
  • Number of Affected rows
Advanced PDO Features
  • Transactions
  • PDO Data Fetching Modes
  • Further Reading
Building a Basic Task List
  • Project structure and Overview
  • Prepping The Database
  • Building the Interface
  • Creating a Task with JQuery and PHP
  • Displaying Existing Tasks with JQuery and PHP
  • Updating a Task with JQuery and PHP (With In-place Edit)
  • Deleting a Task with JQuery and PHP
  • Wrapping up
  • Source Code
  • Validating Create Task Form
  • Optimizing Update Task Code
  • Pagination
  • Updated Source Code
  • Bonus Lecture