Downloads
Documentation
Get Involved
Help
Getting Started
Introduction
A simple tutorial
Language Reference
Basic syntax
Types
Variables
Constants
Expressions
Operators
Control Structures
Functions
Classes and Objects
Namespaces
Enumerations
Errors
Exceptions
Fibers
Generators
Attributes
References Explained
Predefined Variables
Predefined Exceptions
Predefined Interfaces and Classes
Predefined Attributes
Context options and parameters
Supported Protocols and Wrappers
Security
Introduction
General considerations
Installed as CGI binary
Installed as an Apache module
Session Security
Filesystem Security
Database Security
Error Reporting
User Submitted Data
Hiding PHP
Keeping Current
Features
HTTP authentication with PHP
Cookies
Sessions
Dealing with XForms
Handling file uploads
Using remote files
Connection handling
Persistent Database Connections
Command line usage
Garbage Collection
DTrace Dynamic Tracing
Function Reference
Affecting PHP's Behaviour
Audio Formats Manipulation
Authentication Services
Command Line Specific Extensions
Compression and Archive Extensions
Cryptography Extensions
Database Extensions
Date and Time Related Extensions
File System Related Extensions
Human Language and Character Encoding Support
Image Processing and Generation
Mail Related Extensions
Mathematical Extensions
Non-Text MIME Output
Process Control Extensions
Other Basic Extensions
Other Services
Search Engine Extensions
Server Specific Extensions
Session Extensions
Text Processing
Variable and Type Related Extensions
Web Services
Windows Only Extensions
XML Manipulation
GUI Extensions
Keyboard Shortcuts
?
This help
j
Next menu item
k
Previous menu item
g p
Previous man page
g n
Next man page
G
Scroll to bottom
g g
Scroll to top
g h
Goto homepage
g s
Goto search
(current page)
/
Focus search box
Introduction »
« odbc_tables
PHP Manual
Function Reference
Database Extensions
Abstraction Layers
Change language:
English
Chinese (Simplified)
Other
PHP Data Objects
Introduction
Installing/Configuring
Requirements
Installation
Runtime Configuration
Resource Types
Predefined Constants
Connections and Connection management
Transactions and auto-commit
Prepared statements and stored procedures
Errors and error handling
Large Objects (LOBs)
PDO
— The PDO class
PDO::beginTransaction
— Initiates a transaction
PDO::commit
— Commits a transaction
PDO::__construct
— Creates a PDO instance representing a connection to a database
PDO::errorCode
— Fetch the SQLSTATE associated with the last operation on the database handle
PDO::errorInfo
— Fetch extended error information associated with the last operation on the database handle
PDO::exec
— Execute an SQL statement and return the number of affected rows
PDO::getAttribute
— Retrieve a database connection attribute
PDO::getAvailableDrivers
— Return an array of available PDO drivers
PDO::inTransaction
— Checks if inside a transaction
PDO::lastInsertId
— Returns the ID of the last inserted row or sequence value
PDO::prepare
— Prepares a statement for execution and returns a statement object
PDO::query
— Prepares and executes an SQL statement without placeholders
PDO::quote
— Quotes a string for use in a query
PDO::rollBack
— Rolls back a transaction
PDO::setAttribute
— Set an attribute
PDOStatement
— The PDOStatement class
PDOStatement::bindColumn
— Bind a column to a PHP variable
PDOStatement::bindParam
— Binds a parameter to the specified variable name
PDOStatement::bindValue
— Binds a value to a parameter
PDOStatement::closeCursor
— Closes the cursor, enabling the statement to be executed again
PDOStatement::columnCount
— Returns the number of columns in the result set
PDOStatement::debugDumpParams
— Dump an SQL prepared command
PDOStatement::errorCode
— Fetch the SQLSTATE associated with the last operation on the statement handle
PDOStatement::errorInfo
— Fetch extended error information associated with the last operation on the statement handle
PDOStatement::execute
— Executes a prepared statement
PDOStatement::fetch
— Fetches the next row from a result set
PDOStatement::fetchAll
— Fetches the remaining rows from a result set
PDOStatement::fetchColumn
— Returns a single column from the next row of a result set
PDOStatement::fetchObject
— Fetches the next row and returns it as an object
PDOStatement::getAttribute
— Retrieve a statement attribute
PDOStatement::getColumnMeta
— Returns metadata for a column in a result set
PDOStatement::getIterator
— Gets result set iterator
PDOStatement::nextRowset
— Advances to the next rowset in a multi-rowset statement handle
PDOStatement::rowCount
— Returns the number of rows affected by the last SQL statement
PDOStatement::setAttribute
— Set a statement attribute
PDOStatement::setFetchMode
— Set the default fetch mode for this statement
PDORow
— The PDORow class
PDOException
— The PDOException class
PDO Drivers
CUBRID (PDO)
— CUBRID Functions (PDO_CUBRID)
MS SQL Server (PDO)
— Microsoft SQL Server and Sybase Functions (PDO_DBLIB)
Firebird (PDO)
— Firebird Functions (PDO_FIREBIRD)
IBM (PDO)
— IBM Functions (PDO_IBM)
Informix (PDO)
— Informix Functions (PDO_INFORMIX)
MySQL (PDO)
— MySQL Functions (PDO_MYSQL)
MS SQL Server (PDO)
— Microsoft SQL Server Functions (PDO_SQLSRV)
Oracle (PDO)
— Oracle Functions (PDO_OCI)
ODBC and DB2 (PDO)
— ODBC and DB2 Functions (PDO_ODBC)
PostgreSQL (PDO)
— PostgreSQL Functions (PDO_PGSQL)
SQLite (PDO)
— SQLite Functions (PDO_SQLITE)
Improve This Page
Learn How To Improve This Page
•
Submit a Pull Request
•
Report a Bug
+
add a note
User Contributed Notes
There are no user contributed notes for this page.