The PDO class

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.1.0)

Introduction

Represents a connection between PHP and a database server.

PDO {

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

public bool beginTransaction ( void )

public bool commit ( void )

public mixed errorCode ( void )

public array errorInfo ( void )

public int exec ( string $statement )

public mixed getAttribute ( int $attribute )

public static array getAvailableDrivers ( void )

public bool inTransaction ( void )

public string lastInsertId ([ string $name = NULL ] )

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

public PDOStatement query ( string $statement )

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

public bool rollBack ( void )

public 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