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 Introduction - 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

int - DB_OK on success. DB_Error object on failure.

Throws

Table 21-2. Possible PEAR_Error values

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

This function can not be called statically.

Example 21-1. Simple setOption() example

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

Example 21-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 21-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); ?>

Prev	Home	Next
DB_common::setFetchMode()	Up	DB_common::tableInfo()

Who's Online
Guest Users: 8

Free Sample Chapters
	Deliver First Class Web Sites: 101 Essential Checklists Want to learn how to make your web sites usable and accessible? Want to ensure that your sites meet current best practice, without spending hours trawling through incomprehensible specifications and recommendations from dozens of different books, research papers, and web sites? Want to make sure that the sites you build are "right the first time," requiring no costly redevelopments?
More Sample Chapters

PHP General