db_select($table, $alias = NULL, array $options = array())
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. For example, $injected_database->select($table, $alias, $options);
See also
\Drupal\Core\Database\Connection::select()
\Drupal\Core\Database\Connection::defaultOptions()
Related topics
- Database abstraction layer
- Allow the use of different database servers using the same code base.
File
- core/includes/database.inc, line 291
- Core systems for the database layer.
Code
1 2 3 4 5 6 | 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 ); } |
Please login to continue.