Learning PHP Data Objects Table of Contents

Back to BOOK PAGE

Table of Contents

Preface
Chapter 1: Introduction
Chapter 2: Using PHP Data Objects: First Steps
Chapter 3: Error Handling
Chapter 4: Prepared Statements
Chapter 5: Handling Rowsets
Chapter 6: Advanced PDO Usage
Chapter 7: An Advanced Example
Appendix A: Introduction to OOP in PHP5
Index

• Preface

• Chapter 1: Introduction
  • Using PDO
    • Connecting to the Database
    • Connection Strings
    • Issuing SQL Queries, Quoting Parameters, and Handling Result Sets
    • Error Handling
    • Prepared Statements
    • Appropriate Understanding of PDO
  • Summary

• Chapter 2: Using PHP Data Objects: First Steps
  • Connection Strings
    • Creating the Sample Database
      • The Data Model
      • Creating the MySQL Database
  • Designing Our Code
  • PDO Statements and Result Sets
  • Retrieving Result Set Metadata
  • Summary

• Chapter 3: Error Handling
  • Sources of Errors
    • Server Software Failure or Overload
    • Improper Configuration of the Application
    • Improper Validation of User Input
    • Inserting a Record with a Duplicate Primary Key or Unique Index Value
    • Syntax Errors in SQL Statements
  • Types of Error Handling in PDO
  • Defining an Error Handling Function
  • Creating the Edit Book Page
  • Creating the Edit Author Page
  • Securing against Uncaught Exceptions
  • Summary

• Chapter 4: Prepared Statements
  • Prepared Statements
    • Positional and Named Placeholders
    • Prepared Statements and Bound Values
  • Working with BLOBs
  • Summary

• Chapter 5: Handling Rowsets
  • Retrieving the Number of Rows in a Result Set
  • Limiting the Number of Rows Returned
    • Using Database-Specific SQL
    • Processing the Top N Rows Only
    • Starting at an Arbitrary Offset
  • Summary

• Chapter 6: Advanced PDO Usage
  • Setting and Getting Connection Attributes
  • MySQL Buffered Queries
  • Connecting Using the Connection Configuration File and php.ini Setting
  • Getting the List of Available Drivers
  • Transactions
  • Summary

• Chapter 7: An Advanced Example
  • Designing the Model
  • Modifying the Frontend to Use the Model
  • Advantages of Separating the Model
  • Further Thoughts
  • Finishing Up

• Appendix A: Introduction to OOP in PHP5
  • What is Object-Oriented Programming?
    • The Syntax for Declaring Objects
    • Constructors
    • Destructors
  • The Advantages of OOP
    • Inheritance
    • Encapsulation
    • Polymorphism
  • Static Properties, Methods, and Class Constants
  • Exceptions
  • Summary

• Index

Back to BOOK PAGE