PDO & MySQL: Connect to MySQL DB using PDO & CRUD Operations

In this short course, you are going to learn, practice and do some hands-on exercises on how to:

• Connect to MySQL Database using PDO

• Write your first PDO Database Wrapper class

• Write PDO CRUD methods (i.e. function in a class)

• Write simple queries – queries without parameters

• Write secure queries with parameters

• Get data out of statements – using foreach, fetch(), fetchAll(), fetchColumn()

• Error handling and Exceptions

• PDO::rowCount() function explained

• Get affected rows and last insert Id

• The problem with Limit Clause in prepare statements

• Write a simple general function and chaining methods