->
Lynda - PHP: Accessing Databases with PDO and MySQLi - 169106
Lynda - PHP: Accessing Databases with PDO and MySQLi
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.


Table of Contents

  • Introduction
  • 1. Why Use Object-Oriented PHP to Access a Database?
  • 2. PHP Data Object (PDO) Basics
  • 3. PDO-Prepared Statements and Transactions
  • 4. Advanced PDO Fetch Methods
  • 5. MySQL Improved Basics
  • 6. MySQLi Prepared Statements and Transactions
  • 7. Diving Deeper into MySQLi
  • Conclusion
  • Lynda - PHP: Accessing Databases with PDO and MySQLi


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss