## [System.Data] element index

### Package indexes

- System.Caching
- System.Collections
- System.Data.ActiveRecord
- System.Data.ActiveRecord.Relations
- System.Data.ActiveReecord.Scaffold.InputBuilder
- System.Data.ActiveRecord.Scaffold
- System.Data.Common
- System.Data.Common.Pgsql
- System.Data.Common.Mssql
- System.Data.Common.Mysql
- System.Data.Commom.Sqlite
- System.Data.Common.Oracle
- System.Data.Common.Sqlite
- System.Data.DataGateway
- System.Data.SqlMap.Configuration
- System.Data.SqlMap.Statements
- System.Data.SqlMap
- System.Exceptions
- System.I18N
- System
- System.IO
- System.Security
- System.Util
- System.Web.Services
- System.Web
- System.Web.UI.ActiveControls
- System.Web.UI
- System.Web.UI.WebControls.assets
- System.Web.UI.WebControls
- System.Xml

All elements
_
top

__construct
  TDbTransaction::__construct() in TDbTransaction.php
  Constructor.
__construct
  TDbDataReader::__construct() in TDbDataReader.php
  Constructor.
__construct
  TDbConnection::__construct() in TDbConnection.php
  Constructor.
__construct
  TDbCommand::__construct() in TDbCommand.php
  Constructor.
__sleep
  TDbCommand::__sleep() in TDbCommand.php
  Set the statement to null when serializing.
__sleep
  TDbConnection::__sleep() in TDbConnection.php
  Close the connection when serializing.

b
top

beginTransaction
  TDbConnection::beginTransaction() in TDbConnection.php
  Starts a transaction.
bindColumn
  TDbDataReader::bindColumn() in TDbDataReader.php
  Binds a column to a PHP variable.
bindParameter
  TDbCommand::bindParameter() in TDbCommand.php
  Binds a parameter to the SQL statement to be executed.
bindValue
  TDbCommand::bindValue() in TDbCommand.php
  Binds a value to a parameter.

c
top

cancel
  TDbCommand::cancel() in TDbCommand.php
  Cancels the execution of the SQL statement.
close
  TDbDataReader::close() in TDbDataReader.php
  Closes the reader.
close
  TDbConnection::close() in TDbConnection.php
  Closes the currently active DB connection.
commit
  TDbTransaction::commit() in TDbTransaction.php
  Commits a transaction.
createCommand
  TDbConnection::createCommand() in TDbConnection.php
  Creates a command for execution.
current
  TDbDataReader::current() in TDbDataReader.php
  Returns the current row.

e
top

DEFAULT_TRANSACTION_CLASS
  TDbConnection::DEFAULT_TRANSACTION_CLASS in TDbConnection.php
execute
  TDbCommand::execute() in TDbCommand.php
  Executes the SQL statement.

f
top

findConnectionByID
  TDataSourceConfig::findConnectionByID() in TDataSourceConfig.php
  Finds the database connection instance from the Application modules.

g
top

getActive
  TDbConnection::getActive() in TDbConnection.php
getActive
  TDbTransaction::getActive() in TDbTransaction.php
getAttribute
  TDbConnection::getAttribute() in TDbConnection.php
  Obtains a specific DB connection attribute information.
getAutoCommit
  TDbConnection::getAutoCommit() in TDbConnection.php
getAvailableDrivers
  TDbConnection::getAvailableDrivers() in TDbConnection.php
getCharset
  TDbConnection::getCharset() in TDbConnection.php
getClientVersion
  TDbConnection::getClientVersion() in TDbConnection.php
getColumnCase
  TDbConnection::getColumnCase() in TDbConnection.php
getColumnCount
  TDbDataReader::getColumnCount() in TDbDataReader.php
getConnection
  TDbTransaction::getConnection() in TDbTransaction.php
getConnection
  TDbCommand::getConnection() in TDbCommand.php
getConnectionClass
  TDataSourceConfig::getConnectionClass() in TDataSourceConfig.php
getConnectionID
  TDataSourceConfig::getConnectionID() in TDataSourceConfig.php
getConnectionStatus
  TDbConnection::getConnectionStatus() in TDbConnection.php
getConnectionString
  TDbConnection::getConnectionString() in TDbConnection.php
getCurrentTransaction
  TDbConnection::getCurrentTransaction() in TDbConnection.php
getDatabase
  TDataSourceConfig::getDatabase() in TDataSourceConfig.php
  Alias for getDbConnection().
getDbConnection
  TDataSourceConfig::getDbConnection() in TDataSourceConfig.php
  Gets the TDbConnection from another module if setConnectionID is supplied and valid. Otherwise, a connection of type given by setConnectionClass is created.
getDebugStatementText
  TDbCommand::getDebugStatementText() in TDbCommand.php
getDriverName
  TDbConnection::getDriverName() in TDbConnection.php
getIsClosed
  TDbDataReader::getIsClosed() in TDbDataReader.php
getLastInsertID
  TDbConnection::getLastInsertID() in TDbConnection.php
  Returns the ID of the last inserted row or sequence value.
getNullConversion
  TDbConnection::getNullConversion() in TDbConnection.php
getPassword
  TDbConnection::getPassword() in TDbConnection.php
getPdoInstance
  TDbConnection::getPdoInstance() in TDbConnection.php
getPdoStatement
  TDbCommand::getPdoStatement() in TDbCommand.php
getPersistent
  TDbConnection::getPersistent() in TDbConnection.php
getPrefetch
  TDbConnection::getPrefetch() in TDbConnection.php
getRowCount
  TDbDataReader::getRowCount() in TDbDataReader.php
getServerInfo
  TDbConnection::getServerInfo() in TDbConnection.php
getServerVersion
  TDbConnection::getServerVersion() in TDbConnection.php
getText
  TDbCommand::getText() in TDbCommand.php
getTimeout
  TDbConnection::getTimeout() in TDbConnection.php
getTransactionClass
  TDbConnection::getTransactionClass() in TDbConnection.php
getUsername
  TDbConnection::getUsername() in TDbConnection.php

i
top

init
  TDataSourceConfig::init() in TDataSourceConfig.php
  Initalize the database connection properties from attributes in <database> tag.

k
top

key
  TDbDataReader::key() in TDbDataReader.php
  Returns the index of the current row.

m
top

EmptyStringToNull
  TDbNullConversionMode::EmptyStringToNull in TDbConnection.php
  Empty string is converted to NULL

n
top

next
  TDbDataReader::next() in TDbDataReader.php
  Moves the internal pointer to the next row.
nextResult
  TDbDataReader::nextResult() in TDbDataReader.php
  Advances the reader to the next result when reading the results of a batch of statements.

o
top

LowerCase
  TDbColumnCaseMode::LowerCase in TDbConnection.php
  Column names are converted to lower case
open
  TDbConnection::open() in TDbConnection.php
  Opens DB connection if it is currently not

p
top

prepare
  TDbCommand::prepare() in TDbCommand.php
  Prepares the SQL statement to be executed.
UpperCase
  TDbColumnCaseMode::UpperCase in TDbConnection.php
  Column names are converted to upper case

q
top

query
  TDbCommand::query() in TDbCommand.php
  Executes the SQL statement and returns query result.
queryColumn
  TDbCommand::queryColumn() in TDbCommand.php
  Executes the SQL statement and returns the first column of the result.
queryRow
  TDbCommand::queryRow() in TDbCommand.php
  Executes the SQL statement and returns the first row of the result.
queryScalar
  TDbCommand::queryScalar() in TDbCommand.php
  Executes the SQL statement and returns the value of the first column in the first row of data.
quoteString
  TDbConnection::quoteString() in TDbConnection.php
  Quotes a string for use in a query.

r
top

Preserved
  TDbColumnCaseMode::Preserved in TDbConnection.php
  Column name cases are kept as is from the database
Preserved
  TDbNullConversionMode::Preserved in TDbConnection.php
  No conversion is performed for null and empty values.
read
  TDbDataReader::read() in TDbDataReader.php
  Advances the reader to the next row in a result set.
readAll
  TDbDataReader::readAll() in TDbDataReader.php
  Reads the whole result set into an array.
readColumn
  TDbDataReader::readColumn() in TDbDataReader.php
  Returns a single column from the next row of a result set.
readObject
  TDbDataReader::readObject() in TDbDataReader.php
  Returns a single column from the next row of a result set.
rewind
  TDbDataReader::rewind() in TDbDataReader.php
  Resets the iterator to the initial state.
rollback
  TDbTransaction::rollback() in TDbTransaction.php
  Rolls back a transaction.

s
top

setActive
  TDbConnection::setActive() in TDbConnection.php
  Open or close the DB connection.
setActive
  TDbTransaction::setActive() in TDbTransaction.php
setAttribute
  TDbConnection::setAttribute() in TDbConnection.php
  Sets an attribute on the database connection.
setAutoCommit
  TDbConnection::setAutoCommit() in TDbConnection.php
setCharset
  TDbConnection::setCharset() in TDbConnection.php
setColumnCase
  TDbConnection::setColumnCase() in TDbConnection.php
setConnectionCharset
  TDbConnection::setConnectionCharset() in TDbConnection.php
setConnectionClass
  TDataSourceConfig::setConnectionClass() in TDataSourceConfig.php
  The database connection class name to be created when getDbConnection
setConnectionID
  TDataSourceConfig::setConnectionID() in TDataSourceConfig.php
  The module ID of another TDataSourceConfig. The getDbConnection property of this configuration will equal to getDbConnection of the given TDataSourceConfig module.
setConnectionString
  TDbConnection::setConnectionString() in TDbConnection.php
setFetchMode
  TDbDataReader::setFetchMode() in TDbDataReader.php
setNullConversion
  TDbConnection::setNullConversion() in TDbConnection.php
setPassword
  TDbConnection::setPassword() in TDbConnection.php
setPersistent
  TDbConnection::setPersistent() in TDbConnection.php
setText
  TDbCommand::setText() in TDbCommand.php
  Specifies the SQL statement to be executed.
setTransactionClass
  TDbConnection::setTransactionClass() in TDbConnection.php
setUsername
  TDbConnection::setUsername() in TDbConnection.php

t
top

TDataSourceConfig.php
  TDataSourceConfig.php in TDataSourceConfig.php
TDbCommand.php
  TDbCommand.php in TDbCommand.php
TDbConnection.php
  TDbConnection.php in TDbConnection.php
TDbDataReader.php
  TDbDataReader.php in TDbDataReader.php
TDbTransaction.php
  TDbTransaction.php in TDbTransaction.php
TDataSourceConfig
  TDataSourceConfig in TDataSourceConfig.php
  TDataSourceConfig module class provides <module> configuration for database connections.
TDbColumnCaseMode
  TDbColumnCaseMode in TDbConnection.php
  TDbColumnCaseMode
TDbCommand
  TDbCommand in TDbCommand.php
  TDbCommand class.
TDbConnection
  TDbConnection in TDbConnection.php
  TDbConnection class
TDbDataReader
  TDbDataReader in TDbDataReader.php
  TDbDataReader class.
TDbNullConversionMode
  TDbNullConversionMode in TDbConnection.php
  TDbNullConversionMode
TDbTransaction
  TDbTransaction in TDbTransaction.php
  TDbTransaction class.

u
top

NullToEmptyString
  TDbNullConversionMode::NullToEmptyString in TDbConnection.php
  NULL is converted to empty string

v
top

valid
  TDbDataReader::valid() in TDbDataReader.php
  Returns whether there is a row of data at current position.