function db_select in Zircon Profile 8.0

Same name and namespace in other branches

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

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.

... See full list

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);
}