Path

ez components / documentation / api reference / 1.1 / database


eZ Components 1.1

Database

[ Tutorial ] [ 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 : ezcQuerySelectOracle
in file query_select_oracle.php, method ezcQuerySelectOracle::__construct()
    Constructs a new ezcQueryOracle object.
__construct : ezcQuerySelect
in file query_select.php, method ezcQuerySelect::__construct()
    Constructs a new ezcQuery object.
__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 : 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 a QueryInvalid exception with the type $type and the additional information $message.
__construct : ezcDbTransactionException
in file transaction.php, method ezcDbTransactionException::__construct()
    Constructs a new exception.
__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 : 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 : ezcQuery
in file query.php, method ezcQuery::__construct()
    Constructs a new ezcQuery that works on the database $db and with the aliases $aliases.
__construct : ezcDbHandler
in file handler.php, method ezcDbHandler::__construct()
    Constructs a handler object.
__construct : ezcQueryExpressionPgsql
in file expression_pgsql.php, method ezcQueryExpressionPgsql::__construct()
    Constructs an empty ezcQueryExpression with the versoin $version.
__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 : ezcDbHandlerNotFoundException
in file handler_not_found.php, method ezcDbHandlerNotFoundException::__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.
__construct : ezcDbHandlerOracle
in file oracle.php, method ezcDbHandlerOracle::__construct()
    Constructs a handler object from the parameters $dbParams.
__construct : ezcDbHandlerPgsql
in file pgsql.php, method ezcDbHandlerPgsql::__construct()
    Constructs a handler object from the parameters $dbParams.
__construct : ezcDbHandlerMysql
in file mysql.php, method ezcDbHandlerMysql::__construct()
    Constructs a handler object from the parameters $dbParams.
__construct : ezcDbMissingParameterException
in file missing_parameter.php, method ezcDbMissingParameterException::__construct()
    Constructs a new exception.
__construct : ezcDbException
in file exception.php, method ezcDbException::__construct()
    Constructs an ezcDbAstractionException with the highlevel error message $message and the errorcode $code.
__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.
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.

c

chooseDefault : ezcDbInstance
in file instance.php, method ezcDbInstance::chooseDefault()
    Sets the database $identifier as default database instance.
commit : ezcDbHandler
in file handler.php, method ezcDbHandler::commit()
    Commits a transaction.
concat : ezcQueryExpressionOracle
in file expression_oracle.php, method ezcQueryExpressionOracle::concat()
    Returns a series of strings concatinated
concat : ezcQueryExpressionPgsql
in file expression_pgsql.php, method ezcQueryExpressionPgsql::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 : ezcDbHandlerOracle
in file oracle.php, method ezcDbHandlerOracle::createExpression()
    Returns a new ezcQueryExpression derived object with Oracle implementation specifics.
createExpression : ezcDbHandlerPgsql
in file pgsql.php, method ezcDbHandlerPgsql::createExpression()
    Returns a new ezcQueryExpression derived object with PostgreSQL implementation specifics.
createExpression : ezcDbHandler
in file handler.php, method ezcDbHandler::createExpression()
    Returns a new ezcQueryExpression derived object for the correct database type.
createExpression : ezcDbHandlerSqlite
in file sqlite.php, method ezcDbHandlerSqlite::createExpression()
    Returns a new ezcQueryExpression derived object with SQLite 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 : 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.
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.

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_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 descendingly.
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.
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.
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.
ezcQueryExpressionOracle
in file expression_oracle.php, class ezcQueryExpressionOracle
    The ezcQueryExpressionPgsql class is used to create SQL expression for PostgreSQL.
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.
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
    Base class for exceptions related to the SQL abstraction.

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
from : ezcQuerySelectSqlite
in file query_select_sqlite.php, method ezcQuerySelectSqlite::from()
    Select which tables you want to select from.
from : ezcQuerySelect
in file query_select.php, method ezcQuerySelect::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 : ezcQuerySelectOracle
in file query_select_oracle.php, method ezcQuerySelectOracle::getDummyTableName()
    Returns dummy table name 'dual'.
getDummyTableName : ezcQuerySelect
in file query_select.php, method ezcQuerySelect::getDummyTableName()
    Returns dummy table name.
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.
getImplementations : ezcDbFactory
in file factory.php, method ezcDbFactory::getImplementations()
    Returns a list with supported database implementations.
getName : ezcDbHandlerOracle
in file oracle.php, method ezcDbHandlerOracle::getName()
    Returns 'oracle'.
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'.
getQuery : ezcQueryUpdate
in file query_update.php, method ezcQueryUpdate::getQuery()
    Returns the query string for this query object.
getQuery : ezcQuerySubSelect
in file query_subselect.php, method ezcQuerySubSelect::getQuery()
    Return string with SQL query for subselect.
getQuery : ezcQuerySelectOracle
in file query_select_oracle.php, method ezcQuerySelectOracle::getQuery()
    Transforms the query from the parent to provide LIMIT functionality.
getQuery : ezcQuery
in file query.php, method ezcQuery::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 : ezcQueryInsert
in file query_insert.php, method ezcQueryInsert::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.
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

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.
hasFeature : ezcDbHandlerSqlite
in file sqlite.php, method ezcDbHandlerSqlite::hasFeature()
    Returns the features supported by SQLite.
hasFeature : ezcDbHandler
in file handler.php, method ezcDbHandler::hasFeature()
    Returns true if the given $feature is supported by the handler.
hasFeature : ezcDbHandlerMysql
in file mysql.php, method ezcDbHandlerMysql::hasFeature()
    Returns the features supported by MySQL.

i

invalid.php
procedural page invalid.php
instance.php
procedural page instance.php
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 a inner join or prepares $fromString for a 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 a text field.
like : ezcQueryExpression
in file expression.php, method ezcQueryExpression::like()
    Match a partial string in a column.
limit : ezcQuerySelectOracle
in file query_select_oracle.php, method ezcQuerySelectOracle::limit()
    Returns SQL that limits the result set.
limit : ezcQuerySelect
in file query_select.php, method ezcQuerySelect::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.
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
mysql.php
procedural page mysql.php
max : ezcQueryExpression
in file expression.php, method ezcQueryExpression::max()
    Returns the highest value of a column
md5 : ezcQueryExpression
in file expression.php, method ezcQueryExpression::md5()
    Returns the md5 sum of a field.
md5 : ezcQueryExpressionPgsql
in file expression_pgsql.php, method ezcQueryExpressionPgsql::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 : 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.
now : ezcQueryExpression
in file expression.php, method ezcQueryExpression::now()
    Returns the current system date.

o

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

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

query_exception.php
procedural page query_exception.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.

r

$rightJoins : ezcQuerySelectSqlite
in file query_select_sqlite.php, variable ezcQuerySelectSqlite::$rightJoins
    Store info for building emulation of right joins in FROM clause.
reset : ezcQuerySelectSqlite
in file query_select_sqlite.php, method ezcQuerySelectSqlite::reset()
    Resets the query object for reuse.
reset : ezcQuerySelectOracle
in file query_select_oracle.php, method ezcQuerySelectOracle::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.
resetDefault : ezcDbInstance
in file instance.php, method ezcDbInstance::resetDefault()
    Resets the default instance holder.
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.
rightJoin : ezcQuerySelect
in file query_select.php, method ezcQuerySelect::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.
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 ascendingly.
sqlite.php
procedural page sqlite.php
select : ezcQuerySelect
in file query_select.php, method ezcQuerySelect::select()
    Opens the query and selects which columns you want to return with the query.
set : ezcDbInstance
in file instance.php, method ezcDbInstance::set()
    Adds the database handler $db to the list of known instances.
set : ezcQueryUpdate
in file query_update.php, method ezcQueryUpdate::set()
    The update query will set the column $column to the value $expression.
set : ezcQueryInsert
in file query_insert.php, method ezcQueryInsert::set()
    The insert query will set the column $column to the value $expression.
setAliases : ezcQuery
in file query.php, method ezcQuery::setAliases()
    Sets the aliases $aliases for this object.
setAliases : ezcQueryExpression
in file expression.php, method ezcQueryExpression::setAliases()
    Sets the aliases $aliases for this object.
sub : ezcQueryExpression
in file expression.php, method ezcQueryExpression::sub()
    Returns the SQL to subtract values or expressions from eachother.
subSelect : ezcQuerySubSelect
in file query_subselect.php, method ezcQuerySubSelect::subSelect()
    Returns ezcQuerySubSelect of deeper level.
subSelect : ezcQuerySelect
in file query_select.php, method ezcQuerySelect::subSelect()
    Returns the ezcQuerySubSelect query object.
subString : ezcQueryExpression
in file expression.php, method ezcQueryExpression::subString()
    Returns part of a string.
subString : ezcQueryExpressionSqlite
in file expression_sqlite.php, method ezcQueryExpressionSqlite::subString()
    Returns part of a string.
subString : ezcQueryExpressionPgsql
in file expression_pgsql.php, method ezcQueryExpressionPgsql::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

u

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

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.
Last updated: Wed, 28 Nov 2007