Query builder for SELECT statements.

Hierarchy

Expanded class hierarchy of SelectQuery

Related topics

File

core/includes/database/select.inc, line 868

Members

Contains filters are case sensitive
Namesort descending Modifiers Type Description
Query::$comments protected property An array of comments that can be prepended to a query.
Query::$connection protected property The connection object on which to run this query.
Query::$connectionKey protected property The key of the connection object.
Query::$connectionTarget protected property The target of the connection object.
Query::$nextPlaceholder protected property The placeholder counter.
Query::$queryOptions protected property The query options to pass on to the connection object.
Query::$uniqueIdentifier protected property A unique identifier for this query object.
Query::comment public function Adds a comment to the query.
Query::getComments public function Returns a reference to the comments array for the query.
Query::nextPlaceholder public function Gets the next placeholder value for this query object. Overrides QueryPlaceholderInterface::nextPlaceholder
Query::uniqueIdentifier public function Returns a unique identifier for this object. Overrides QueryPlaceholderInterface::uniqueIdentifier
Query::__sleep public function Implements the magic __sleep function to disconnect from the database.
Query::__wakeup public function Implements the magic __wakeup function to reconnect to the database.
SelectQuery::$alterMetaData protected property A list of arbitrary metadata that may be attached to the query.
SelectQuery::$alterTags protected property A list of tags by which this query may be altered.
SelectQuery::$distinct protected property Whether or not this query should be DISTINCT
SelectQuery::$expressions protected property The expressions to SELECT as virtual fields.
SelectQuery::$fields protected property The fields to SELECT.
SelectQuery::$forUpdate protected property The FOR UPDATE status
SelectQuery::$group protected property The fields by which to group.
SelectQuery::$having protected property The conditional object for the HAVING clause.
SelectQuery::$order protected property The fields by which to order this query.
SelectQuery::$prepared protected property Indicates if preExecute() has already been called.
SelectQuery::$range protected property The range limiters for this query.
SelectQuery::$tables protected property The tables against which to JOIN.
SelectQuery::$union protected property An array whose elements specify a query to UNION, and the UNION type. The 'type' key may be '', 'ALL', or 'DISTINCT' to represent a 'UNION', 'UNION ALL', or 'UNION DISTINCT'…
SelectQuery::$where protected property The conditional object for the WHERE clause.
SelectQuery::addExpression public function Implements SelectQueryInterface::addExpression(). Overrides SelectQueryInterface::addExpression
SelectQuery::addField public function Implements SelectQueryInterface::addField().di Overrides SelectQueryInterface::addField
SelectQuery::addJoin public function Implements SelectQueryInterface::addJoin(). Overrides SelectQueryInterface::addJoin
SelectQuery::addMetaData public function Implements QueryAlterableInterface::addMetaData(). Overrides QueryAlterableInterface::addMetaData
SelectQuery::addTag public function Implements QueryAlterableInterface::addTag(). Overrides QueryAlterableInterface::addTag
SelectQuery::arguments public function Implements QueryConditionInterface::arguments(). Overrides QueryConditionInterface::arguments
SelectQuery::compile public function Implements QueryConditionInterface::compile(). Overrides QueryConditionInterface::compile
SelectQuery::compiled public function Implements QueryConditionInterface::compiled(). Overrides QueryConditionInterface::compiled
SelectQuery::condition public function Implements QueryConditionInterface::condition(). Overrides QueryConditionInterface::condition
SelectQuery::conditions public function Implements QueryConditionInterface::conditions(). Overrides QueryConditionInterface::conditions
SelectQuery::countQuery public function Implements SelectQueryInterface::countQuery(). Overrides SelectQueryInterface::countQuery
SelectQuery::distinct public function Implements SelectQueryInterface::distinct(). Overrides SelectQueryInterface::distinct
SelectQuery::execute public function Implements SelectQueryInterface::execute(). Overrides Query::execute
SelectQuery::exists public function Implements QueryConditionInterface::exists(). Overrides QueryConditionInterface::exists
SelectQuery::extend public function Implements QueryExtendableInterface::extend(). Overrides QueryExtendableInterface::extend
SelectQuery::fields public function Implements SelectQueryInterface::fields(). Overrides SelectQueryInterface::fields
SelectQuery::forUpdate public function Implements QueryExtendableInterface::forUpdate(). Overrides SelectQueryInterface::forUpdate
SelectQuery::getArguments public function Implements SelectQueryInterface::getArguments(). Overrides SelectQueryInterface::getArguments
SelectQuery::getExpressions public function Implements SelectQueryInterface::getExpressions(). Overrides SelectQueryInterface::getExpressions
SelectQuery::getFields public function Implements SelectQueryInterface::getFields(). Overrides SelectQueryInterface::getFields
SelectQuery::getGroupBy public function Implements SelectQueryInterface::getGroupBy(). Overrides SelectQueryInterface::getGroupBy
SelectQuery::getMetaData public function Implements QueryAlterableInterface::getMetaData(). Overrides QueryAlterableInterface::getMetaData
SelectQuery::getOrderBy public function Implements SelectQueryInterface::getOrderBy(). Overrides SelectQueryInterface::getOrderBy
SelectQuery::getTables public function Implements SelectQueryInterface::getTables(). Overrides SelectQueryInterface::getTables
SelectQuery::getUnion public function Implements SelectQueryInterface::getUnion(). Overrides SelectQueryInterface::getUnion
SelectQuery::groupBy public function Implements SelectQueryInterface::groupBy(). Overrides SelectQueryInterface::groupBy
SelectQuery::hasAllTags public function Implements QueryAlterableInterface::hasAllTags(). Overrides QueryAlterableInterface::hasAllTags
SelectQuery::hasAnyTag public function Implements QueryAlterableInterface::hasAnyTag(). Overrides QueryAlterableInterface::hasAnyTag
SelectQuery::hasTag public function Implements QueryAlterableInterface::hasTag(). Overrides QueryAlterableInterface::hasTag
SelectQuery::having public function Implements QueryConditionInterface::having().
SelectQuery::havingArguments public function Implements QueryConditionInterface::havingArguments().
SelectQuery::havingCompile public function Implements QueryConditionInterface::havingCompile().
SelectQuery::havingCondition public function Implements QueryConditionInterface::havingCondition(). Overrides SelectQueryInterface::havingCondition
SelectQuery::havingConditions public function Implements QueryConditionInterface::havingConditions().
SelectQuery::havingExists public function Implements QueryExtendableInterface::havingExists().
SelectQuery::havingIsNotNull public function Implements QueryExtendableInterface::havingIsNotNull().
SelectQuery::havingIsNull public function Implements QueryExtendableInterface::havingIsNull().
SelectQuery::havingNotExists public function Implements QueryExtendableInterface::havingNotExists().
SelectQuery::innerJoin public function Implements SelectQueryInterface::innerJoin(). Overrides SelectQueryInterface::innerJoin
SelectQuery::isNotNull public function Implements QueryConditionInterface::isNotNull(). Overrides QueryConditionInterface::isNotNull
SelectQuery::isNull public function Implements QueryConditionInterface::isNull(). Overrides QueryConditionInterface::isNull
SelectQuery::isPrepared public function Implements SelectQueryInterface::isPrepared(). Overrides SelectQueryInterface::isPrepared
SelectQuery::join public function Implements SelectQueryInterface::join(). Overrides SelectQueryInterface::join
SelectQuery::leftJoin public function Implements SelectQueryInterface::leftJoin(). Overrides SelectQueryInterface::leftJoin
SelectQuery::notExists public function Implements QueryConditionInterface::notExists(). Overrides QueryConditionInterface::notExists
SelectQuery::orderBy public function Implements SelectQueryInterface::orderBy(). Overrides SelectQueryInterface::orderBy
SelectQuery::orderRandom public function Implements SelectQueryInterface::orderRandom(). Overrides SelectQueryInterface::orderRandom
SelectQuery::preExecute public function Implements SelectQueryInterface::preExecute(). Overrides SelectQueryInterface::preExecute
SelectQuery::range public function Implements SelectQueryInterface::range(). Overrides SelectQueryInterface::range
SelectQuery::rightJoin public function Implements SelectQueryInterface::rightJoin(). Overrides SelectQueryInterface::rightJoin
SelectQuery::union public function Implements SelectQueryInterface::union(). Overrides SelectQueryInterface::union
SelectQuery::where public function Implements QueryConditionInterface::where(). Overrides QueryConditionInterface::where
SelectQuery::__clone public function Implements the magic __clone function. Overrides Query::__clone
SelectQuery::__construct public function Constructs a Query object. Overrides Query::__construct
SelectQuery::__toString public function Implements PHP magic __toString method to convert the query to a string. Overrides Query::__toString