php8.5
/
Download
Home/ Manual/ reference / pdo/ The PDO class

The PDO class

Guide Edit on GitHub ✎

Represents a connection between PHP and a database server.

Intro

Represents a connection between PHP and a database server.

Class synopsis

class PDO { }

Changelog

VersionDescription
8.5.0Driver-specific constants of the PDO class have been deprecated in favor of the equivalent constants of the driver-specific subclasses (Pdo\Dblib, Pdo\Firebird, Pdo\Mysql, Pdo\Odbc, Pdo\Pgsql, Pdo\Sqlite).
8.4.0The class constants are now typed.

Pdo

In this section

PDO::__construct

Creates a PDO instance representing a connection to a database

PDO::beginTransaction

Initiates a transaction

PDO::commit

Commits a transaction

PDO::connect

Connect to a database and return a PDO subclass for drivers that support it

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

Source: reference/pdo/pdo.xml · from the official PHP manual (php/doc-en)