DB_dbase Class Reference

Inheritance diagram for DB_dbase:

[legend]Collaboration diagram for DB_dbase:

[legend]List of all members.

Public Member Functions
	DB_dbase ()
	connect ($dsn, $persistent=false)
	disconnect ()
&	query ($query=null)
	fetchInto ($result, &$arr, $fetchmode, $rownum=null)
	numCols ($foo)
	numRows ($foo)
	quoteSmart ($in)
	tableInfo ($result=null, $mode=null)
	__sleep ()
	__wakeup ()
	__toString ()
	toString ()
	quoteString ($string)
	quote ($string=null)
	quoteIdentifier ($str)
	escapeSimple ($str)
	provides ($feature)
	setFetchMode ($fetchmode, $object_class= 'stdClass')
	setOption ($option, $value)
	getOption ($option)
	prepare ($query)
	autoPrepare ($table, $table_fields, $mode=DB_AUTOQUERY_INSERT, $where=false)
	autoExecute ($table, $fields_values, $mode=DB_AUTOQUERY_INSERT, $where=false)
	buildManipSQL ($table, $table_fields, $mode, $where=false)
&	execute ($stmt, $data=array())
	executeEmulateQuery ($stmt, $data=array())
	executeMultiple ($stmt, $data)
	freePrepared ($stmt, $free_resource=true)
	modifyQuery ($query)
	modifyLimitQuery ($query, $from, $count, $params=array())
&	query ($query, $params=array())
&	limitQuery ($query, $from, $count, $params=array())
&	getOne ($query, $params=array())
&	getRow ($query, $params=array(), $fetchmode=DB_FETCHMODE_DEFAULT)
&	getCol ($query, $col=0, $params=array())
&	getAssoc ($query, $force_array=false, $params=array(), $fetchmode=DB_FETCHMODE_DEFAULT, $group=false)
&	getAll ($query, $params=array(), $fetchmode=DB_FETCHMODE_DEFAULT)
	autoCommit ($onoff=false)
	commit ()
	rollback ()
	affectedRows ()
	getSequenceName ($sqn)
	nextId ($seq_name, $ondemand=true)
	createSequence ($seq_name)
	dropSequence ($seq_name)
&	raiseError ($code=DB_ERROR, $mode=null, $options=null, $userinfo=null, $nativecode=null)
	raiseError ($message=null, $code=null, $mode=null, $options=null, $userinfo=null, $error_class=null, $skipmsg=false)
	errorNative ()
	errorCode ($nativecode)
	errorMessage ($dbcode)
	getTables ()
	getListOf ($type)
	getSpecialQuery ($type)
	_rtrimArrayValues (&$array)
	_convertNullArrayValuesToEmpty (&$array)
	_PEAR ()
&	getStaticProperty ($class, $var)
	registerShutdownFunc ($func, $args=array())
	isError ($data, $code=null)
	setErrorHandling ($mode=null, $options=null)
	expectError ($code= '*')
	popExpect ()
	_checkDelExpect ($error_code)
	delExpect ($error_code)
	throwError ($message=null, $code=null, $userinfo=null)
	staticPushErrorHandling ($mode, $options=null)
	staticPopErrorHandling ()
	pushErrorHandling ($mode, $options=null)
	popErrorHandling ()
	loadExtension ($ext)
Public Attributes
	$phptype = 'dbase'
	$dbsyntax = 'dbase'
	$features
	$errorcode_map
	$connection
	$dsn = array()
	$res_row = array()
	$result = 0
	$types
	$fetchmode = DB_FETCHMODE_ORDERED
	$fetchmode_object_class = 'stdClass'
	$was_connected = null
	$last_query = ''
	$options
	$last_parameters = array()
	$prepare_tokens = array()
	$prepare_types = array()
	$prepared_queries = array()
	$_debug = false
	$_default_error_mode = null
	$_default_error_options = null
	$_default_error_handler = ''
	$_error_class = 'PEAR_Error'
	$_expected_errors = array()

---

Detailed Description

Definition at line 47 of file dbase.php.

---

Constructor & Destructor Documentation

DB_dbase::DB_dbase (   )

This constructor calls $this->DB_common() Returns: void Definition at line 147 of file dbase.php. References DB_common::DB_common(). { $this->DB_common(); }

---

Member Function Documentation

DB_common::__sleep (   )  [inherited]

Automatically indicates which properties should be saved when PHP's serialize() function is called Returns: array the array of properties names that should be saved Definition at line 147 of file common.php. { if ($this->connection) { // Don't disconnect(), people use serialize() for many reasons $this->was_connected = true; } else { $this->was_connected = false; } if (isset($this->autocommit)) { return array('autocommit', 'dbsyntax', 'dsn', 'features', 'fetchmode', 'fetchmode_object_class', 'options', 'was_connected', ); } else { return array('dbsyntax', 'dsn', 'features', 'fetchmode', 'fetchmode_object_class', 'options', 'was_connected', ); } }

DB_common::__toString (   )  [inherited]

Automatic string conversion for PHP 5 Returns: string a string describing the current PEAR DB object Since: Method available since Release 1.7.0 Definition at line 206 of file common.php. References $info. Referenced by DB_common::toString(). { $info = strtolower(get_class($this)); $info .= ': (phptype=' . $this->phptype . ', dbsyntax=' . $this->dbsyntax . ')'; if ($this->connection) { $info .= ' [connected]'; } return $info; }

DB_common::__wakeup (   )  [inherited]

Automatically reconnects to the database when PHP's unserialize() function is called The reconnection attempt is only performed if the object was connected at the time PHP's serialize() function was run. Returns: void Definition at line 189 of file common.php. { if ($this->was_connected) { $this->connect($this->dsn, $this->options); } }

PEAR::_checkDelExpect (  $  error_code  )  [inherited]

This method checks unsets an error code if available Parameters: mixed  error code Returns: bool true if the error code was unset, false otherwise private Since: PHP 4.3.0 Definition at line 396 of file PEAR.php. { $deleted = false; foreach ($this->_expected_errors AS $key => $error_array) { if (in_array($error_code, $error_array)) { unset($this->_expected_errors[$key][array_search($error_code, $error_array)]); $deleted = true; } // clean up empty arrays if (0 == count($this->_expected_errors[$key])) { unset($this->_expected_errors[$key]); } } return $deleted; }

DB_common::_convertNullArrayValuesToEmpty (  &$  array  )  [inherited]

Converts all null values in an array to empty strings Parameters: array  $array the array to be de-nullified (passed by reference) Returns: void protected Definition at line 2138 of file common.php. Referenced by DB_sybase::fetchInto(), DB_sqlite::fetchInto(), DB_odbc::fetchInto(), DB_oci8::fetchInto(), DB_mysqli::fetchInto(), DB_mysql::fetchInto(), DB_mssql::fetchInto(), DB_msql::fetchInto(), DB_ifx::fetchInto(), DB_fbsql::fetchInto(), and fetchInto(). { foreach ($array as $key => $value) { if (is_null($value)) { $array[$key] = ''; } } }

PEAR::_PEAR (   )  [inherited]

Destructor (the emulated type of...). Does nothing right now, but is included for forward compatibility, so subclass destructors should always call it. See the note in the class desciption about output from destructors. public Returns: void Definition at line 192 of file PEAR.php. { if ($this->_debug) { printf("PEAR destructor called, class=%s\n", strtolower(get_class($this))); } }

DB_common::_rtrimArrayValues (  &$  array  )  [inherited]

Right-trims all strings in an array Parameters: array  $array the array to be trimmed (passed by reference) Returns: void protected Definition at line 2117 of file common.php. Referenced by DB_sybase::fetchInto(), DB_sqlite::fetchInto(), DB_odbc::fetchInto(), DB_oci8::fetchInto(), DB_mysqli::fetchInto(), DB_mysql::fetchInto(), DB_mssql::fetchInto(), DB_msql::fetchInto(), DB_ifx::fetchInto(), DB_fbsql::fetchInto(), and fetchInto(). { foreach ($array as $key => $value) { if (is_string($value)) { $array[$key] = rtrim($value); } } }

DB_common::affectedRows (   )  [inherited]

Determines the number of rows affected by a data maniuplation query 0 is returned for queries that don't manipulate data. Returns: int the number of rows. A DB_Error object on failure. Reimplemented in DB_fbsql, DB_ibase, DB_ifx, DB_msql, DB_mssql, DB_mysql, DB_mysqli, DB_oci8, DB_odbc, DB_pgsql, DB_sqlite, and DB_sybase. Definition at line 1703 of file common.php. References DB_common::raiseError(). { return $this->raiseError(DB_ERROR_NOT_CAPABLE); }

DB_common::autoCommit (  $  onoff = false  )  [inherited]

Enables or disables automatic commits Parameters: bool  $onoff true turns it on, false turns it off Returns: int DB_OK on success. A DB_Error object if the driver doesn't support auto-committing transactions. Reimplemented in DB_fbsql, DB_ibase, DB_ifx, DB_mssql, DB_mysql, DB_mysqli, DB_oci8, DB_odbc, DB_pgsql, and DB_sybase. Definition at line 1647 of file common.php. References DB_common::raiseError(). { return $this->raiseError(DB_ERROR_NOT_CAPABLE); }

DB_common::autoExecute (  $  table, $  fields_values, $  mode = DB_AUTOQUERY_INSERT, $  where = false )  [inherited]

Automaticaly generates an insert or update query and call prepare() and execute() with it Parameters: string  $table the table name array  $fields_values the associative array where $key is a field name and $value its value int  $mode a type of query to make: DB_AUTOQUERY_INSERT or DB_AUTOQUERY_UPDATE string  $where for update queries: the WHERE clause to append to the SQL statement. Don't include the "WHERE" keyword. Returns: mixed a new DB_result object for successful SELECT queries or DB_OK for successul data manipulation queries. A DB_Error object on failure. DB_common::autoPrepare(), DB_common::execute() Definition at line 832 of file common.php. References DB_common::autoPrepare(), DB_common::execute(), DB_common::freePrepared(), and DB::isError(). { $sth = $this->autoPrepare($table, array_keys($fields_values), $mode, $where); if (DB::isError($sth)) { return $sth; } $ret =& $this->execute($sth, array_values($fields_values)); $this->freePrepared($sth); return $ret; }

DB_common::autoPrepare (  $  table, $  table_fields, $  mode = DB_AUTOQUERY_INSERT, $  where = false )  [inherited]

Automaticaly generates an insert or update query and pass it to prepare() Parameters: string  $table the table name array  $table_fields the array of field names int  $mode a type of query to make: DB_AUTOQUERY_INSERT or DB_AUTOQUERY_UPDATE string  $where for update queries: the WHERE clause to append to the SQL statement. Don't include the "WHERE" keyword. Returns: resource the query handle DB_common::prepare(), DB_common::buildManipSQL() Definition at line 800 of file common.php. References $query, DB_common::buildManipSQL(), DB::isError(), DB_common::prepare(), and DB_common::query(). Referenced by DB_common::autoExecute(). { $query = $this->buildManipSQL($table, $table_fields, $mode, $where); if (DB::isError($query)) { return $query; } return $this->prepare($query); }

DB_common::buildManipSQL (  $  table, $  table_fields, $  mode, $  where = false )  [inherited]

Produces an SQL query string for autoPrepare() Example: buildManipSQL('table_sql', array('field1', 'field2', 'field3'), DB_AUTOQUERY_INSERT); That returns <samp> INSERT INTO table_sql (field1,field2,field3) VALUES (?,?,?) </samp> NOTES: This belongs more to a SQL Builder class, but this is a simple facility. Be carefull! If you don't give a $where param with an UPDATE query, all the records of the table will be updated! Parameters: string  $table the table name array  $table_fields the array of field names int  $mode a type of query to make: DB_AUTOQUERY_INSERT or DB_AUTOQUERY_UPDATE string  $where for update queries: the WHERE clause to append to the SQL statement. Don't include the "WHERE" keyword. Returns: string the sql query for autoPrepare() Definition at line 879 of file common.php. References $set, $sql, $value, $values, and DB_common::raiseError(). Referenced by DB_common::autoPrepare(). { if (count($table_fields) == 0) { return $this->raiseError(DB_ERROR_NEED_MORE_DATA); } $first = true; switch ($mode) { case DB_AUTOQUERY_INSERT: $values = ''; $names = ''; foreach ($table_fields as $value) { if ($first) { $first = false; } else { $names .= ','; $values .= ','; } $names .= $value; $values .= '?'; } return "INSERT INTO $table ($names) VALUES ($values)"; case DB_AUTOQUERY_UPDATE: $set = ''; foreach ($table_fields as $value) { if ($first) { $first = false; } else { $set .= ','; } $set .= "$value = ?"; } $sql = "UPDATE $table SET $set"; if ($where) { $sql .= " WHERE $where"; } return $sql; default: return $this->raiseError(DB_ERROR_SYNTAX); } }

DB_common::commit (   )  [inherited]

Commits the current transaction Returns: int DB_OK on success. A DB_Error object on failure. Reimplemented in DB_fbsql, DB_ibase, DB_ifx, DB_mssql, DB_mysql, DB_mysqli, DB_oci8, DB_odbc, DB_pgsql, and DB_sybase. Definition at line 1660 of file common.php. References DB_common::raiseError(). { return $this->raiseError(DB_ERROR_NOT_CAPABLE); }

DB_dbase::connect (  $  dsn, $  persistent = false )

Connect to the database and create it if it doesn't exist Don't call this method directly. Use DB::connect() instead. PEAR DB's dbase driver supports the following extra DSN options: + mode An integer specifying the read/write mode to use (0 = read only, 1 = write only, 2 = read/write). Available since PEAR DB 1.7.0. + fields An array of arrays that PHP's dbase_create() function needs to create a new database. This information is used if the dBase file specified in the "database" segment of the DSN does not exist. For more info, see the PHP manual's dbase_create() page. Available since PEAR DB 1.7.0. Example of how to connect and establish a new dBase file if necessary: require_once 'DB.php'; $dsn = array( 'phptype' => 'dbase', 'database' => '/path/and/name/of/dbase/file', 'mode' => 2, 'fields' => array( array('a', 'N', 5, 0), array('b', 'C', 40), array('c', 'C', 255), array('d', 'C', 20), ), ); $options = array( 'debug' => 2, 'portability' => DB_PORTABILITY_ALL, ); $db =& DB::connect($dsn, $options); if (PEAR::isError($db)) { die($db->getMessage()); } Parameters: array  $dsn the data source name bool  $persistent should the connection be persistent? Returns: int DB_OK on success. A DB_Error object on failure. Definition at line 202 of file dbase.php. References $dsn, PEAR::loadExtension(), and DB_common::raiseError(). { if (!PEAR::loadExtension('dbase')) { return $this->raiseError(DB_ERROR_EXTENSION_NOT_FOUND); } $this->dsn = $dsn; if ($dsn['dbsyntax']) { $this->dbsyntax = $dsn['dbsyntax']; } /* * Turn track_errors on for entire script since $php_errormsg * is the only way to find errors from the dbase extension. */ ini_set('track_errors', 1); $php_errormsg = ''; if (!file_exists($dsn['database'])) { $this->dsn['mode'] = 2; if (empty($dsn['fields']) || !is_array($dsn['fields'])) { return $this->raiseError(DB_ERROR_CONNECT_FAILED, null, null, null, 'the dbase file does not exist and ' . 'it could not be created because ' . 'the "fields" element of the DSN ' . 'is not properly set'); } $this->connection = @dbase_create($dsn['database'], $dsn['fields']); if (!$this->connection) { return $this->raiseError(DB_ERROR_CONNECT_FAILED, null, null, null, 'the dbase file does not exist and ' . 'the attempt to create it failed: ' . $php_errormsg); } } else { if (!isset($this->dsn['mode'])) { $this->dsn['mode'] = 0; } $this->connection = @dbase_open($dsn['database'], $this->dsn['mode']); if (!$this->connection) { return $this->raiseError(DB_ERROR_CONNECT_FAILED, null, null, null, $php_errormsg); } } return DB_OK; }

DB_common::createSequence (  $  seq_name  )  [inherited]

Creates a new sequence The name of a given sequence is determined by passing the string provided in the $seq_name argument through PHP's sprintf() function using the value from the seqname_format option as the sprintf()'s format argument. seqname_format is set via setOption(). Parameters: string  $seq_name name of the new sequence Returns: int DB_OK on success. A DB_Error object on failure. See also: DB_common::dropSequence(), DB_common::getSequenceName(), DB_common::nextID() Reimplemented in DB_fbsql, DB_ibase, DB_msql, DB_mssql, DB_mysql, DB_mysqli, DB_oci8, DB_odbc, DB_pgsql, DB_sqlite, and DB_sybase. Definition at line 1772 of file common.php. References DB_common::raiseError(). { return $this->raiseError(DB_ERROR_NOT_CAPABLE); }

PEAR::delExpect (  $  error_code  )  [inherited]

This method deletes all occurences of the specified element from the expected error codes stack. Parameters: mixed  $error_code error code that should be deleted Returns: mixed list of error codes that were deleted or error public Since: PHP 4.3.0 Definition at line 426 of file PEAR.php. References PEAR::raiseError(). { $deleted = false; if ((is_array($error_code) && (0 != count($error_code)))) { // $error_code is a non-empty array here; // we walk through it trying to unset all // values foreach($error_code as $key => $error) { if ($this->_checkDelExpect($error)) { $deleted = true; } else { $deleted = false; } } return $deleted ? true : PEAR::raiseError("The expected error you submitted does not exist"); // IMPROVE ME } elseif (!empty($error_code)) { // $error_code comes alone, trying to unset it if ($this->_checkDelExpect($error_code)) { return true; } else { return PEAR::raiseError("The expected error you submitted does not exist"); // IMPROVE ME } } else { // $error_code is empty return PEAR::raiseError("The expected error you submitted is empty"); // IMPROVE ME } }

DB_dbase::disconnect (   )

Disconnects from the database server Returns: bool TRUE on success, FALSE on failure Definition at line 262 of file dbase.php. { $ret = @dbase_close($this->connection); $this->connection = null; return $ret; }

DB_common::dropSequence (  $  seq_name  )  [inherited]

Deletes a sequence Parameters: string  $seq_name name of the sequence to be deleted Returns: int DB_OK on success. A DB_Error object on failure. See also: DB_common::createSequence(), DB_common::getSequenceName(), DB_common::nextID() Reimplemented in DB_fbsql, DB_ibase, DB_msql, DB_mssql, DB_mysql, DB_mysqli, DB_oci8, DB_odbc, DB_pgsql, DB_sqlite, and DB_sybase. Definition at line 1790 of file common.php. References DB_common::raiseError(). { return $this->raiseError(DB_ERROR_NOT_CAPABLE); }

DB_common::errorCode (  $  nativecode  )  [inherited]

Maps native error codes to DB's portable ones Uses the $errorcode_map property defined in each driver. Parameters: string|int  $nativecode the error code returned by the DBMS Returns: int the portable DB error code. Return DB_ERROR if the current driver doesn't have a mapping for the $nativecode submitted. Reimplemented in DB_ibase, DB_ifx, DB_msql, DB_pgsql, DB_sqlite, and DB_sybase. Definition at line 1880 of file common.php. Referenced by DB_fbsql::fbsqlRaiseError(), and DB_odbc::odbcRaiseError(). { if (isset($this->errorcode_map[$nativecode])) { return $this->errorcode_map[$nativecode]; } // Fall back to DB_ERROR if there was no mapping. return DB_ERROR; }

DB_common::errorMessage (  $  dbcode  )  [inherited]

Maps a DB error code to a textual message Parameters: integer  $dbcode the DB error code Returns: string the error message corresponding to the error code submitted. FALSE if the error code is unknown. See also: DB::errorMessage() Definition at line 1902 of file common.php. References DB::errorMessage(). { return DB::errorMessage($this->errorcode_map[$dbcode]); }

DB_common::errorNative (   )  [inherited]

Gets the DBMS' native error code produced by the last query Returns: mixed the DBMS' error code. A DB_Error object on failure. Reimplemented in DB_fbsql, DB_ibase, DB_ifx, DB_msql, DB_mssql, DB_mysql, DB_mysqli, DB_oci8, DB_odbc, DB_pgsql, DB_sqlite, and DB_sybase. Definition at line 1861 of file common.php. References DB_common::raiseError(). { return $this->raiseError(DB_ERROR_NOT_CAPABLE); }

DB_common::escapeSimple (  $  str  )  [inherited]

Escapes a string according to the current DBMS's standards In SQLite, this makes things safe for inserts/updates, but may cause problems when performing text comparisons against columns containing binary data. See the PHP manual for more info. Parameters: string  $str the string to be escaped Returns: string the escaped string See also: DB_common::quoteSmart() Since: Method available since Release 1.6.0 Reimplemented in DB_msql, DB_mysql, DB_mysqli, DB_pgsql, and DB_sqlite. Definition at line 456 of file common.php. Referenced by quoteSmart(), and DB_common::quoteSmart(). { return str_replace("'", "''", $str); }

& DB_common::execute (  $  stmt, $  data = array() )  [inherited]

Executes a DB statement prepared with prepare() Example 1. $sth = $db->prepare('INSERT INTO tbl (a, b, c) VALUES (?, !, &)'); $data = array( "John's text", "'it''s good'", 'filename.txt' ); $res =& $db->execute($sth, $data); Parameters: resource  $stmt a DB statement resource returned from prepare() mixed  $data array, string or numeric data to be used in execution of the statement. Quantity of items passed must match quantity of placeholders in query: meaning 1 placeholder for non-array parameters or 1 placeholder per array element. Returns: mixed a new DB_result object for successful SELECT queries or DB_OK for successul data manipulation queries. A DB_Error object on failure. { Reimplemented in DB_ibase, and DB_oci8. Definition at line 952 of file common.php. References $result, $tmp, DB_common::executeEmulateQuery(), and DB::isError(). Referenced by DB_common::autoExecute(), DB_common::executeMultiple(), DB_common::getAll(), DB_common::getAssoc(), DB_common::getCol(), DB_common::getOne(), DB_common::getRow(), and DB_common::query(). { $realquery = $this->executeEmulateQuery($stmt, $data); if (DB::isError($realquery)) { return $realquery; } $result = $this->simpleQuery($realquery); if ($result === DB_OK || DB::isError($result)) { return $result; } else { $tmp =& new DB_result($this, $result); return $tmp; } }

DB_common::executeEmulateQuery (  $  stmt, $  data = array() )  [inherited]

Emulates executing prepared statements if the DBMS not support them Parameters: resource  $stmt a DB statement resource returned from execute() mixed  $data array, string or numeric data to be used in execution of the statement. Quantity of items passed must match quantity of placeholders in query: meaning 1 placeholder for non-array parameters or 1 placeholder per array element. Returns: mixed a string containing the real query run when emulating prepare/execute. A DB_Error object on failure. protected See also: DB_common::execute() Definition at line 987 of file common.php. References $data, $fp, $i, $value, DB_common::quoteSmart(), and DB_common::raiseError(). Referenced by DB_common::execute(). { $stmt = (int)$stmt; $data = (array)$data; $this->last_parameters = $data; if (count($this->prepare_types[$stmt]) != count($data)) { $this->last_query = $this->prepared_queries[$stmt]; return $this->raiseError(DB_ERROR_MISMATCH); } $realquery = $this->prepare_tokens[$stmt][0]; $i = 0; foreach ($data as $value) { if ($this->prepare_types[$stmt][$i] == DB_PARAM_SCALAR) { $realquery .= $this->quoteSmart($value); } elseif ($this->prepare_types[$stmt][$i] == DB_PARAM_OPAQUE) { $fp = @fopen($value, 'rb'); if (!$fp) { return $this->raiseError(DB_ERROR_ACCESS_VIOLATION); } $realquery .= $this->quoteSmart(fread($fp, filesize($value))); fclose($fp); } else { $realquery .= $value; } $realquery .= $this->prepare_tokens[$stmt][++$i]; } return $realquery; }

DB_common::executeMultiple (  $  stmt, $  data )  [inherited]

Performs several execute() calls on the same statement handle $data must be an array indexed numerically from 0, one execute call is done for every "row" in the array. If an error occurs during execute(), executeMultiple() does not execute the unfinished rows, but rather returns that error. Parameters: resource  $stmt query handle from prepare() array  $data numeric array containing the data to insert into the query Returns: int DB_OK on success. A DB_Error object on failure. See also: DB_common::prepare(), DB_common::execute() Definition at line 1041 of file common.php. References DB_common::execute(), and DB::isError(). { foreach ($data as $value) { $res =& $this->execute($stmt, $value); if (DB::isError($res)) { return $res; } } return DB_OK; }

PEAR::expectError (  $  code = '*'  )  [inherited]

This method is used to tell which errors you expect to get. Expected errors are always returned with error mode PEAR_ERROR_RETURN. Expected error codes are stored in a stack, and this method pushes a new element onto it. The list of expected errors are in effect until they are popped off the stack with the popExpect() method. Note that this method can not be called statically Parameters: mixed  $code a single error code or an array of error codes to expect Returns: int the new depth of the "expected errors" stack public Definition at line 361 of file PEAR.php. { if (is_array($code)) { array_push($this->_expected_errors, $code); } else { array_push($this->_expected_errors, array($code)); } return sizeof($this->_expected_errors); }

DB_dbase::fetchInto (  $  result, &$  arr, $  fetchmode, $  rownum = null )

Places a row from the result set into the given array Formating of the array and the data therein are configurable. See DB_result::fetchInto() for more information. This method is not meant to be called directly. Use DB_result::fetchInto() instead. It can't be declared "protected" because DB_result is a separate object. Parameters: resource  $result the query result resource array  $arr the referenced array to put the data in int  $fetchmode how the resulting array should be indexed int  $rownum the row number to fetch (0 = first row) Returns: mixed DB_OK on success, NULL when the end of a result set is reached or on failure See also: DB_result::fetchInto() Definition at line 303 of file dbase.php. References $result, DB_common::_convertNullArrayValuesToEmpty(), and DB_common::_rtrimArrayValues(). { if ($rownum === null) { $rownum = $this->res_row[(int)$result]++; } if ($fetchmode & DB_FETCHMODE_ASSOC) { $arr = @dbase_get_record_with_names($this->connection, $rownum); if ($this->options['portability'] & DB_PORTABILITY_LOWERCASE && $arr) { $arr = array_change_key_case($arr, CASE_LOWER); } } else { $arr = @dbase_get_record($this->connection, $rownum); } if (!$arr) { return null; } if ($this->options['portability'] & DB_PORTABILITY_RTRIM) { $this->_rtrimArrayValues($arr); } if ($this->options['portability'] & DB_PORTABILITY_NULL_TO_EMPTY) { $this->_convertNullArrayValuesToEmpty($arr); } return DB_OK; }

DB_common::freePrepared (  $  stmt, $  free_resource = true )  [inherited]

Frees the internal resources associated with a prepared query Parameters: resource  $stmt the prepared statement's PHP resource bool  $free_resource should the PHP resource be freed too? Use false if you need to get data from the result set later. Returns: bool TRUE on success, FALSE if $result is invalid See also: DB_common::prepare() Reimplemented in DB_ibase, and DB_oci8. Definition at line 1067 of file common.php. Referenced by DB_common::autoExecute(), DB_common::getAll(), DB_common::getAssoc(), DB_common::getCol(), DB_common::getOne(), DB_common::getRow(), and DB_common::query(). 01068 { 01069 $stmt = (int)$stmt; 01070 if (isset($this->prepare_tokens[$stmt])) { 01071 unset($this->prepare_tokens[$stmt]); 01072 unset($this->prepare_types[$stmt]); 01073 unset($this->prepared_queries[$stmt]); <