Learning PHP data objects : a beginner's guide to PHP data objects, database connection abstraction library for PHP 5 / Dennis Popel.

Format:

Book

Author/Creator:

Poppel, Dennis.

Series:

From technologies to solutions.

From technologies to solutions

Language:

English

Subjects (All):

PHP (Computer program language).

Object-oriented programming (Computer science).

Web sites--Design.

Physical Description:

1 online resource (188 p.)

Edition:

1st ed.

Place of Publication:

Birmingham, U.K. : Packt Pub., 2007.

Language Note:

English

System Details:

Mode of access: World Wide Web.

Summary:

A Beginner's Guide to PHP Data Objects, Database Connection Abstraction Library for PHP 5

Contents:

Cover; Table of Contents; 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 ApplicationImproper 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 ReturnedUsing 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; The Advantages of OOP; Inheritance; Encapsulation; Polymorphism; Static Properties, Methods, and Class Constants; Exceptions; Summary; Index

Notes:

Includes index.

Includes bibliographical references and index.

ISBN:

9786611252618

9781281252616

1281252611

9781847192677

184719267X

OCLC:

806206111