|
|
| Microsoft Drivers for PHP for SQL Server version 2.0 and 3.0 |
| PDOStatement::setAttribute |
| Example See Also Send Feedback |
Sets an attribute value, either a predefined PDO attribute or a custom driver attribute.
Syntax
bool PDOStatement::setAttribute ($attribute, $value ); |
Parameters
$attribute: An integer, one of the PDO::ATTR_* or PDO::SQLSRV_ATTR_* constants. See the Remarks section for the list of available attributes.
$value: The (mixed) value to be set for the specified $attribute.
Return Value
TRUE on success, FALSE otherwise.
Remarks
The following table contains the list of available attributes:
|
Attribute |
Values |
Description |
|---|---|---|
|
PDO::SQLSRV_ATTR_CLIENT_BUFFER_MAX_KB_SIZE |
1 to the PHP memory limit. |
Configures the size of the buffer that holds the result set for a client-side cursor. The default is 10240 KB (10 MB). For more information about client-side cursors, see Cursor Types (PDO_SQLSRV Driver). |
|
PDO::SQLSRV_ATTR_ENCODING |
Integer PDO::SQLSRV_ENCODING_UTF8 (Default) PDO::SQLSRV_ENCODING_SYSTEM PDO::SQLSRV_ENCODING_BINARY |
Sets the character set encoding to be used by the driver to communicate with the server. |
|
PDO::SQLSRV_ATTR_QUERY_TIMEOUT |
Integer |
Sets the query timeout in seconds. By default, the driver will wait indefinitely for results. Negative numbers are not allowed. 0 means no timeout. |
Example
|
Copy Code
|
|
|---|---|
<?php
$database = "AdventureWorks";
$server = "(local)";
$conn = new PDO( "sqlsrv:server=$server ; Database = $database", "", "", array('MultipleActiveResultSets'=>false ) );
$stmt = $conn->prepare('SELECT * FROM Person.ContactType');
echo $stmt->getAttribute( constant( "PDO::ATTR_CURSOR" ) );
echo "\n";
$stmt->setAttribute(PDO::SQLSRV_ATTR_QUERY_TIMEOUT, 2);
echo $stmt->getAttribute( constant( "PDO::SQLSRV_ATTR_QUERY_TIMEOUT" ) );
?>
|
|
