PDO->setAttribute()

(PHP 5 >= 5.1.0, PECL pdo:0.1-1.0.3)

PDO->setAttribute() — Set an attribute

Description

PDO

bool setAttribute ( int $attribute , mixed $value )

Sets an attribute on the database handle. Some of the available generic attributes are listed below; some drivers may make use of additional driver specific attributes.

PDO::ATTR_CASE: Force column names to a specific case.
- PDO::CASE_LOWER: Force column names to lower case.
- PDO::CASE_NATURAL: Leave column names as returned by the database driver.
- PDO::CASE_UPPER: Force column names to upper case.
PDO::ATTR_ERRMODE: Error reporting.
- PDO::ERRMODE_SILENT: Just set error codes.
- PDO::ERRMODE_WARNING: Raise E_WARNING.
- PDO::ERRMODE_EXCEPTION: Throw exceptions.
PDO::ATTR_ORACLE_NULLS (available with all drivers, not just Oracle): Conversion of NULL and empty strings.
- PDO::NULL_NATURAL: No conversion.
- PDO::NULL_EMPTY_STRING: Empty string is converted to NULL.
- PDO::NULL_TO_STRING: NULL is converted to an empty string.
PDO::ATTR_STRINGIFY_FETCHES: Convert numeric values to strings when fetching. Requires bool.
PDO::ATTR_STATEMENT_CLASS: Set user-supplied statement class derived from PDOStatement. Cannot be used with persistent PDO instances. Requires array(string classname, array(mixed constructor_args)).
PDO::ATTR_AUTOCOMMIT (available in OCI, Firebird and MySQL): Whether to autocommit every single statement.
PDO::MYSQL_ATTR_USE_BUFFERED_QUERY (available in MySQL): Use buffered queries.

Return Values

Returns TRUE on success or FALSE on failure.

add a note User Contributed Notes
PDO->setAttribute()

colinganderson [at] gmail [dot] com
18-May-2007 10:59


Because no examples are provided, and to alleviate any confusion as a result, the setAttribute() method is invoked like so:



setAttribute(ATTRIBUTE, OPTION);



So, if I wanted to ensure that the column names returned from a query were returned in the case the database driver returned them (rather than having them returned in all upper case [as is the default on some of the PDO extensions]), I would do the following:



<?php

// Create a new database connection.

$dbConnection = new PDO($dsn, $user, $pass);



// Set the case in which to return column_names.

$dbConnection->setAttribute(PDO::ATTR_CASE, PDO::CASE_NATURAL);

?>



Hope this helps some of you who learn by example (as is the case with me).



.Colin

gregory dot szorc at gmail dot com
14-Feb-2007 11:32


It is worth noting that not all attributes may be settable via setAttribute().  For example, PDO::MYSQL_ATTR_MAX_BUFFER_SIZE is only settable in PDO::__construct().  You must pass PDO::MYSQL_ATTR_MAX_BUFFER_SIZE as part of the optional 4th parameter to the constructor.  This is detailed in http://bugs.php.net/bug.php?id=38015

add a note

PDOStatement->bindColumn()

PDO->rollBack()

Last updated: Sun, 25 Nov 2007