Latest web development tutorials

PDO :: getAttribute

PHP PDO Reference Manual PHP PDO Reference Manual

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


Explanation

grammar

mixed PDO::getAttribute ( int $attribute )

This function (method) Returns the value of a property database connection. Retrieve PDOStatement attributes, refer to PDOStatement :: getAttribute ().

Note that some database / driver may not support all of the database connection properties.

Parameter Description:

attribute:
PDO :: ATTR_ * constants a. The following are applied to the database connection constants:

  • 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

PDO attribute value requested successful call is returned. Unsuccessful returns null.

Examples

Retrieve a 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 PHP PDO Reference Manual