PHP: Accessing Databases with PDO and MySQLi

  • flag Lynda
  • student All Levels
  • database eLearning
  • earth English
  • clock 3h 47m


Now that PHP has true object-oriented capabilities^ it s best practice to access databases using PDO (PHP Data Objects) and MySQLi. These methods produce database-neutral code that works with over a dozen systems^ including MySQL^ SQL Server^ PostgreSQL^ and SQLite. Learn how to use PDO and MySQLi to perform basic select^ insert^ update^ and delete operations, improve security with prepared statements, and use transactions to execute multiple queries simultaneously. Author David Powers also covers advanced topics like instantiating custom objects^ and compares PDO to MySQLi so you can decide which method is right for you.

Covered topics:

  • Developer
  • Programming Languages
  • Web
  • Web Development
  • PHP