PDO:: getAttribute explanation

PDO::getAttribute

PDO:: getAttribute-Retrieves the properties of 1 database connection (PHP 5 > = 5.1.0, PECL pdo > = 0.1.0)

Description

Grammar

mixed PDO::getAttribute ( int $attribute )

This function (method) returns the property value of 1 database connection. To retrieve the PDOStatement property, see PDOStatement::getAttribute() .

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

Parameter description:

attribute:

PDO:: One of the ATTR_* constants. The following constants apply to database connections:

_PDO::ATTRAUTOCOMMIT _PDO::ATTRCASE _PDO::ATTR_CLIENTVERSION _PDO::ATTR_CONNECTIONSTATUS _PDO::ATTR_DRIVERNAME _PDO::ATTRERRMODE _PDO::ATTR_ORACLENULLS _PDO::ATTRPERSISTENT _PDO::ATTRPREFETCH _PDO::ATTR_SERVERINFO _PDO::ATTR_SERVERVERSION _PDO::ATTRTIMEOUT

Return value

A successful call returns the requested PDO property value. Unsuccessful returns null.

Instances

Retrieve database connection properties

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

Summarize