PDO::getAttribute – Retrieve a Database Connection Attribute

This function (method) returns the value of a PDO database connection attribute.

Parameter

attribute

One of the PDO::ATTR_* constants, such as:

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

On success, returns the requested PDO attribute value; on failure, returns null .

Example

<?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")) . "
";
}
?>