Become Zend Certified

Prepare for the ZCE exam using our quizzes (web or iPad/iPhone). More info...

When you're ready get 7.5% off your exam voucher using voucher CJQNOV23 at the Zend Store

The PDO class

Introduction

Represents a connection between PHP and a database server.

PDO {

__construct ( string $dsn [, string $username [, string $password [, array $driver_options ]]] )

bool beginTransaction ( void )

bool commit ( void )

mixed errorCode ( void )

array errorInfo ( void )

int exec ( string $statement )

mixed getAttribute ( int $attribute )

array getAvailableDrivers ( void )

bool inTransaction ( void )

string lastInsertId ([ string $name = NULL ] )

PDOStatement prepare ( string $statement [, array $driver_options = array() ] )

PDOStatement query ( string $statement )

string quote ( string $string [, int $parameter_type = PDO::PARAM_STR ] )

bool rollBack ( void )

bool setAttribute ( int $attribute , mixed $value )

}

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 - Executes an SQL statement, returning a result set as a PDOStatement object
PDO::quote - Quotes a string for use in a query.
PDO::rollBack - Rolls back a transaction
PDO::setAttribute - Set an attribute