Programming
PDO & MySQL: Connect to MySQL DB using PDO & CRUD Operations
Instructor : Armstrong Nana TAGU
Overview
Go from a Beginner to Advance in PDO: Connect to MySQL DB using PDO, Write your first PDO Wrapper class, and do CRUD
What you'll learn :
- 1- Connect to MySQL Database using PDO
- 2- Write simple PDO queries without parameters
- 3- Write PDO queries with parameters –Prepare statements
- 4- Get data out of statements using –foreach(), fetch(), fetchAll()
- 5- Getting data out of statement - PDO::rowCount() – the proper use of the rowCount() function
- 6- Getting affected rows and last insert id
- 7- Write a PDO Wrapper class and methods
- 8- Error handling and Exceptions
Requirements
- 1. Basic knowledge in PHP , and MySQL (Basic Concept in PHP & MySQL, are not covered in the course)
- 2. Comfortable working with any PHP development environment – XAMPP, MAMP, WampServer, EasyPHP etc
- 3. Comfortable working with any text editor – for example: notepad++, Visual Studio Code, Atom, Sublime
- 4. Knowledge in OOP and PDO will be a plus but not compulsory. Everything is explained from scratch.