PDO::getAttribute

PHP PDO Reference Manual

PDO::getAttribute — Retrieve a database connection attribute (PHP 5 >= 5.1.0, PECL pdo >= 0.1.0)

Description

Syntax

mixed PDO::getAttribute ( int $attribute )

This function (method) returns the value of a database connection attribute. To retrieve PDOStatement attributes, see PDOStatement::getAttribute().

Note that some databases/drivers may not support all database connection attributes.

Parameter Description:

attribute：
One of the PDO::ATTR_* constants. The following are the constants that apply to database connections:

• PDO::ATTR_AUTOCOMMIT
• PDO::ATTR_CASE
• PDO::ATTR_CLIENT_VERSION
• PDO::ATTR_CONNECTION_STATUS
• PDO::ATTR_DRIVER_NAME
• PDO::ATTR_ERRMODE
• PDO::ATTR_ORACLE_NULLS
• PDO::ATTR_PERSISTENT
• PDO::ATTR_PREFETCH
• PDO::ATTR_SERVER_INFO
• PDO::ATTR_SERVER_VERSION
• PDO::ATTR_TIMEOUT

Return Value

Returns the requested PDO attribute value on successful call. Returns null on failure.

Example

Retrieve database connection attribute

<?php
$conn = new PDO('odbc:sample', 'db2inst1', 'ibmdb2');
$attributes = array(
    "AUTOCOMMIT", "ERRMODE", "CASE", "CLIENT_VERSION", "CONNECTION_STATUS",
    "ORACLE_NULLS", "PERSISTENT", "PREFETCH", "SERVER_INFO", "SERVER_VERSION",
    "TIMEOUT"
);

foreach ($attributes as $val) {
    echo "PDO::ATTR_$val: ";
    echo $conn->getAttribute(constant("PDO::ATTR_$val")) . "\n";
}
?>

PHP PDO Reference Manual