PHP Data Objects Layer (PDO)：PHP数据对象层（PDO）.ppt

PHP Data Objects Layer (PDO) Ilia Alshanetsky What is PDO Common interface to any number of database systems. Written in C, so you know it’s FAST! Designed to make use of all the PHP 5.1 features to simplify interface. Why is it needed? Current state of affairs: Many native database extensions that are similar but do not provide the same interface. In most cases, very old code that does not even scratch the surface of what PHP can offer. In many instances does not account for all the capabilities offered by the database. Ex. SQLite, MySQL extensions What Databases are Supported? At this time PDO offers the following drivers: MySQL 3,4,5 (depends on client libs) PostgreSQL SQLite 2 3 ODBC DB2 Oracle Firebird FreeTDS/Sybase/MSSQL Installing PDO PDO is divided into two components CORE (provides the interface) DRIVERS (access to particular database) Ex. pdo_mysql The CORE is enabled by default, drivers with the exception of pdo_sqlite are not. Actual Install Steps PECL Way pecl install pdo_[driver_name] Update php.ini and add extension=pdo_[driver_name].so (or .dll on win32) Built into PHP ./configure –with-pdo-[driver_name] For Win32 dlls for each driver are available. Using PDO As is the case with all database interfaces, the 1st step involves establishing a connection. What if the Connection Fails? As is the case with most native PHP objects, instantiation failure lead to an exception being thrown. Persistent Connections Connecting to complex databases like Oracle is a slow process, it would be nice to re-use a previously opened connection. DSN INI Tricks The DSN string can be an INI setting and you can “name” as many DSNs are you like. Let’s Run Some Queries Query execution in PDO can be done in two ways Prepared Statements (recommended for speed security) Direct Execution Direct Query Execution Queries that modify information need to be run via exec() method. The return value is the number of rows affected by the operation or FALSE on error. Direc