function db_select in Zircon Profile 8
Same name and namespace in other branches
- 8.0 core/includes/database.inc \db_select()
Returns a new SelectQuery object for the active database.
Parameters
string|\Drupal\Core\Database\Query\SelectInterface $table: The base table for this query. May be a string or another SelectInterface object. If a SelectInterface object is passed, it will be used as a subselect.
string $alias: (optional) The alias for the base table of this query.
array $options: (optional) An array of options to control how the query operates.
Return value
\Drupal\Core\Database\Query\Select A new Select object for this connection.
Deprecated
as of Drupal 8.0.x, will be removed in Drupal 9.0.0. Instead, get a database connection injected into your service from the container and call select() on it. E.g. $injected_database->select($table, $alias, $options);
See also
\Drupal\Core\Database\Connection::select()
\Drupal\Core\Database\Connection::defaultOptions()
Related topics
61 calls to db_select()
- AlterTest::testAlterChangeConditional in core/
modules/ system/ src/ Tests/ Database/ AlterTest.php - Tests that we can alter a query's conditionals.
- AlterTest::testAlterChangeFields in core/
modules/ system/ src/ Tests/ Database/ AlterTest.php - Tests that we can alter the fields of a query.
- AlterTest::testAlterExpression in core/
modules/ system/ src/ Tests/ Database/ AlterTest.php - Tests that we can alter expressions in the query.
- AlterTest::testAlterRemoveRange in core/
modules/ system/ src/ Tests/ Database/ AlterTest.php - Tests that we can remove a range() value from a query.
- AlterTest::testAlterWithJoin in core/
modules/ system/ src/ Tests/ Database/ AlterTest.php - Tests that we can alter the joins on a query.
File
- core/
includes/ database.inc, line 286 - Core systems for the database layer.
Code
function db_select($table, $alias = NULL, array $options = array()) {
if (empty($options['target'])) {
$options['target'] = 'default';
}
return Database::getConnection($options['target'])
->select($table, $alias, $options);
}