DB_common::setOption()

DB_common::setOption() – Sets run-time configuration options for PEAR DB

Synopsis

integer setOption ( string $option , mixed $value )

Description

Sets run-time configuration options for PEAR DB.

Parameter

string $option

name of the option to set

mixed $value

value to set the option to

Option Data Type Default Value Description
autofree boolean FALSE should results be freed automatically when there are no more rows?
debug integer 0 debug level
persistent boolean FALSE should the connection be persistent?
portability integer DB_PORTABILITY_NONE portability mode constant. These constants are bitwised, so they can be combined using | and removed using ^. See the examples below and the "Intro - Portability" for more information.
seqname_format string %s_seq the sprintf() format string used on sequence names. This format is applied to sequence names passed to createSequence(), nextID() and dropSequence().
ssl boolean FALSE use ssl to connect?

Return value

integer - DB_OK on success or a DB_Error object on failure

Throws

Possible PEAR_Error values
Error code Error message Reason Solution
NULL unknown option The given option does not exist Check $option for typographical errors

Note

This function can not be called statically.

Example

Simple setOption() example

<?php
// Once you have a valid DB object named $db...
$db->setOption('autofree'true);
?>

Portability for lowercasing and trimming

<?php
// Once you have a valid DB object named $db...
$db->setOption('portability',
    
DB_PORTABILITY_LOWERCASE DB_PORTABILITY_RTRIM);
?>

All portability options except trimming

<?php
// Once you have a valid DB object named $db...
$db->setOption('portability',
    
DB_PORTABILITY_ALL DB_PORTABILITY_RTRIM);
?>