Main Menu
PHP Tools
PHP Help Request
PHP Editors Newsletter
Editor Search
Reviewed PHP Editors
Latest News
Submit News
PHP Tutorials
PHP Book Reviews
Online Book Chapters
PHP Games

Forums
RSS 2.0
PHP Desktop Editors
Other PHP Tools
PHP Contests
PHP Programming Help
Linux Help
Apache Help
MySQL Help
PHP Games
PHP Jobs
PHP Forums Home

Programming Contest
PHP Contests
PHP Contests Archive

Documentation
PHP Manual
PEAR Manual
PHP-GTK Manual
Smarty Manual
PostgreSQL Manual
CSS 2 Reference
Redhat Linux 9
HTML 4.01
Apache 2 Manual

Partner Sites
Ajax Tutorials
Webmaster Resources
Web Templates
PHP Scripts
PHP Code Examples
Learn PHP playing Trivia
PHP & MySQL Forums
Web Development Index
web site templates

Sponsors

NuSphere

DB_common::setOption()
PEAR Manual
PrevNext

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

Table 33-1.

OptionData TypeDefault ValueDescription
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

Table 33-2. Possible PEAR_Error values

Error codeError messageReasonSolution
NULL unknown option The given option does not exist Check $option for typographical errors

Note

This function can not be called statically.

Example

Example 33-1. Simple setOption() example

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

Example 33-2. Portability for lowercasing and trimming

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

Example 33-3. All portability options except trimming

<?php
// Once you have a valid DB object named $db...
$db->setOption('portability',
    DB_PORTABILITY_ALL ^ DB_PORTABILITY_RTRIM);
?>
PrevHomeNext
DB_common::setFetchMode()UpDB_common::tableInfo()
© Copyright 2003-2023 www.php-editors.com. The ultimate PHP Editor and PHP IDE site.