public Select::getArguments(PlaceholderInterface $queryPlaceholder = NULL) Compiles and returns an associative array of the arguments for this prepared statement. Parameters $queryPlaceholder: When collecting the arguments of a subquery, the main placeholder object should be passed as this parameter. Return value An associative array of all placeholder arguments for this query. Overrides SelectInterface::getArguments File core/lib/Drupal/Core/Database/Query/Select.php, line 428 Class Sele

public Select::forUpdate($set = TRUE) Add FOR UPDATE to the query. FOR UPDATE prevents the rows retrieved by the SELECT statement from being modified or deleted by other transactions until the current transaction ends. Other transactions that attempt UPDATE, DELETE, or SELECT FOR UPDATE of these rows will be blocked until the current transaction ends. Parameters $set: IF TRUE, FOR UPDATE will be added to the query, if FALSE then it won't. Return value \Drupal\Core\Database\Query\ConditionInte

public Select::escapeLike($string) Escapes characters that work as wildcard characters in a LIKE pattern. Parameters $string: The string to escape. Return value string The escaped string. Overrides SelectInterface::escapeLike See also \Drupal\Core\Database\Connection::escapeLike() File core/lib/Drupal/Core/Database/Query/Select.php, line 414 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code public function escapeLike($string) { return $thi

public Select::extend($extender_name) Enhance this object by wrapping it in an extender object. Parameters $extender_name: The fully-qualified name of the extender class, without the leading '\' (for example, Drupal\my_module\myExtenderClass). The extender name will be checked against the current database connection to allow driver-specific subclasses as well, using the same logic as the query objects themselves. Return value \Drupal\Core\Database\Query\ExtendableInterface The extender object

public Select::execute() Runs the query against the database. Return value \Drupal\Core\Database\StatementInterface|null A prepared statement, or NULL if the query is not valid. Overrides Select::execute File core/lib/Drupal/Core/Database/Driver/pgsql/Select.php, line 142 Class Select PostgreSQL implementation of \Drupal\Core\Database\Query\Select. Namespace Drupal\Core\Database\Driver\pgsql Code public function execute() { $this->connection->addSavepoint(); try { $resul

public Select::escapeField($string) Escapes a field name string. Force all field names to be strictly alphanumeric-plus-underscore. For some database drivers, it may also wrap the field name in database-specific escape characters. Parameters string $string: An unsanitized field name. Return value The sanitized field name string. Overrides SelectInterface::escapeField File core/lib/Drupal/Core/Database/Query/Select.php, line 421 Class Select Query builder for SELECT statements. Namespac

public Select::execute() Runs the query against the database. Return value \Drupal\Core\Database\StatementInterface|null A prepared statement, or NULL if the query is not valid. Overrides Query::execute File core/lib/Drupal/Core/Database/Query/Select.php, line 485 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code public function execute() { // If validation fails, simply return NULL. // Note that validation routines in preExecute() may thr

public Select::fields($table_alias, array $fields = array()) Add multiple fields from the same table to be SELECTed. This method does not return the aliases set for the passed fields. In the majority of cases that is not a problem, as the alias will be the field name. However, if you do need to know the alias you can call getFields() and examine the result to determine what alias was created. Alternatively, simply use addField() for the few fields you care about and this method for the rest. Pa

public Select::addTag($tag) Adds a tag to a query. Tags are strings that identify a query. A query may have any number of tags. Tags are used to mark a query so that alter hooks may decide if they wish to take action. Tags should be all lower-case and contain only letters, numbers, and underscore, and start with a letter. That is, they should follow the same rules as PHP identifiers in general. Parameters $tag: The tag to add. Return value \Drupal\Core\Database\Query\AlterableInterface The ca

public Select::compile(Connection $connection, PlaceholderInterface $queryPlaceholder) Compiles the saved conditions for later retrieval. This method does not return anything, but simply prepares data to be retrieved via __toString() and arguments(). Parameters $connection: The database connection for which to compile the conditionals. $queryPlaceholder: The query this condition belongs to. If not given, the current query is used. Overrides QueryConditionTrait::compile File core/lib/Drupal/Cor