DB_sybase Class Reference

Inheritance diagram for DB_sybase:

[legend]Collaboration diagram for DB_sybase:

[legend]List of all members.

Public Member Functions
	DB_sybase ()
	connect ($dsn, $persistent=false)
	disconnect ()
	simpleQuery ($query)
	nextResult ($result)
	fetchInto ($result, &$arr, $fetchmode, $rownum=null)
	freeResult ($result)
	numCols ($result)
	numRows ($result)
	affectedRows ()
	nextId ($seq_name, $ondemand=true)
	createSequence ($seq_name)
	dropSequence ($seq_name)
	autoCommit ($onoff=false)
	commit ()
	rollback ()
	sybaseRaiseError ($errno=null)
	errorNative ()
	errorCode ($errormsg)
	tableInfo ($result, $mode=null)
	_sybase_field_flags ($table, $column)
	_add_flag (&$array, $value)
	getSpecialQuery ($type)
	__sleep ()
	__wakeup ()
	__toString ()
	toString ()
	quoteString ($string)
	quote ($string=null)
	quoteIdentifier ($str)
	quoteSmart ($in)
	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)
	getSequenceName ($sqn)
&	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)
	errorMessage ($dbcode)
	getTables ()
	getListOf ($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 = 'sybase'
	$dbsyntax = 'sybase'
	$features
	$errorcode_map
	$connection
	$dsn = array()
	$autocommit = true
	$transaction_opcount = 0
	$_db = ''
	$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 52 of file sybase.php.

---

Constructor & Destructor Documentation

DB_sybase::DB_sybase (   )

This constructor calls $this->DB_common() Returns: void Definition at line 148 of file sybase.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); } }

DB_sybase::_add_flag (  &$  array, $  value )

Adds a string to the flags array if the flag is not yet in there if there is no flag present the array is created Parameters: array  $array reference of flags array to add a value to mixed  $value value to add to the flag array Returns: void private Definition at line 860 of file sybase.php. { if (!is_array($array)) { $array = array($value); } elseif (!in_array($value, $array)) { array_push($array, $value); } }

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 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 DB_dbase::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 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 DB_dbase::fetchInto(). { foreach ($array as $key => $value) { if (is_string($value)) { $array[$key] = rtrim($value); } } }

DB_sybase::_sybase_field_flags (  $  table, $  column )

Get the flags for a field Currently supports: + <samp>unique_key</samp> (unique index, unique check or primary_key) + <samp>multiple_key</samp> (multi-key index) Parameters: string  $table the table name string  $column the field name Returns: string space delimited string of flags. Empty string if none. private Definition at line 805 of file sybase.php. { static $tableName = null; static $flags = array(); if ($table != $tableName) { $flags = array(); $tableName = $table; // get unique/primary keys $res = $this->getAll("sp_helpindex $table", DB_FETCHMODE_ASSOC); if (!isset($res[0]['index_description'])) { return ''; } foreach ($res as $val) { $keys = explode(', ', trim($val['index_keys'])); if (sizeof($keys) > 1) { foreach ($keys as $key) { $this->_add_flag($flags[$key], 'multiple_key'); } } if (strpos($val['index_description'], 'unique')) { foreach ($keys as $key) { $this->_add_flag($flags[$key], 'unique_key'); } } } } if (array_key_exists($column, $flags)) { return(implode(' ', $flags[$column])); } return ''; }

DB_sybase::affectedRows (   )

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 from DB_common. Definition at line 436 of file sybase.php. References $result, and DB::isManip(). { if (DB::isManip($this->last_query)) { $result = @sybase_affected_rows($this->connection); } else { $result = 0; } return $result; }

DB_sybase::autoCommit (  $  onoff = false  )

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 from DB_common. Definition at line 542 of file sybase.php. { // XXX if $this->transaction_opcount > 0, we should probably // issue a warning here. $this->autocommit = $onoff ? true : false; return DB_OK; }

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_sybase::commit (   )

Commits the current transaction Returns: int DB_OK on success. A DB_Error object on failure. Reimplemented from DB_common. Definition at line 558 of file sybase.php. References $result, and sybaseRaiseError(). { if ($this->transaction_opcount > 0) { if (!@sybase_select_db($this->_db, $this->connection)) { return $this->sybaseRaiseError(DB_ERROR_NODBSELECTED); } $result = @sybase_query('COMMIT', $this->connection); $this->transaction_opcount = 0; if (!$result) { return $this->sybaseRaiseError(); } } return DB_OK; }

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

Connect to the database server, log in and open the database Don't call this method directly. Use DB::connect() instead. PEAR DB's sybase driver supports the following extra DSN options: + appname The application name to use on this connection. Available since PEAR DB 1.7.0. + charset The character set to use on this connection. Available since PEAR DB 1.7.0. 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 172 of file sybase.php. References $dsn, PEAR::loadExtension(), and DB_common::raiseError(). { if (!PEAR::loadExtension('sybase') && !PEAR::loadExtension('sybase_ct')) { return $this->raiseError(DB_ERROR_EXTENSION_NOT_FOUND); } $this->dsn = $dsn; if ($dsn['dbsyntax']) { $this->dbsyntax = $dsn['dbsyntax']; } $dsn['hostspec'] = $dsn['hostspec'] ? $dsn['hostspec'] : 'localhost'; $dsn['password'] = !empty($dsn['password']) ? $dsn['password'] : false; $dsn['charset'] = isset($dsn['charset']) ? $dsn['charset'] : false; $dsn['appname'] = isset($dsn['appname']) ? $dsn['appname'] : false; $connect_function = $persistent ? 'sybase_pconnect' : 'sybase_connect'; if ($dsn['username']) { $this->connection = @$connect_function($dsn['hostspec'], $dsn['username'], $dsn['password'], $dsn['charset'], $dsn['appname']); } else { return $this->raiseError(DB_ERROR_CONNECT_FAILED, null, null, null, 'The DSN did not contain a username.'); } if (!$this->connection) { return $this->raiseError(DB_ERROR_CONNECT_FAILED, null, null, null, @sybase_get_last_message()); } if ($dsn['database']) { if (!@sybase_select_db($dsn['database'], $this->connection)) { return $this->raiseError(DB_ERROR_NODBSELECTED, null, null, null, @sybase_get_last_message()); } $this->_db = $dsn['database']; } return DB_OK; }

DB_sybase::createSequence (  $  seq_name  )

Creates a new sequence 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::createSequence(), DB_common::getSequenceName(), DB_sybase::nextID(), DB_sybase::dropSequence() Reimplemented from DB_common. Definition at line 505 of file sybase.php. References DB_common::query(). Referenced by nextId(). { return $this->query('CREATE TABLE ' . $this->getSequenceName($seq_name) . ' (id numeric(10, 0) IDENTITY NOT NULL,' . ' vapor int NULL)'); }

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_sybase::disconnect (   )

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

DB_sybase::dropSequence (  $  seq_name  )

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::dropSequence(), DB_common::getSequenceName(), DB_sybase::nextID(), DB_sybase::createSequence() Reimplemented from DB_common. Definition at line 526 of file sybase.php. References DB_common::query(). { return $this->query('DROP TABLE ' . $this->getSequenceName($seq_name)); }

DB_sybase::errorCode (  $  errormsg  )

Determines PEAR::DB error code from the database's text error message. Parameters: string  $errormsg error message returned from the database Returns: integer an error number from a DB error constant Reimplemented from DB_common. Definition at line 642 of file sybase.php. References DB_common::quote(). Referenced by sybaseRaiseError(). { static $error_regexps; if (!isset($error_regexps)) { $error_regexps = array( '/Incorrect syntax near/' => DB_ERROR_SYNTAX, '/^Unclosed quote before the character string [\"\'].*[\"\']\./' => DB_ERROR_SYNTAX, '/Implicit conversion (from datatype|of NUMERIC value)/i' => DB_ERROR_INVALID_NUMBER, '/Cannot drop the table [\"\'].+[\"\'], because it doesn\'t exist in the system catalogs\./' => DB_ERROR_NOSUCHTABLE, '/Only the owner of object [\"\'].+[\"\'] or a user with System Administrator \(SA\) role can run this command\./' => DB_ERROR_ACCESS_VIOLATION, '/^.+ permission denied on object .+, database .+, owner .+/' => DB_ERROR_ACCESS_VIOLATION, '/^.* permission denied, database .+, owner .+/' => DB_ERROR_ACCESS_VIOLATION, '/[^.*] not found\./' => DB_ERROR_NOSUCHTABLE, '/There is already an object named/' => DB_ERROR_ALREADY_EXISTS, '/Invalid column name/' => DB_ERROR_NOSUCHFIELD, '/does not allow null values/' => DB_ERROR_CONSTRAINT_NOT_NULL, '/Command has been aborted/' => DB_ERROR_CONSTRAINT, '/^Cannot drop the index .* because it doesn\'t exist/i' => DB_ERROR_NOT_FOUND, '/^There is already an index/i' => DB_ERROR_ALREADY_EXISTS, '/^There are fewer columns in the INSERT statement than values specified/i' => DB_ERROR_VALUE_COUNT_ON_ROW, ); } foreach ($error_regexps as $regexp => $code) { if (preg_match($regexp, $errormsg)) { return $code; } } 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_sybase::errorNative (   )

Gets the DBMS' native error message produced by the last query Returns: string the DBMS' error message Reimplemented from DB_common. Definition at line 628 of file sybase.php. Referenced by sybaseRaiseError(). { return @sybase_get_last_message(); }

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 DB_dbase::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_sybase::fetchInto (  $  result,