Documentation TYPO3 par Ameos

Disponible dans d'autres versions de TYPO3 -> 3.7.0 3.8.1 4.0.0 4.0.1 4.1.0 <- Available in other TYPO3 versions

ADODB_oci8 Class Reference

Inheritance diagram for ADODB_oci8:[legend]Collaboration diagram for ADODB_oci8:[legend]List of all members.


Public Member Functions
	ADODB_oci8 ()
&	MetaColumns ($table)
	Time ()
	_connect ($argHostname, $argUsername, $argPassword, $argDatabasename, $mode=0)
	ServerInfo ()
	_pconnect ($argHostname, $argUsername, $argPassword, $argDatabasename)
	_nconnect ($argHostname, $argUsername, $argPassword, $argDatabasename)
	_affectedrows ()
	IfNull ($field, $ifNull)
	DBDate ($d)
	BindDate ($d)
	BindTimeStamp ($d)
	DBTimeStamp ($ts)
	RowLock ($tables, $where, $flds='1 as ignore')
&	MetaTables ($ttype=false, $showSchema=false, $mask=false)
&	MetaIndexes ($table, $primary=FALSE, $owner=false)
	BeginTrans ()
	CommitTrans ($ok=true)
	RollbackTrans ()
	SelectDB ($dbName)
	ErrorMsg ()
	ErrorNo ()
	SQLDate ($fmt, $col=false)
&	SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
	UpdateBlob ($table, $column, $val, $where, $blobtype='BLOB')
	UpdateBlobFile ($table, $column, $val, $where, $blobtype='BLOB')
&	Execute ($sql, $inputarr=false)
	Prepare ($sql, $cursor=false)
&	ExecuteCursor ($sql, $cursorName='rs', $params=false)
	Bind (&$stmt, &$var, $size=4000, $type=false, $name=false, $isOutput=false)
	Param ($name, $type=false)
	Parameter (&$stmt, &$var, $name, $isOutput=false, $maxLen=4000, $type=false)
	_query ($sql, $inputarr)
	_close ()
	MetaPrimaryKeys ($table, $owner=false, $internalKey=false)
	MetaForeignKeys ($table, $owner=false)
	CharMax ()
	TextMax ()
	qstr ($s, $magic_quotes=false)
Public Attributes
	$databaseType = 'oci8'
	$dataProvider = 'oci8'
	$replaceQuote = "''"
	string that represents FALSE for a database
	$concat_operator = '\|\|'
	maximum size of blobs or large text fields (262144 = 256K)-- some db's die otherwise like foxpro
	$sysDate = "TRUNC(SYSDATE)"
	Use 'true' to store the item compressed (uses zlib).
	$sysTimeStamp = 'SYSDATE'
	name of function that returns the current date
	$metaDatabasesSQL = "SELECT USERNAME FROM ALL_USERS WHERE USERNAME NOT IN ('SYS','SYSTEM','DBSNMP','OUTLN') ORDER BY 1"
	character set to use - only for interbase, postgres and oci8
	$_stmt
	$_commit = OCI_COMMIT_ON_SUCCESS
	$_initdate = true
	$metaTablesSQL = "select table_name,table_type from cat where table_type in ('TABLE','VIEW') and table_name not like 'BIN\$%'"
	$metaColumnsSQL = "select cname,coltype,width, SCALE, PRECISION, NULLS, DEFAULTVAL from col where tname='%s' order by colno"
	$_bindInputArray = true
	A boolean variable to state whether its a persistent connection or normal connection. */.
	$hasGenID = true
	has ability to run MoveFirst(), scrolling backwards
	$_genIDSQL = "SELECT (%s.nextval) FROM DUAL"
	$_genSeqSQL = "CREATE SEQUENCE %s START WITH %s"
	$_dropSeqSQL = "DROP SEQUENCE %s"
	$hasAffectedRows = true
	supports autoincrement ID?
	$random = "abs(mod(DBMS_RANDOM.RANDOM,10000001)/10000000)"
	string length ofperator
	$noNullStrings = false
	name of class used to generate array recordsets, which are pre-downloaded recordsets
	$connectSID = false
	$_bind = false
	$_nestedSQL = true
	$_hasOCIFetchStatement = false
	$_getarray = false
	$leftOuter = ''
	indicates that all fields in order by must be unique
	$session_sharing_force_blob = false
	$firstrows = true
	$selectOffsetAlg1 = 100
	$NLS_DATE_FORMAT = 'YYYY-MM-DD'
	$useDBDateFormatForTextInput = false
	$datetime = false
	$_refLOBs = array()

Detailed Description

Definition at line 55 of file adodb-oci8.inc.php.

Member Function Documentation

ADODB_oci8::ServerInfo ( )

Get server version info...

Returns:: An array with 2 elements: $arr['string'] is the description string, and $arr[version] is the version (also a string).

Reimplemented from ADOConnection.

Definition at line 243 of file adodb-oci8.inc.php.

References ADOConnection::_findvers(), and ADOConnection::GetOne().

ADODB_oci8::DBDate ( $ d )

Converts a date "d" to a string that the database can understand.

Parameters:

a date in Unix date time format.

Returns:: date string in database date format

Reimplemented from ADOConnection.

Definition at line 274 of file adodb-oci8.inc.php.

References ADORecordSet::UnixDate().

ADODB_oci8::DBTimeStamp ( $ ts )

Converts a timestamp "ts" to a string that the database can understand.

Parameters:

a timestamp in Unix date time format.

Returns:: timestamp string in database timestamp format

Reimplemented from ADOConnection.

Definition at line 299 of file adodb-oci8.inc.php.

References ADORecordSet::UnixTimeStamp().

& ADODB_oci8::MetaTables	(	$	ttype = `false`,
		$	showSchema = `false`,
		$	mask = `false`
	)

Parameters:

	ttype	can either be 'VIEW' or 'TABLE' or false. If false, both views and tables are returned. "VIEW" returns only views "TABLE" returns only tables
	showSchema	returns the schema/user with the table name, eg. USER.TABLE
	mask	is the input mask - only supported by oci8 and postgresql

Returns:: array of tables for current database.

Reimplemented from ADOConnection.

Definition at line 312 of file adodb-oci8.inc.php.

References ADOConnection::MetaTables(), and qstr().

& ADODB_oci8::MetaIndexes	(	$	table,
		$	primary = `FALSE`,
		$	owner = `false`
	)

List indexes on a table as an array.

Parameters:

	table	table name to query
	primary	true to only show primary keys. Not actually used for most databases

Returns:: array of indexes on current table. Each element represents an index, and is itself an associative array.

Array ( [name_of_index] => Array ( [unique] => true or false [columns] => Array ( [0] => firstname [1] => lastname ) )

Reimplemented from ADOConnection.

Definition at line 328 of file adodb-oci8.inc.php.

References ADOConnection::$false, Execute(), and ADOConnection::SetFetchMode().

ADODB_oci8::BeginTrans ( )

Begin a Transaction. Must be followed by CommitTrans() or RollbackTrans().

Returns:: true if succeeded or false if database does not support transactions

Reimplemented from ADOConnection.

Definition at line 394 of file adodb-oci8.inc.php.

References Execute().

Referenced by RowLock(), UpdateBlob(), and UpdateBlobFile().

ADODB_oci8::CommitTrans ( $ ok = true )

If database does not support transactions, always return true as data always commited

Parameters:

$ok

set to false to rollback transaction, true to commit

Returns:: true/false.

Reimplemented from ADOConnection.

Definition at line 405 of file adodb-oci8.inc.php.

References RollbackTrans().

Referenced by UpdateBlob(), and UpdateBlobFile().

ADODB_oci8::RollbackTrans ( )

If database does not support transactions, rollbacks always fail, so return false

Returns:: true/false.

Reimplemented from ADOConnection.

Definition at line 417 of file adodb-oci8.inc.php.

Referenced by CommitTrans().

ADODB_oci8::SelectDB ( $ dbName )

Choose a database to connect to. Many databases do not support this.

Parameters:

dbName

is the name of the database to select

Returns:: true or false

Reimplemented from ADOConnection.

Definition at line 428 of file adodb-oci8.inc.php.

ADODB_oci8::ErrorMsg ( )

Returns:: the last error message

Reimplemented from ADOConnection.

Definition at line 433 of file adodb-oci8.inc.php.

ADODB_oci8::ErrorNo ( )

Returns:: the last error number. Normally 0 means no error.

Reimplemented from ADOConnection.

Definition at line 448 of file adodb-oci8.inc.php.

& ADODB_oci8::SelectLimit	(	$	sql,
		$	nrows = `-1`,
		$	offset = `-1`,
		$	inputarr = `false`,
		$	secs2cache = `0`
	)

Will select, getting rows from $offset (1-based), for $nrows. This simulates the MySQL "select * from table limit $offset,$nrows" , and the PostgreSQL "select * from table limit $nrows offset $offset". Note that MySQL and PostgreSQL parameter ordering is the opposite of the other. eg. SelectLimit('select * from table',3); will return rows 1 to 3 (1-based) SelectLimit('select * from table',3,2); will return rows 3 to 5 (1-based)

Uses SELECT TOP for Microsoft databases (when $this->hasTop is set) BUG: Currently SelectLimit fails with $sql with LIMIT or TOP clause already set

Parameters:

	sql
	[offset]	is the row to start calculations from (1-based)
	[nrows]	is the number of rows to get
	[inputarr]	array of bind variables
	[secs2cache]	is a private parameter only used by jlim

Returns:: the recordset ($rs->databaseType == 'array')

Reimplemented from ADOConnection.

Reimplemented in ADODB_oci805.

Definition at line 559 of file adodb-oci8.inc.php.

References ADOConnection::$false, ADOConnection::CacheExecute(), Execute(), Prepare(), and ADOConnection::SelectLimit().

ADODB_oci8::UpdateBlob	(	$	table,
		$	column,
		$	val,
		$	where,
		$	blobtype = `'BLOB'`
	)

Usage: Store BLOBs and CLOBs

Example: to store $var in a blob

$conn->Execute('insert into TABLE (id,ablob) values(12,empty_blob())'); $conn->UpdateBlob('TABLE', 'ablob', $varHoldingBlob, 'ID=12', 'BLOB');

$blobtype supports 'BLOB' and 'CLOB', but you need to change to 'empty_clob()'.

to get length of LOB: select DBMS_LOB.GETLENGTH(ablob) from TABLE

If you are using CURSOR_SHARING = force, it appears this will case a segfault under oracle 8.1.7.0. Run: $db->Execute('ALTER SESSION SET CURSOR_SHARING=EXACT'); before UpdateBlob() then...

Reimplemented from ADOConnection.

Definition at line 674 of file adodb-oci8.inc.php.

References ADOConnection::_Execute(), BeginTrans(), CommitTrans(), Execute(), and ADOConnection::outp().

ADODB_oci8::UpdateBlobFile	(	$	table,
		$	column,
		$	val,
		$	where,
		$	blobtype = `'BLOB'`
	)

Usage: store file pointed to by $var in a blob

Reimplemented from ADOConnection.

Definition at line 708 of file adodb-oci8.inc.php.

References BeginTrans(), CommitTrans(), Execute(), and ADOConnection::outp().

& ADODB_oci8::Execute	(	$	sql,
		$	inputarr = `false`
	)

Execute SQL

Parameters:

	sql	SQL statement to execute, or possibly an array holding prepared statement ($sql[0] will hold sql text)
	[inputarr]	holds the input data to bind to. Null elements will be set to null.