MySQL

PHP & PDO MySQL PHP Data Objects

Free MySQL course, 13 video lessons by Thorn Web Design.

13 Lesson 2 hr 2 min 7 Enrolled Certificate: Yes

Intro Course content

13 Lesson · 2 hr 2 min

01 Lesson 1 - PDO Connecting to a MySQL Database using the PDO Library in PHP 07:50

02 Lesson 2 - PDO - Using Prepare Statements PDOStatement 07:55

03 Lesson 3 - PDO - Fetching Objects and Custom Objects using fetchAll with PDOStatement 09:10

04 Lesson 4- PDO - ErrorInfo and ErrorCode using PDOStatement 04:41

05 Lesson 5 - PDO - Using fetch Method from PDOStatement to iterate through the results. 09:23

06 Lesson 6 - PDO - Difference between bindValue and bindParam with PDOStatement 06:58

07 Lesson 7 - PDO - bindValue & bindParam using ? mark 1-indexed positions 11:07

08 Lesson 8 - PDO - Avoiding SQL Injection using pdo quote bindParam bindValue 15:55

09 Lesson 9 - PDO - Using exec method for executing simple SQL commands. 10:32

10 Lesson 10 - PDO - Retrieving the Last Inserted ID with PDO. 04:43

11 Lesson 11 - PDO - bindParam and passing by reference 09:00

12 Lesson 12 - PDO - bindColumn assigning values to variables by reference 10:11

13 Lesson 13 - PDO - beginTransaction turning off autocommit mode 13:55