[ Tutorial ] [ Oracle setup ] [ Class tree ] [ Element index ] [ ChangeLog ] [ Credits ]

Element index for package Database

[ a ] [ b ] [ c ] [ d ] [ e ] [ f ] [ g ] [ h ] [ i ] [ l ] [ m ] [ n ] [ o ] [ p ] [ q ] [ r ] [ s ] [ t ] [ u ] [ v ] [ w ] [ _ ]

_

__construct : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::__construct()
    Constructs a new ezcQuery object.

__construct : ezcQuerySelectOracle

in file query_select_oracle.php, method ezcQuerySelectOracle::__construct()
    Constructs a new ezcQueryOracle object working on the database $db.

__construct : ezcQueryInsert

in file query_insert.php, method ezcQueryInsert::__construct()
    Constructs a new ezcQueryInsert that works on the database $db and with the aliases $aliases.

__construct : ezcQueryException

in file query_exception.php, method ezcQueryException::__construct()
    Constructs an ezcQueryException with the highlevel error message $message and the errorcode $code.

__construct : ezcQueryDelete

in file query_delete.php, method ezcQueryDelete::__construct()
    Constructs a new ezcQueryDelete that works on the database $db and with the aliases $aliases.

__construct : ezcQuerySelectSqlite

in file query_select_sqlite.php, method ezcQuerySelectSqlite::__construct()
    Constructs a new ezcQuerySelectSqlite object.

__construct : ezcQuerySubSelect

in file query_subselect.php, method ezcQuerySubSelect::__construct()
    Constructs a new ezcQuery object.

__construct : ezcQueryVariableParameterException

in file variable_parameter.php, method ezcQueryVariableParameterException::__construct()
    Constructs an ezcQueryVariableParameterException with the method $method and the arguments $numProvided and $numExpected.

__construct : ezcDbTransactionException

in file transaction.php, method ezcDbTransactionException::__construct()
    Constructs a new exception with the message $msg.

__construct : ezcDbHandlerSqlite

in file sqlite.php, method ezcDbHandlerSqlite::__construct()
    Constructs a handler object from the parameters $dbParams.

__construct : ezcQueryUpdate

in file query_update.php, method ezcQueryUpdate::__construct()
    Constructs a new ezcQueryUpdate that works on the database $db and with the aliases $aliases.

__construct : ezcQuery

in file query.php, method ezcQuery::__construct()
    Constructs a new ezcQuery that works on the database $db and with the aliases $aliases.

__construct : ezcDbHandlerPgsql

in file pgsql.php, method ezcDbHandlerPgsql::__construct()
    Constructs a handler object from the parameters $dbParams.

__construct : ezcDbHandler

in file handler.php, method ezcDbHandler::__construct()
    Constructs a handler object.

__construct : ezcDbHandlerNotFoundException

in file handler_not_found.php, method ezcDbHandlerNotFoundException::__construct()
    Constructs a new exception.

__construct : ezcQueryExpressionPgsql

in file expression_pgsql.php, method ezcQueryExpressionPgsql::__construct()
    Constructs an pgsql expression object using the db $db.

__construct : ezcQueryExpressionOracle

in file expression_oracle.php, method ezcQueryExpressionOracle::__construct()
    Constructs an empty ezcQueryExpression

__construct : ezcQueryExpression

in file expression.php, method ezcQueryExpression::__construct()
    Constructs an empty ezcQueryExpression

__construct : ezcDbException

in file exception.php, method ezcDbException::__construct()
    Constructs an ezcDbAstractionException with the highlevel error message $message and the errorcode $code.

__construct : ezcDbMssqlOptions

in file identifiers.php, method ezcDbMssqlOptions::__construct()
    Creates an ezcDbMssqlOptions object with default option values.

__construct : ezcDbHandlerMysql

in file mysql.php, method ezcDbHandlerMysql::__construct()
    Constructs a handler object from the parameters $dbParams.

__construct : ezcDbHandlerOracle

in file oracle.php, method ezcDbHandlerOracle::__construct()
    Constructs a handler object from the parameters $dbParams.

__construct : ezcDbHandlerMssql

in file mssql.php, method ezcDbHandlerMssql::__construct()
    Constructs a handler object from the parameters $dbParams.

__construct : ezcDbMissingParameterException

in file missing_parameter.php, method ezcDbMissingParameterException::__construct()
    Constructs a new exception.

__construct : ezcQueryInvalidException

in file invalid.php, method ezcQueryInvalidException::__construct()
    Constructs a QueryInvalid exception with the type $type and the additional information $message.

__toString : ezcQuerySubSelect

in file query_subselect.php, method ezcQuerySubSelect::__toString()
    Return SQL string for subselect.

a

add : ezcQueryExpression

in file expression.php, method ezcQueryExpression::add()
    Returns the SQL to add values or expressions together.

addImplementation : ezcDbFactory

in file factory.php, method ezcDbFactory::addImplementation()
    Adds a database implementation to the list of known implementations.

alias : ezcQuerySelectOracle

in file query_select_oracle.php, method ezcQuerySelectOracle::alias()
    Returns SQL to create an alias.

alias : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::alias()
    Returns SQL to create an alias

arrayFlatten : ezcQuery

in file query.php, method ezcQuery::arrayFlatten()
    Returns all the elements in $array as one large single dimensional array.

avg : ezcQueryExpression

in file expression.php, method ezcQueryExpression::avg()
    Returns the average value of a column

b

beginTransaction : ezcDbHandler

in file handler.php, method ezcDbHandler::beginTransaction()
    Begins a transaction.

beginTransaction : ezcDbHandlerMssql

in file mssql.php, method ezcDbHandlerMssql::beginTransaction()
    Begins a transaction.

between : ezcQueryExpression

in file expression.php, method ezcQueryExpression::between()
    Returns SQL that checks if an expression evaluates to a value between two values.

bindParam : ezcQuerySubSelect

in file query_subselect.php, method ezcQuerySubSelect::bindParam()
    Binds the parameter $param to the specified variable name $placeHolder..

bindParam : ezcQuery

in file query.php, method ezcQuery::bindParam()
    Binds the parameter $param to the specified variable name $placeHolder..

bindValue : ezcQuerySubSelect

in file query_subselect.php, method ezcQuerySubSelect::bindValue()
    Binds the value $value to the specified variable name $placeHolder.

bindValue : ezcQuery

in file query.php, method ezcQuery::bindValue()
    Binds the value $value to the specified variable name $placeHolder.

bitAnd : ezcQueryExpressionOracle

in file expression_oracle.php, method ezcQueryExpressionOracle::bitAnd()
    Returns the SQL that performs the bitwise AND on two values.

bitAnd : ezcQueryExpression

in file expression.php, method ezcQueryExpression::bitAnd()
    Returns the SQL that performs the bitwise AND on two values.

bitOr : ezcQueryExpressionOracle

in file expression_oracle.php, method ezcQueryExpressionOracle::bitOr()
    Returns the SQL that performs the bitwise OR on two values.

bitOr : ezcQueryExpression

in file expression.php, method ezcQueryExpression::bitOr()
    Returns the SQL that performs the bitwise OR on two values.

bitXor : ezcQueryExpressionPgsql

in file expression_pgsql.php, method ezcQueryExpressionPgsql::bitXor()
    Returns the SQL that performs the bitwise XOR on two values.

bitXor : ezcQueryExpression

in file expression.php, method ezcQueryExpression::bitXor()
    Returns the SQL that performs the bitwise XOR on two values.

bitXor : ezcQueryExpressionOracle

in file expression_oracle.php, method ezcQueryExpressionOracle::bitXor()
    Returns the SQL that performs the bitwise XOR on two values.

bitXor : ezcQueryExpressionSqlite

in file expression_sqlite.php, method ezcQueryExpressionSqlite::bitXor()
    Returns the SQL that performs the bitwise XOR on two values.

c

ceil : ezcQueryExpressionMssql

in file expression_mssql.php, method ezcQueryExpressionMssql::ceil()
    Returns the SQL to calculate the next highest integer value from the number.

ceil : ezcQueryExpression

in file expression.php, method ezcQueryExpression::ceil()
    Returns the SQL to calculate the next highest integer value from the number.

ceilImpl : ezcQuerySqliteFunctions

in file query_sqlite_function_implementations.php, method ezcQuerySqliteFunctions::ceilImpl()
    Returns the next highest integer value from the number

chooseDefault : ezcDbInstance

in file instance.php, method ezcDbInstance::chooseDefault()
    Sets the database $identifier as default database instance.

commit : ezcDbHandlerMssql

in file mssql.php, method ezcDbHandlerMssql::commit()
    Commits a transaction.

commit : ezcDbHandler

in file handler.php, method ezcDbHandler::commit()
    Commits a transaction.

concat : ezcQueryExpressionPgsql

in file expression_pgsql.php, method ezcQueryExpressionPgsql::concat()
    Returns a series of strings concatinated

concat : ezcQueryExpressionOracle

in file expression_oracle.php, method ezcQueryExpressionOracle::concat()
    Returns a series of strings concatinated

concat : ezcQueryExpressionMssql

in file expression_mssql.php, method ezcQueryExpressionMssql::concat()
    Returns a series of strings concatinated

concat : ezcQueryExpression

in file expression.php, method ezcQueryExpression::concat()
    Returns a series of strings concatinated

concatImpl : ezcQuerySqliteFunctions

in file query_sqlite_function_implementations.php, method ezcQuerySqliteFunctions::concatImpl()
    Returns a concattenation of the data that SQLite's concat() function receives.

count : ezcQueryExpression

in file expression.php, method ezcQueryExpression::count()
    Returns the number of rows (without a NULL value) of a column

create : ezcDbFactory

in file factory.php, method ezcDbFactory::create()
    Creates and returns an instance of the specified ezcDbHandler implementation.

createDeleteQuery : ezcDbHandler

in file handler.php, method ezcDbHandler::createDeleteQuery()
    Returns a new ezcQueryDelete derived object for the correct database type.

createExpression : ezcDbHandlerPgsql

in file pgsql.php, method ezcDbHandlerPgsql::createExpression()
    Returns a new ezcQueryExpression derived object with PostgreSQL implementation specifics.

createExpression : ezcDbHandlerSqlite

in file sqlite.php, method ezcDbHandlerSqlite::createExpression()
    Returns a new ezcQueryExpression derived object with SQLite implementation specifics.

createExpression : ezcDbHandlerOracle

in file oracle.php, method ezcDbHandlerOracle::createExpression()
    Returns a new ezcQueryExpression derived object with Oracle implementation specifics.

createExpression : ezcDbHandler

in file handler.php, method ezcDbHandler::createExpression()
    Returns a new ezcQueryExpression derived object for the correct database type.

createExpression : ezcDbHandlerMssql

in file mssql.php, method ezcDbHandlerMssql::createExpression()
    Returns a new ezcQueryExpression derived object with SQL Server implementation specifics.

createInsertQuery : ezcDbHandler

in file handler.php, method ezcDbHandler::createInsertQuery()
    Returns a new ezcQueryInsert derived object for the correct database type.

createSelectQuery : ezcDbHandlerSqlite

in file sqlite.php, method ezcDbHandlerSqlite::createSelectQuery()
    Returns a new ezcQuerySelect derived object with SQLite implementation specifics.

createSelectQuery : ezcDbHandler

in file handler.php, method ezcDbHandler::createSelectQuery()
    Returns a new ezcQuerySelect derived object for the correct database type.

createSelectQuery : ezcDbHandlerMssql

in file mssql.php, method ezcDbHandlerMssql::createSelectQuery()
    Returns a new ezcQuerySelectMssql derived object with SQL Server implementation specifics.

createSelectQuery : ezcDbHandlerOracle

in file oracle.php, method ezcDbHandlerOracle::createSelectQuery()
    Returns a new ezcQuerySelect derived object with Oracle implementation specifics.

createUpdateQuery : ezcDbHandler

in file handler.php, method ezcDbHandler::createUpdateQuery()
    Returns a new ezcQueryUpdate derived object for the correct database type.

createUtilities : ezcDbHandlerSqlite

in file sqlite.php, method ezcDbHandlerSqlite::createUtilities()
    Returns a new ezcUtilities derived object with SQLite implementation specifics.

createUtilities : ezcDbHandler

in file handler.php, method ezcDbHandler::createUtilities()
    Returns a new ezcUtilities derived object for the correct database type.

createUtilities : ezcDbHandlerMysql

in file mysql.php, method ezcDbHandlerMysql::createUtilities()
    Returns a new ezcUtilities derived object for this database instance.

createUtilities : ezcDbHandlerOracle

in file oracle.php, method ezcDbHandlerOracle::createUtilities()
    Returns a new ezcUtilities derived object with Oracle implementation specifics.

createUtilities : ezcDbHandlerPgsql

in file pgsql.php, method ezcDbHandlerPgsql::createUtilities()
    Returns a new ezcUtilities derived object with PostgreSQL implementation specifics.

d

$db : ezcQuery

in file query.php, variable ezcQuery::$db
    A pointer to the database handler to use for this query.

$db : ezcQueryExpression

in file expression.php, variable ezcQueryExpression::$db
    A pointer to the database handler to use for this query.

dateAdd : ezcQueryExpressionSqlite

in file expression_sqlite.php, method ezcQueryExpressionSqlite::dateAdd()
    Returns the SQL that adds an interval to a timestamp value.

dateAdd : ezcQueryExpressionOracle

in file expression_oracle.php, method ezcQueryExpressionOracle::dateAdd()
    Returns the SQL that adds an interval to a timestamp value.

dateAdd : ezcQueryExpressionMssql

in file expression_mssql.php, method ezcQueryExpressionMssql::dateAdd()
    Returns the SQL that adds an interval to a timestamp value.

dateAdd : ezcQueryExpressionPgsql

in file expression_pgsql.php, method ezcQueryExpressionPgsql::dateAdd()
    Returns the SQL that adds an interval to a timestamp value.

dateAdd : ezcQueryExpression

in file expression.php, method ezcQueryExpression::dateAdd()
    Returns the SQL that adds an interval to a timestamp value.

dateExtract : ezcQueryExpressionPgsql

in file expression_pgsql.php, method ezcQueryExpressionPgsql::dateExtract()
    Returns the SQL that extracts parts from a timestamp value.

dateExtract : ezcQueryExpressionOracle

in file expression_oracle.php, method ezcQueryExpressionOracle::dateExtract()
    Returns the SQL that extracts parts from a timestamp value.

dateExtract : ezcQueryExpressionMssql

in file expression_mssql.php, method ezcQueryExpressionMssql::dateExtract()
    Returns the SQL that extracts parts from a timestamp value from a column.

dateExtract : ezcQueryExpressionSqlite

in file expression_sqlite.php, method ezcQueryExpressionSqlite::dateExtract()
    Returns the SQL that extracts parts from a timestamp value.

dateExtract : ezcQueryExpression

in file expression.php, method ezcQueryExpression::dateExtract()
    Returns the SQL that extracts parts from a timestamp value.

dateSub : ezcQueryExpressionSqlite

in file expression_sqlite.php, method ezcQueryExpressionSqlite::dateSub()
    Returns the SQL that subtracts an interval from a timestamp value.

dateSub : ezcQueryExpressionOracle

in file expression_oracle.php, method ezcQueryExpressionOracle::dateSub()
    Returns the SQL that subtracts an interval from a timestamp value.

dateSub : ezcQueryExpressionPgsql

in file expression_pgsql.php, method ezcQueryExpressionPgsql::dateSub()
    Returns the SQL that subtracts an interval from a timestamp value.

dateSub : ezcQueryExpression

in file expression.php, method ezcQueryExpression::dateSub()
    Returns the SQL that subtracts an interval from a timestamp value.

dateSub : ezcQueryExpressionMssql

in file expression_mssql.php, method ezcQueryExpressionMssql::dateSub()
    Returns the SQL that subtracts an interval from a timestamp value.

deleteFrom : ezcQueryDelete

in file query_delete.php, method ezcQueryDelete::deleteFrom()
    Opens the query and sets the target table to $table.

div : ezcQueryExpression

in file expression.php, method ezcQueryExpression::div()
    Returns the SQL to divide values or expressions by eachother.

doBind : ezcQuery

in file query.php, method ezcQuery::doBind()
    Performs binding of variables bound with bindValue and bindParam on the statement $stmt.

doJoin : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::doJoin()
    Returns the SQL for a join or prepares $fromString for a join.

e

$expr : ezcQuery

in file query.php, variable ezcQuery::$expr
    The expression object for this class.

exception.php

procedural page exception.php

expression.php

procedural page expression.php

expression_mssql.php

procedural page expression_mssql.php

expression_oracle.php

procedural page expression_oracle.php

expression_pgsql.php

procedural page expression_pgsql.php

expression_sqlite.php

procedural page expression_sqlite.php

DESC : ezcQuerySelect

in file query_select.php, class constant ezcQuerySelect::DESC
    Sort the result descending.

eq : ezcQueryExpression

in file expression.php, method ezcQueryExpression::eq()
    Returns the SQL to check if two values are equal.

ezcDbException

in file exception.php, class ezcDbException
    This class provides exception for misc errors that may occur in the component, such as errors parsing database parameters and connecting to the database.

ezcDbFactory

in file factory.php, class ezcDbFactory
    ezcDbFactory manages the list of known database drivers and is used to create their instances.

ezcDbHandler

in file handler.php, class ezcDbHandler
    Defines interface for all the database drivers implementations.

ezcDbHandlerMssql

in file mssql.php, class ezcDbHandlerMssql
    MS SQL Server driver implementation

ezcDbHandlerMysql

in file mysql.php, class ezcDbHandlerMysql
    MySQL driver implementation

ezcDbHandlerNotFoundException

in file handler_not_found.php, class ezcDbHandlerNotFoundException
    This exceptions is used when a database handler could not be found.

ezcDbHandlerOracle

in file oracle.php, class ezcDbHandlerOracle
    Oracle driver implementation

ezcDbHandlerPgsql

in file pgsql.php, class ezcDbHandlerPgsql
    PostgreSQL driver implementation

ezcDbHandlerSqlite

in file sqlite.php, class ezcDbHandlerSqlite
    SQLite driver implementation

ezcDbInstance

in file instance.php, class ezcDbInstance
    Holds database instances for global access throughout an application.

ezcDbMissingParameterException

in file missing_parameter.php, class ezcDbMissingParameterException
    This exception is thrown when a database handler misses a required parameter.

ezcDbMssqlOptions

in file identifiers.php, class ezcDbMssqlOptions
    Class containing the options for MS SQL Server connections

ezcDbTransactionException

in file transaction.php, class ezcDbTransactionException
    This class provides exception for misc errors that may occur in the component, such as errors parsing database parameters and connecting to the database.

ezcQuery

in file query.php, class ezcQuery
    The ezcQuery class provides the common API for all Query objects.

ezcQueryDelete

in file query_delete.php, class ezcQueryDelete
    Class to create select database independent DELETE queries.

ezcQueryException

in file query_exception.php, class ezcQueryException
    Base class for exceptions related to the SQL abstraction.

ezcQueryExpression

in file expression.php, class ezcQueryExpression
    The ezcQueryExpression class is used to create database independent SQL expression.

ezcQueryExpressionMssql

in file expression_mssql.php, class ezcQueryExpressionMssql
    The ezcQueryExpressionMssql class is used to create SQL expression for SQL Server.

ezcQueryExpressionOracle

in file expression_oracle.php, class ezcQueryExpressionOracle
    The ezcQueryExpressionOracle class is used to create SQL expression for Oracle.

ezcQueryExpressionPgsql

in file expression_pgsql.php, class ezcQueryExpressionPgsql
    The ezcQueryExpressionPgsql class is used to create SQL expression for PostgreSQL.

ezcQueryExpressionSqlite

in file expression_sqlite.php, class ezcQueryExpressionSqlite
    The ezcQueryExpressionSqlite class is used to create SQL expression for SQLite.

ezcQueryInsert

in file query_insert.php, class ezcQueryInsert
    Class to create select database independent INSERT queries.

ezcQueryInvalidException

in file invalid.php, class ezcQueryInvalidException
    Base class for exceptions related to the SQL abstraction.

ezcQuerySelect

in file query_select.php, class ezcQuerySelect
    Class to create select database independent SELECT queries.

ezcQuerySelectMssql

in file query_select_mssql.php, class ezcQuerySelectMssql
    SQL Server specific implementation of ezcQuery.

ezcQuerySelectOracle

in file query_select_oracle.php, class ezcQuerySelectOracle
    Oracle specific implementation of ezcQuery.

ezcQuerySelectSqlite

in file query_select_sqlite.php, class ezcQuerySelectSqlite
    SQLite specific implementation of ezcQuery.

ezcQuerySqliteFunctions

in file query_sqlite_function_implementations.php, class ezcQuerySqliteFunctions
    The ezcQueryExpressionSqlite class is used to create SQL expression for SQLite.

ezcQuerySubSelect

in file query_subselect.php, class ezcQuerySubSelect
    Class to create subselects within queries.

ezcQueryUpdate

in file query_update.php, class ezcQueryUpdate
    Class to create select database independent UPDATE queries.

ezcQueryVariableParameterException

in file variable_parameter.php, class ezcQueryVariableParameterException
    Exception thrown when a method does not receive the variables it requires.

f

$fromString : ezcQuerySelect

in file query_select.php, variable ezcQuerySelect::$fromString
    Stores the FROM part of the SQL.

$fromTables : ezcQuerySelectSqlite

in file query_select_sqlite.php, variable ezcQuerySelectSqlite::$fromTables
    Store tables that appear in FROM clause.

factory.php

procedural page factory.php

floor : ezcQueryExpression

in file expression.php, method ezcQueryExpression::floor()
    Returns the SQL to calculate the next lowest integer value from the number.

floorImpl : ezcQuerySqliteFunctions

in file query_sqlite_function_implementations.php, method ezcQuerySqliteFunctions::floorImpl()
    Returns the next lowest integer value from the number

from : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::from()
    Select which tables you want to select from.

from : ezcQuerySelectSqlite

in file query_select_sqlite.php, method ezcQuerySelectSqlite::from()
    Select which tables you want to select from.

g

$groupString : ezcQuerySelect

in file query_select.php, variable ezcQuerySelect::$groupString
    Stores the GROUP BY part of the SQL.

get : ezcDbInstance

in file instance.php, method ezcDbInstance::get()
    Returns the database instance $identifier.

getDummyTableName : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::getDummyTableName()
    Returns dummy table name.

getDummyTableName : ezcQuerySelectOracle

in file query_select_oracle.php, method ezcQuerySelectOracle::getDummyTableName()
    Returns dummy table name 'dual'.

getIdentifier : ezcQueryExpression

in file expression.php, method ezcQueryExpression::getIdentifier()
    Returns the correct identifier for the alias $alias.

getIdentifier : ezcQuery

in file query.php, method ezcQuery::getIdentifier()
    Returns the correct identifier for the alias $alias.

getIdentifiers : ezcQuery

in file query.php, method ezcQuery::getIdentifiers()
    Returns the correct identifiers for the aliases found in $aliases.

getIdentifiers : ezcQueryExpression

in file expression.php, method ezcQueryExpression::getIdentifiers()
    Returns the correct identifiers for the aliases found in $aliases.

getIdentifiers : ezcDbInstance

in file instance.php, method ezcDbInstance::getIdentifiers()
    Returns the identifiers of the registered database instances.

getImplementations : ezcDbFactory

in file factory.php, method ezcDbFactory::getImplementations()
    Returns a list with supported database implementations.

getName : ezcDbHandlerSqlite

in file sqlite.php, method ezcDbHandlerSqlite::getName()
    Returns 'sqlite'.

getName : ezcDbHandlerPgsql

in file pgsql.php, method ezcDbHandlerPgsql::getName()
    Returns 'pgsql'.

getName : ezcDbHandlerMysql

in file mysql.php, method ezcDbHandlerMysql::getName()
    Returns 'mysql'.

getName : ezcDbHandlerOracle

in file oracle.php, method ezcDbHandlerOracle::getName()
    Returns 'oracle'.

getName : ezcDbHandlerMssql

in file mssql.php, method ezcDbHandlerMssql::getName()
    Returns 'mssql'.

getQuery : ezcQuerySelectOracle

in file query_select_oracle.php, method ezcQuerySelectOracle::getQuery()
    Transforms the query from the parent to provide LIMIT functionality.

getQuery : ezcQuerySubSelect

in file query_subselect.php, method ezcQuerySubSelect::getQuery()
    Return string with SQL query for subselect.

getQuery : ezcQuerySelectMssql

in file query_select_mssql.php, method ezcQuerySelectMssql::getQuery()
    Transforms the query from the parent to provide LIMIT functionality.

getQuery : ezcQueryUpdate

in file query_update.php, method ezcQueryUpdate::getQuery()
    Returns the query string for this query object.

getQuery : ezcQueryInsert

in file query_insert.php, method ezcQueryInsert::getQuery()
    Returns the query string for this query object.

getQuery : ezcQueryDelete

in file query_delete.php, method ezcQueryDelete::getQuery()
    Returns the query string for this query object.

getQuery : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::getQuery()
    Returns the complete select query string.

getQuery : ezcQuery

in file query.php, method ezcQuery::getQuery()
    Returns the query string for this query object.

groupBy : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::groupBy()
    Returns SQL that groups the result set by a given column.

gt : ezcQueryExpression

in file expression.php, method ezcQueryExpression::gt()
    Returns the SQL to check if one value is greater than another value.

gte : ezcQueryExpression

in file expression.php, method ezcQueryExpression::gte()
    Returns the SQL to check if one value is greater than or equal to another value.

h

$havingString : ezcQuerySelect

in file query_select.php, variable ezcQuerySelect::$havingString
    Stores the HAVING part of SQL

handler_not_found.php

procedural page handler_not_found.php

handler.php

procedural page handler.php

hasAliases : ezcQuery

in file query.php, method ezcQuery::hasAliases()
    Returns true if this object has aliases.

hasAliases : ezcQueryExpression

in file expression.php, method ezcQueryExpression::hasAliases()
    Returns true if this object has aliases.

having : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::having()
    Returns SQL that set having by a given expression.

i

$identifierQuoteChars : ezcDbHandlerMysql

in file mysql.php, variable ezcDbHandlerMysql::$identifierQuoteChars
    Characters to quote identifiers with. Should be overwritten in handler implementation, if different for a specific handler. In some cases the quoting start and end characters differ (e.g. ODBC), but mostly they are the same.

$identifierQuoteChars : ezcDbHandler

in file handler.php, variable ezcDbHandler::$identifierQuoteChars
    Characters to quote identifiers with. Should be overwritten in handler implementation, if different for a specific handler. In some cases the quoting start and end characters differ (e.g. ODBC), but mostly they are the same.

$intervalMap : ezcQueryExpression

in file expression.php, variable ezcQueryExpression::$intervalMap
    Contains an interval map from generic intervals to MySQL native intervals.

$intervalMap : ezcQueryExpressionMssql

in file expression_mssql.php, variable ezcQueryExpressionMssql::$intervalMap
    Contains an interval map from generic intervals to MS SQL native intervals.

$intervalMap : ezcQueryExpressionSqlite

in file expression_sqlite.php, variable ezcQueryExpressionSqlite::$intervalMap
    Contains an interval map from generic intervals to SQLite native intervals.

invalid.php

procedural page invalid.php

instance.php

procedural page instance.php

identifiers.php

procedural page identifiers.php

in : ezcQueryExpressionOracle

in file expression_oracle.php, method ezcQueryExpressionOracle::in()
    Returns the SQL to check if a value is one in a set of given values..

in : ezcQueryExpression

in file expression.php, method ezcQueryExpression::in()
    Returns the SQL to check if a value is one in a set of given values..

innerJoin : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::innerJoin()
    Returns the SQL for an inner join or prepares $fromString for an inner join.

insertInto : ezcQueryInsert

in file query_insert.php, method ezcQueryInsert::insertInto()
    Opens the query and sets the target table to $table.

isNull : ezcQueryExpression

in file expression.php, method ezcQueryExpression::isNull()
    Returns SQL that checks if a expression is null.

l

$lastInvokedMethod : ezcQuerySelect

in file query_select.php, variable ezcQuerySelect::$lastInvokedMethod
    Stores the name of last invoked SQL clause method.

$limitString : ezcQuerySelect

in file query_select.php, variable ezcQuerySelect::$limitString
    Stores the LIMIT part of the SQL.

lAnd : ezcQueryExpression

in file expression.php, method ezcQueryExpression::lAnd()
    Returns the SQL to bind logical expressions together using a logical and.

leftJoin : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::leftJoin()
    Returns the SQL for a left join or prepares $fromString for a left join.

length : ezcQueryExpression

in file expression.php, method ezcQueryExpression::length()
    Returns the length of text field $column

length : ezcQueryExpressionMssql

in file expression_mssql.php, method ezcQueryExpressionMssql::length()
    Returns the length of a text field.

like : ezcQueryExpression

in file expression.php, method ezcQueryExpression::like()
    Match a partial string in a column.

limit : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::limit()
    Returns SQL that limits the result set.

limit : ezcQuerySelectOracle

in file query_select_oracle.php, method ezcQuerySelectOracle::limit()
    Returns SQL that limits the result set.

limit : ezcQuerySelectMssql

in file query_select_mssql.php, method ezcQuerySelectMssql::limit()
    Returns SQL that limits the result set.

lOr : ezcQueryExpression

in file expression.php, method ezcQueryExpression::lOr()
    Returns the SQL to bind logical expressions together using a logical or.

lower : ezcQueryExpression

in file expression.php, method ezcQueryExpression::lower()
    Returns the SQL to change all characters to lowercase

lt : ezcQueryExpression

in file expression.php, method ezcQueryExpression::lt()
    Returns the SQL to check if one value is less than another value.

lte : ezcQueryExpression

in file expression.php, method ezcQueryExpression::lte()
    Returns the SQL to check if one value is less than or equal to another value.

m

missing_parameter.php

procedural page missing_parameter.php

mssql.php

procedural page mssql.php

mysql.php

procedural page mysql.php

max : ezcQueryExpression

in file expression.php, method ezcQueryExpression::max()
    Returns the highest value of a column

md5 : ezcQueryExpressionPgsql

in file expression_pgsql.php, method ezcQueryExpressionPgsql::md5()
    Returns the md5 sum of the field $column.

md5 : ezcQueryExpression

in file expression.php, method ezcQueryExpression::md5()
    Returns the md5 sum of $column.

md5 : ezcQueryExpressionMssql

in file expression_mssql.php, method ezcQueryExpressionMssql::md5()
    Returns the md5 sum of a field.

md5Impl : ezcQuerySqliteFunctions

in file query_sqlite_function_implementations.php, method ezcQuerySqliteFunctions::md5Impl()
    Returns the md5 sum of the data that SQLite's md5() function receives.

min : ezcQueryExpression

in file expression.php, method ezcQueryExpression::min()
    Returns the lowest value of a column

mod : ezcQueryExpressionMssql

in file expression_mssql.php, method ezcQueryExpressionMssql::mod()
    Returns the remainder of the division operation $expression1 / $expression2.

mod : ezcQueryExpression

in file expression.php, method ezcQueryExpression::mod()
    Returns the remainder of the division operation $expression1 / $expression2.

modImpl : ezcQuerySqliteFunctions

in file query_sqlite_function_implementations.php, method ezcQuerySqliteFunctions::modImpl()
    Returns the modules of the data that SQLite's mod() function receives.

mul : ezcQueryExpression

in file expression.php, method ezcQueryExpression::mul()
    Returns the SQL to multiply values or expressions by eachother.

n

neq : ezcQueryExpression

in file expression.php, method ezcQueryExpression::neq()
    Returns the SQL to check if two values are unequal.

not : ezcQueryExpression

in file expression.php, method ezcQueryExpression::not()
    Returns the SQL for a logical not, negating the $expression.

now : ezcQueryExpressionPgsql

in file expression_pgsql.php, method ezcQueryExpressionPgsql::now()
    Returns the current system date and time.

now : ezcQueryExpressionSqlite

in file expression_sqlite.php, method ezcQueryExpressionSqlite::now()
    Returns the current system date and time.

now : ezcQueryExpressionMssql

in file expression_mssql.php, method ezcQueryExpressionMssql::now()
    Returns the current system date.

now : ezcQueryExpression

in file expression.php, method ezcQueryExpression::now()
    Returns the current system date and time.

now : ezcQueryExpressionOracle

in file expression_oracle.php, method ezcQueryExpressionOracle::now()
    Returns the current system date and time.

o

$options : ezcDbHandlerMssql

in file mssql.php, variable ezcDbHandlerMssql::$options
    Contains the options that are used to set up handler.

$orderString : ezcQuerySelect

in file query_select.php, variable ezcQuerySelect::$orderString
    Stores the ORDER BY part of the SQL.

$outerQuery : ezcQuerySubSelect

in file query_subselect.php, variable ezcQuerySubSelect::$outerQuery
    Holds the outer query.

oracle.php

procedural page oracle.php

orderBy : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::orderBy()
    Returns SQL that orders the result set by a given column.

orderBy : ezcQuerySelectMssql

in file query_select_mssql.php, method ezcQuerySelectMssql::orderBy()
    Saves the ordered columns in an internal array so we can invert that order if we need to in the limit() workaround

p

pgsql.php

procedural page pgsql.php

parseDSN : ezcDbFactory

in file factory.php, method ezcDbFactory::parseDSN()
    Returns the Data Source Name as a structure containing the various parts of the DSN.

position : ezcQueryExpressionMssql

in file expression_mssql.php, method ezcQueryExpressionMssql::position()
    Returns the SQL to locate the position of the first occurrence of a substring

position : ezcQueryExpression

in file expression.php, method ezcQueryExpression::position()
    Returns the SQL to locate the position of the first occurrence of a substring

position : ezcQueryExpressionOracle

in file expression_oracle.php, method ezcQueryExpressionOracle::position()
    Returns the SQL to locate the position of the first occurrence of a substring

position : ezcQueryExpressionPgsql

in file expression_pgsql.php, method ezcQueryExpressionPgsql::position()
    Returns the SQL to locate the position of the first occurrence of a substring

positionImpl : ezcQuerySqliteFunctions

in file query_sqlite_function_implementations.php, method ezcQuerySqliteFunctions::positionImpl()
    Returns the SQL to locate the position of the first occurrence of a substring

prepare : ezcQuerySelectOracle

in file query_select_oracle.php, method ezcQuerySelectOracle::prepare()
    Handles preparing query.

prepare : ezcQuery

in file query.php, method ezcQuery::prepare()
    Returns a prepared statement from this query which can be used for execution.

processLimitOffset : ezcDbHandlerOracle

in file oracle.php, method ezcDbHandlerOracle::processLimitOffset()
    Returns an SQL query with LIMIT/OFFSET functionality appended.

q

$quoteValues : ezcQueryExpression

in file expression.php, variable ezcQueryExpression::$quoteValues
    The flag that switch quoting mode for values provided by user in miscelaneous SQL functions.

query_exception.php

procedural page query_exception.php

query_select_mssql.php

procedural page query_select_mssql.php

query_select_oracle.php

procedural page query_select_oracle.php

query_select_sqlite.php

procedural page query_select_sqlite.php

query_sqlite_function_implementations.php

procedural page query_sqlite_function_implementations.php

query.php

procedural page query.php

query_delete.php

procedural page query_delete.php

query_insert.php

procedural page query_insert.php

query_select.php

procedural page query_select.php

query_subselect.php

procedural page query_subselect.php

query_update.php

procedural page query_update.php

quote : ezcDbHandlerOracle

in file oracle.php, method ezcDbHandlerOracle::quote()
    Returns $str quoted for the Oracle database.

quoteIdentifier : ezcDbHandler

in file handler.php, method ezcDbHandler::quoteIdentifier()
    Returns the quoted version of an identifier to be used in an SQL query.

r

$rightJoins : ezcQuerySelectSqlite

in file query_select_sqlite.php, variable ezcQuerySelectSqlite::$rightJoins
    Store info for building emulation of right joins in FROM clause.

reset : ezcQuerySelectOracle

in file query_select_oracle.php, method ezcQuerySelectOracle::reset()
    Resets the query object for reuse.

reset : ezcQuerySelectSqlite

in file query_select_sqlite.php, method ezcQuerySelectSqlite::reset()
    Resets the query object for reuse.

reset : ezcQuerySelectMssql

in file query_select_mssql.php, method ezcQuerySelectMssql::reset()
    Resets the query object for reuse.

reset : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::reset()
    Resets the query object for reuse.

reset : ezcDbInstance

in file instance.php, method ezcDbInstance::reset()
    Resets this object to its initial state.

resetBinds : ezcQuery

in file query.php, method ezcQuery::resetBinds()
    Resets the bound values and parameters to empty.

resetDefault : ezcDbInstance

in file instance.php, method ezcDbInstance::resetDefault()
    Resets the default instance holder.

rightJoin : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::rightJoin()
    Returns the SQL for a right join or prepares $fromString for a right join.

rightJoin : ezcQuerySelectSqlite

in file query_select_sqlite.php, method ezcQuerySelectSqlite::rightJoin()
    Returns the SQL for a right join or prepares $fromString for a right join.

rollback : ezcDbHandler

in file handler.php, method ezcDbHandler::rollback()
    Rollback a transaction.

rollback : ezcDbHandlerMssql

in file mssql.php, method ezcDbHandlerMssql::rollback()
    Rollback a transaction.

round : ezcQueryExpression

in file expression.php, method ezcQueryExpression::round()
    Rounds a numeric field to the number of decimals specified.

s

$selectString : ezcQuerySelect

in file query_select.php, variable ezcQuerySelect::$selectString
    Stores the SELECT part of the SQL.

ASC : ezcQuerySelect

in file query_select.php, class constant ezcQuerySelect::ASC
    Sort the result ascending.

sqlite.php

procedural page sqlite.php

searchedCase : ezcQueryExpression

in file expression.php, method ezcQueryExpression::searchedCase()
    Returns a searched CASE statement.

select : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::select()
    Opens the query and selects which columns you want to return with the query.

selectDistinct : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::selectDistinct()
    Opens the query and uses a distinct select on the columns you want to return with the query.

set : ezcQueryInsert

in file query_insert.php, method ezcQueryInsert::set()
    The insert query will set the column $column to the value $expression.

set : ezcQueryUpdate

in file query_update.php, method ezcQueryUpdate::set()
    The update query will set the column $column to the value $expression.

set : ezcDbInstance

in file instance.php, method ezcDbInstance::set()
    Adds the database handler $db to the list of known instances.

setAliases : ezcQueryExpression

in file expression.php, method ezcQueryExpression::setAliases()
    Sets the aliases $aliases for this object.

setAliases : ezcQuery

in file query.php, method ezcQuery::setAliases()
    Sets the aliases $aliases for this object.

setOptions : ezcDbHandlerMssql

in file mssql.php, method ezcDbHandlerMssql::setOptions()
    Associates an option object with this handler and changes settings for opened connactions correspondently.

setValuesQuoting : ezcQueryExpression

in file expression.php, method ezcQueryExpression::setValuesQuoting()
    Sets the mode of quoting for parameters passed to SQL functions and operators.

sub : ezcQueryExpression

in file expression.php, method ezcQueryExpression::sub()
    Returns the SQL to subtract values or expressions from eachother.

subSelect : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::subSelect()
    Returns the ezcQuerySubSelect query object.

subSelect : ezcQuerySubSelect

in file query_subselect.php, method ezcQuerySubSelect::subSelect()
    Returns ezcQuerySubSelect of deeper level.

subString : ezcQueryExpressionMssql

in file expression_mssql.php, method ezcQueryExpressionMssql::subString()
    Returns part of a string.

subString : ezcQueryExpressionPgsql

in file expression_pgsql.php, method ezcQueryExpressionPgsql::subString()
    Returns part of a string.

subString : ezcQueryExpressionOracle

in file expression_oracle.php, method ezcQueryExpressionOracle::subString()
    Returns part of a string.

subString : ezcQueryExpressionSqlite

in file expression_sqlite.php, method ezcQueryExpressionSqlite::subString()
    Returns part of a string.

subString : ezcQueryExpression

in file expression.php, method ezcQueryExpression::subString()
    Returns part of a string.

sum : ezcQueryExpression

in file expression.php, method ezcQueryExpression::sum()
    Returns the total sum of a column

t

$transactionErrorFlag : ezcDbHandler

in file handler.php, variable ezcDbHandler::$transactionErrorFlag
    This flag is set to true when an SQL query has failed.

$transactionNestingLevel : ezcDbHandler

in file handler.php, variable ezcDbHandler::$transactionNestingLevel
    Stores the transaction nesting level.

transaction.php

procedural page transaction.php

toUnixTimestampImpl : ezcQuerySqliteFunctions

in file query_sqlite_function_implementations.php, method ezcQuerySqliteFunctions::toUnixTimestampImpl()
    Returns the unix timestamp belonging to a date/time spec

u

QUOTES_COMPLIANT : ezcDbMssqlOptions

in file identifiers.php, class constant ezcDbMssqlOptions::QUOTES_COMPLIANT
    Constant represents mode of identifiers quoting that compliant to SQL92.

QUOTES_GUESS : ezcDbMssqlOptions

in file identifiers.php, class constant ezcDbMssqlOptions::QUOTES_GUESS
    Recommended ( and default ) mode for identifiers quoting.

QUOTES_LEGACY : ezcDbMssqlOptions

in file identifiers.php, class constant ezcDbMssqlOptions::QUOTES_LEGACY
    Constant represents mode of identifiers quoting that corresponds to QUOTE_IDENTIFIERS OFF for MS SQL Server connection.

QUOTES_UNTOUCHED : ezcDbMssqlOptions

in file identifiers.php, class constant ezcDbMssqlOptions::QUOTES_UNTOUCHED
    Constant represents mode of identifiers quoting that not touch any settings related to quoting identifiers.

unixTimestamp : ezcQueryExpression

in file expression.php, method ezcQueryExpression::unixTimestamp()
    Returns the SQL that converts a timestamp value to a unix timestamp.

unixTimestamp : ezcQueryExpressionSqlite

in file expression_sqlite.php, method ezcQueryExpressionSqlite::unixTimestamp()
    Returns the SQL that converts a timestamp value to a unix timestamp.

unixTimestamp : ezcQueryExpressionPgsql

in file expression_pgsql.php, method ezcQueryExpressionPgsql::unixTimestamp()
    Returns the SQL that converts a timestamp value to a unix timestamp.

unixTimestamp : ezcQueryExpressionMssql

in file expression_mssql.php, method ezcQueryExpressionMssql::unixTimestamp()
    Returns the SQL that converts a timestamp value to number of seconds since 1970-01-01 00:00:00-00.

unixTimestamp : ezcQueryExpressionOracle

in file expression_oracle.php, method ezcQueryExpressionOracle::unixTimestamp()
    Returns the SQL that converts a timestamp value to a unix timestamp.

update : ezcQueryUpdate

in file query_update.php, method ezcQueryUpdate::update()
    Opens the query and sets the target table to $table.

upper : ezcQueryExpression

in file expression.php, method ezcQueryExpression::upper()
    Returns the SQL to change all characters to uppercase

v

$values : ezcQueryInsert

in file query_insert.php, variable ezcQueryInsert::$values
    Holds the columns and the values that should inserted into the the table.

variable_parameter.php

procedural page variable_parameter.php

w

$whereString : ezcQueryUpdate

in file query_update.php, variable ezcQueryUpdate::$whereString
    Stores the WHERE part of the SQL.

$whereString : ezcQueryDelete

in file query_delete.php, variable ezcQueryDelete::$whereString
    Stores the WHERE part of the SQL.

$whereString : ezcQuerySelect

in file query_select.php, variable ezcQuerySelect::$whereString
    Stores the WHERE part of the SQL.

where : ezcQueryUpdate

in file query_update.php, method ezcQueryUpdate::where()
    Adds a where clause with logical expressions to the query.

where : ezcQueryDelete

in file query_delete.php, method ezcQueryDelete::where()
    Adds a where clause with logical expressions to the query.

where : ezcQuerySelect

in file query_select.php, method ezcQuerySelect::where()
    Adds a where clause with logical expressions to the query.