Interface definition for a Select Query object.
Hierarchy
- interface \Drupal\Core\Database\Query\ConditionInterface; interface \Drupal\Core\Database\Query\AlterableInterface; interface \Drupal\Core\Database\Query\ExtendableInterface; interface \Drupal\Core\Database\Query\PlaceholderInterface
- interface \Drupal\Core\Database\Query\SelectInterface
Related topics
- Database abstraction layer
- Allow the use of different database servers using the same code base.
File
- core/lib/Drupal/Core/Database/Query/SelectInterface.php, line 12
Namespace
Drupal\Core\Database\Query
Members
Name | Modifiers | Type | Description |
---|---|---|---|
AlterableInterface::addMetaData | public | function | Adds additional metadata to the query. |
AlterableInterface::addTag | public | function | Adds a tag to a query. |
AlterableInterface::getMetaData | public | function | Retrieves a given piece of metadata. |
AlterableInterface::hasAllTags | public | function | Determines if a given query has all specified tags. |
AlterableInterface::hasAnyTag | public | function | Determines if a given query has any specified tag. |
AlterableInterface::hasTag | public | function | Determines if a given query has a given tag. |
ConditionInterface::andConditionGroup | public | function | Creates a new group of conditions ANDed together. |
ConditionInterface::arguments | public | function | Gets a complete list of all values to insert into the prepared statement. |
ConditionInterface::compile | public | function | Compiles the saved conditions for later retrieval. |
ConditionInterface::compiled | public | function | Check whether a condition has been previously compiled. |
ConditionInterface::condition | public | function | Helper function: builds the most common conditional clauses. |
ConditionInterface::conditionGroupFactory | public | function | Creates an object holding a group of conditions. |
ConditionInterface::conditions | public | function | Gets a complete list of all conditions in this conditional clause. |
ConditionInterface::exists | public | function | Sets a condition that the specified subquery returns values. |
ConditionInterface::isNotNull | public | function | Sets a condition that the specified field be NOT NULL. |
ConditionInterface::isNull | public | function | Sets a condition that the specified field be NULL. |
ConditionInterface::notExists | public | function | Sets a condition that the specified subquery returns no values. |
ConditionInterface::orConditionGroup | public | function | Creates a new group of conditions ORed together. |
ConditionInterface::where | public | function | Adds an arbitrary WHERE clause to the query. |
ExtendableInterface::extend | public | function | Enhance this object by wrapping it in an extender object. |
PlaceholderInterface::nextPlaceholder | public | function | Returns the next placeholder ID for the query. |
PlaceholderInterface::uniqueIdentifier | public | function | Returns a unique identifier for this object. |
SelectInterface::addExpression | public | function | Adds an expression to the list of "fields" to be SELECTed. |
SelectInterface::addField | public | function | Adds a field to the list to be SELECTed. |
SelectInterface::addJoin | public | function | Join against another table in the database. |
SelectInterface::countQuery | public | function | Get the equivalent COUNT query of this query as a new query object. |
SelectInterface::distinct | public | function | Sets this query to be DISTINCT. |
SelectInterface::escapeField | public | function | Escapes a field name string. |
SelectInterface::escapeLike | public | function | Escapes characters that work as wildcard characters in a LIKE pattern. |
SelectInterface::execute | public | function | Runs the query against the database. |
SelectInterface::fields | public | function | Add multiple fields from the same table to be SELECTed. |
SelectInterface::forUpdate | public | function | Add FOR UPDATE to the query. |
SelectInterface::getArguments | public | function | Compiles and returns an associative array of the arguments for this prepared statement. |
SelectInterface::getExpressions | public | function | Returns a reference to the expressions array for this query. |
SelectInterface::getFields | public | function | Returns a reference to the fields array for this query. |
SelectInterface::getGroupBy | public | function | Returns a reference to the group-by array for this query. |
SelectInterface::getOrderBy | public | function | Returns a reference to the order by array for this query. |
SelectInterface::getTables | public | function | Returns a reference to the tables array for this query. |
SelectInterface::getUnion | public | function | Returns a reference to the union queries for this query. This include queries for UNION, UNION ALL, and UNION DISTINCT. |
SelectInterface::groupBy | public | function | Groups the result set by the specified field. |
SelectInterface::having | public | function | Adds an arbitrary HAVING clause to the query. |
SelectInterface::havingArguments | public | function | Gets a list of all values to insert into the HAVING clause. |
SelectInterface::havingCompile | public | function | Compiles the HAVING clause for later retrieval. |
SelectInterface::havingCondition | public | function | Helper function to build most common HAVING conditional clauses. |
SelectInterface::havingConditions | public | function | Gets a list of all conditions in the HAVING clause. |
SelectInterface::havingExists | public | function | Sets a HAVING condition that the specified subquery returns values. |
SelectInterface::havingIsNotNull | public | function | Sets a condition in the HAVING clause that the specified field be NOT NULL. |
SelectInterface::havingIsNull | public | function | Sets a condition in the HAVING clause that the specified field be NULL. |
SelectInterface::havingNotExists | public | function | Sets a HAVING condition that the specified subquery returns no values. |
SelectInterface::innerJoin | public | function | Inner Join against another table in the database. |
SelectInterface::isPrepared | public | function | Indicates if preExecute() has already been called on that object. |
SelectInterface::join | public | function | Default Join against another table in the database. |
SelectInterface::leftJoin | public | function | Left Outer Join against another table in the database. |
SelectInterface::orderBy | public | function | Orders the result set by a given field. |
SelectInterface::orderRandom | public | function | Orders the result set by a random value. |
SelectInterface::preExecute | public | function | Generic preparation and validation for a SELECT query. |
SelectInterface::range | public | function | Restricts a query to a given range in the result set. |
SelectInterface::rightJoin Deprecated | public | function | Right Outer Join against another table in the database. |
SelectInterface::union | public | function | Add another Select query to UNION to this one. |
SelectInterface::__clone | public | function | Clone magic method. |
SelectInterface::__toString | public | function | Returns a string representation of how the query will be executed in SQL. |
Please login to continue.