PHP & MySQL: PDO x MySQLi

Presentation held in May 2019, at an internal IXCSoft event, Chapecó - SC, Brazil.

Treating the differences between MySQLi and PDO, with examples of integration with the MySQL SGBD.

Transcript

1. PHP & MySQL: PDO x MySQLi Marcos Marcolin
2. Script • Introduction; • Comparison; • Examples; • Kahoot!.
3. PHP Data Objects (PDO) • Native Module with PHP > 5; • Object Oriented Paradigm; • Relational Database; • Interface; • Abstraction Layer; • Not rewrite queries;
4. Abstract
5. Supported Drivers
6. Supported Drivers
7. Enabling the extension (php.ini) Linux Windows
8. Available Drivers
9. Start connection
10. getInstance()
11. insertUser()
12. deleteUser()
13. listAllUsers
14. SGBD’s
15. PDO::Exceptions
16. setFetchMode()
17. PDO x MySQLi
18. getConnect()
19. Named Parameters
20. Database Migration (mysql -> pg)
21. Database Migration (mysql -> pg)
22. Database Migration (mysql -> pg)
23. Security / Prepared Statements
24. Security / Prepared Statements
25. Security / Prepared Statements • Pre-prepared queries; • Split data entry;
26. Security / Prepared Statements
27. Security / Prepared Statements
28. Security / Prepared Statements • PDO : using client-side (emulating); • MySQLi: using server-side.
29. Security / Prepared Statements • PDO : using client-side (emulating); • MySQLi: using server-side. Client-side Server-side
30. Transactions • PDO ::beginTransaction(); • PDO ::commit(); • PDO ::rollBack();
31. Transactions • PDO ::beginTransaction(); • PDO ::commit(); • PDO ::rollBack() • Properties: ◦ atomicity; ◦ consistency; ◦ isolation; ◦ durability.
32. Class PDO
33. References • https://www.php.net/manual/pt_BR/book.pdo.php • https://www.php.net/manual/pt_BR/class.pdo.php • https://websitebeaver.com/php-pdo-prepared-statements-to-prevent-sql-injection • http://miscelaneadoconhecimento.com/mysql/sql/pdo.html • https://code.tutsplus.com/pt/tutorials/pdo-vs-mysqli-which-should-you-use--net-24059 • https://php.net/manual/pt_BR/book.mysqli.php