Solutions Open Source

Référence de la classe ADODB_oci8

Graphe d'héritage de ADODB_oci8:

[légende]

Graphe de collaboration de ADODB_oci8:

[légende]

Liste de tous les membres

Fonctions membres publiques

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)

Attributs publics

$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()

Documentation des fonctions membres

ADODB_oci8::ADODB_oci8 ( )

& ADODB_oci8::MetaColumns ( $ table )

ADODB_oci8::Time ( )

Réimplémentée à partir de ADOConnection.

ADODB_oci8::_connect	(	$	argHostname,
		$	argUsername,
		$	argPassword,
		$	argDatabasename,
		$	mode = `0`
	)

ADODB_oci8::ServerInfo ( )

Get server version info...

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

Réimplémentée à partir de ADOConnection.

ADODB_oci8::_pconnect	(	$	argHostname,
		$	argUsername,
		$	argPassword,
		$	argDatabasename
	)

ADODB_oci8::_nconnect	(	$	argHostname,
		$	argUsername,
		$	argPassword,
		$	argDatabasename
	)

Réimplémentée à partir de ADOConnection.

ADODB_oci8::_affectedrows ( )

ADODB_oci8::IfNull	(	$	field,
		$	ifNull
	)

Réimplémentée à partir de ADOConnection.

ADODB_oci8::DBDate ( $ d )

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

Paramètres:

a date in Unix date time format.

Renvoie:: date string in database date format

Réimplémentée à partir de ADOConnection.

ADODB_oci8::BindDate ( $ d )

Réimplémentée à partir de ADOConnection.

ADODB_oci8::BindTimeStamp ( $ d )

Réimplémentée à partir de ADOConnection.

ADODB_oci8::DBTimeStamp ( $ ts )

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

Paramètres:

a timestamp in Unix date time format.

Renvoie:: timestamp string in database timestamp format

Réimplémentée à partir de ADOConnection.

ADODB_oci8::RowLock	(	$	tables,
		$	where,
		$	flds = `'1 as ignore'`
	)

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

Paramètres:

	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

Renvoie:: array of tables for current database.

Réimplémentée à partir de ADOConnection.

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

List indexes on a table as an array.

Paramètres:

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

Renvoie:: 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 ) )

Réimplémentée à partir de ADOConnection.

ADODB_oci8::BeginTrans ( )

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

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

Réimplémentée à partir de ADOConnection.

ADODB_oci8::CommitTrans ( $ ok = true )

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

Paramètres:

$ok

set to false to rollback transaction, true to commit

Renvoie:: true/false.

Réimplémentée à partir de ADOConnection.

ADODB_oci8::RollbackTrans ( )

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

Renvoie:: true/false.

Réimplémentée à partir de ADOConnection.

ADODB_oci8::SelectDB ( $ dbName )

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

Paramètres:

dbName

is the name of the database to select

Renvoie:: true or false

Réimplémentée à partir de ADOConnection.

ADODB_oci8::ErrorMsg ( )

Renvoie:: the last error message

Réimplémentée à partir de ADOConnection.

ADODB_oci8::ErrorNo ( )

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

Réimplémentée à partir de ADOConnection.

ADODB_oci8::SQLDate	(	$	fmt,
		$	col = `false`
	)

Réimplémentée à partir de ADOConnection.

& 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

Paramètres:

	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

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

Réimplémentée à partir de ADOConnection.

Réimplémentée dans ADODB_oci805.

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

Réimplémentée à partir de ADOConnection.

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

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

Réimplémentée à partir de ADOConnection.

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

Execute SQL

Paramètres:

	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.

Renvoie:: RecordSet or false

Réimplémentée à partir de ADOConnection.

ADODB_oci8::Prepare	(	$	sql,
		$	cursor = `false`
	)

Réimplémentée dans ADODB_oci8po.

& ADODB_oci8::ExecuteCursor	(	$	sql,
		$	cursorName = `'rs'`,
		$	params = `false`
	)

ADODB_oci8::Bind	(	&$	stmt,
		&$	var,
		$	size = `4000`,
		$	type = `false`,
		$	name = `false`,
		$	isOutput = `false`
	)

ADODB_oci8::Param	(	$	name,
		$	type = `false`
	)

Réimplémentée à partir de ADOConnection.

ADODB_oci8::Parameter	(	&$	stmt,
		&$	var,
		$	name,
		$	isOutput = `false`,
		$	maxLen = `4000`,
		$	type = `false`
	)

Réimplémentée à partir de ADOConnection.

ADODB_oci8::_query	(	$	sql,
		$	inputarr
	)

Réimplémentée dans ADODB_oci8po.

ADODB_oci8::_close ( )

ADODB_oci8::MetaPrimaryKeys	(	$	table,
		$	owner = `false`,
		$	internalKey = `false`
	)

ADODB_oci8::MetaForeignKeys	(	$	table,
		$	owner = `false`
	)

ADODB_oci8::CharMax ( )

ADODB_oci8::TextMax ( )

ADODB_oci8::qstr	(	$	s,
		$	magic_quotes = `false`
	)

Quotes a string. An example is $db->qstr("Don't bother",magic_quotes_runtime());

Paramètres:

	s	the string to quote
	[magic_quotes]	if $s is GET/POST var, set to get_magic_quotes_gpc(). This undoes the stupidity of magic quotes for GPC.

Renvoie:: quoted string to be sent back to database

Réimplémentée à partir de ADOConnection.

Documentation des données membres

ADODB_oci8::$databaseType = 'oci8'

Réimplémentée à partir de ADOConnection.

Réimplémentée dans ADODB_oci805, et ADODB_oci8po.

ADODB_oci8::$dataProvider = 'oci8'

Réimplémentée à partir de ADOConnection.

Réimplémentée dans ADODB_oci8po.

ADODB_oci8::$replaceQuote = "''"

string that represents FALSE for a database

Réimplémentée à partir de ADOConnection.

ADODB_oci8::$concat_operator = '||'

maximum size of blobs or large text fields (262144 = 256K)-- some db's die otherwise like foxpro

Réimplémentée à partir de ADOConnection.

ADODB_oci8::$sysDate = "TRUNC(SYSDATE)"

Use 'true' to store the item compressed (uses zlib).

Réimplémentée à partir de ADOConnection.

ADODB_oci8::$sysTimeStamp = 'SYSDATE'

name of function that returns the current date

Réimplémentée à partir de ADOConnection.

ADODB_oci8::$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

Réimplémentée à partir de ADOConnection.

ADODB_oci8::$_stmt

ADODB_oci8::$_commit = OCI_COMMIT_ON_SUCCESS

ADODB_oci8::$_initdate = true

ADODB_oci8::$metaTablesSQL = "select table_name,table_type from cat where table_type in ('TABLE','VIEW') and table_name not like 'BIN\$%'"

Réimplémentée à partir de ADOConnection.

Réimplémentée dans ADODB_oci8po.

ADODB_oci8::$metaColumnsSQL = "select cname,coltype,width, SCALE, PRECISION, NULLS, DEFAULTVAL from col where tname='%s' order by colno"

Réimplémentée dans ADODB_oci8po.

ADODB_oci8::$_bindInputArray = true

A boolean variable to state whether its a persistent connection or normal connection. */.

Réimplémentée à partir de ADOConnection.

ADODB_oci8::$hasGenID = true

has ability to run MoveFirst(), scrolling backwards

Réimplémentée à partir de ADOConnection.

ADODB_oci8::$_genIDSQL = "SELECT (%s.nextval) FROM DUAL"

ADODB_oci8::$_genSeqSQL = "CREATE SEQUENCE %s START WITH %s"

ADODB_oci8::$_dropSeqSQL = "DROP SEQUENCE %s"

ADODB_oci8::$hasAffectedRows = true

supports autoincrement ID?

Réimplémentée à partir de ADOConnection.

ADODB_oci8::$random = "abs(mod(DBMS_RANDOM.RANDOM,10000001)/10000000)"

string length ofperator

Réimplémentée à partir de ADOConnection.

ADODB_oci8::$noNullStrings = false

name of class used to generate array recordsets, which are pre-downloaded recordsets

Réimplémentée à partir de ADOConnection.

ADODB_oci8::$connectSID = false

Réimplémentée dans ADODB_oci805.

ADODB_oci8::$_bind = false

ADODB_oci8::$_nestedSQL = true

ADODB_oci8::$_hasOCIFetchStatement = false

ADODB_oci8::$_getarray = false

ADODB_oci8::$leftOuter = ''

indicates that all fields in order by must be unique

Réimplémentée à partir de ADOConnection.

ADODB_oci8::$session_sharing_force_blob = false

ADODB_oci8::$firstrows = true

ADODB_oci8::$selectOffsetAlg1 = 100

ADODB_oci8::$NLS_DATE_FORMAT = 'YYYY-MM-DD'

ADODB_oci8::$useDBDateFormatForTextInput = false

ADODB_oci8::$datetime = false

ADODB_oci8::$_refLOBs = array()

La documentation de cette classe a été générée à partir du fichier suivant :

Z:/doxygen/typo3_src-4.1.2/typo3/sysext/adodb/adodb/drivers/adodb-oci8.inc.php

Généré le Fri Aug 31 11:39:50 2007 pour OBLADY - Typo3 API v4.1.2 par

1.5.3


Fonctions membres publiques
	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)
Attributs publics
	$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()