Skip to main content
Hostdog docs
Documentation & API reference
Main menu
Drupal 7
Drupal 8
Drupal 9
You are here
Home
»
API reference
»
Drupal 8.x
»
database.inc
»
db_select
Search Drupal 8.x
Function, class, file, topic, etc.
*
Partial match search is supported
API Navigation
Drupal 8.x
Topics
Classes
Functions
Files
Namespaces
Services
Constants
Globals
Deprecated
98 calls to db_select()
aggregator_load_feed_items
in drupal/
core/
modules/
aggregator/
aggregator.pages.inc
Loads and optionally filters feed items.
AlterTest::testAlterChangeConditional
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
AlterTest.php
Tests that we can alter a query's conditionals.
AlterTest::testAlterChangeFields
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
AlterTest.php
Tests that we can alter the fields of a query.
AlterTest::testAlterExpression
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
AlterTest.php
Tests that we can alter expressions in the query.
AlterTest::testAlterRemoveRange
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
AlterTest.php
Tests that we can remove a
range
() value from a query.
AlterTest::testAlterWithJoin
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
AlterTest.php
Tests that we can alter the joins on a query.
AlterTest::testSimpleAlter
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
AlterTest.php
Tests that we can do basic alters.
AlterTest::testSimpleAlterSubquery
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
AlterTest.php
Tests that we can do basic alters on subqueries.
block_update_8005
in drupal/
core/
modules/
block/
block.install
Migrate {users}.data into {users_data}.
block_update_8008
in drupal/
core/
modules/
block/
block.install
Migrate {block_custom}.body and {block_custom}.format to block_body field.
book_menu_subtree_data
in drupal/
core/
modules/
book/
book.module
Gets the data representing a subtree of the book hierarchy.
book_update_bid
in drupal/
core/
modules/
book/
book.module
Updates the book ID of a page and its children when it moves to a new book.
CommentFormController::validate
in drupal/
core/
modules/
comment/
lib/
Drupal/
comment/
CommentFormController.php
Overrides
Drupal\Core\Entity\EntityFormController::validate
().
comment_enable
in drupal/
core/
modules/
comment/
comment.install
Implements
hook_enable
().
comment_get_display_ordinal
in drupal/
core/
modules/
comment/
comment.module
Gets the display ordinal for a comment, starting from 0.
comment_get_recent
in drupal/
core/
modules/
comment/
comment.module
Finds the most recent comments that are available to the current user.
comment_get_thread
in drupal/
core/
modules/
comment/
comment.module
Retrieves comments for a thread.
contact_update_8003
in drupal/
core/
modules/
contact/
contact.install
Migrate {users}.data into {users_data}.
database_test_even_pager_query
in drupal/
core/
modules/
system/
tests/
modules/
database_test/
database_test.module
Runs a pager query and returns the results.
database_test_odd_pager_query
in drupal/
core/
modules/
system/
tests/
modules/
database_test/
database_test.module
Runs a pager query and returns the results.
database_test_tablesort
in drupal/
core/
modules/
system/
tests/
modules/
database_test/
database_test.module
Runs a tablesort query and returns the results.
database_test_tablesort_first
in drupal/
core/
modules/
system/
tests/
modules/
database_test/
database_test.module
Runs a tablesort query with a second order_by after and returns the results.
database_test_theme_tablesort
in drupal/
core/
modules/
system/
tests/
modules/
database_test/
database_test.module
Outputs a form without setting a header sort.
dblog_top
in drupal/
core/
modules/
dblog/
dblog.admin.inc
Page callback: Shows the most frequent log messages of a given event type.
forum_forum_load
in drupal/
core/
modules/
forum/
forum.module
Returns a tree of all forums for a given taxonomy term ID.
forum_get_topics
in drupal/
core/
modules/
forum/
forum.module
Gets all the topics in a forum.
forum_node_load
in drupal/
core/
modules/
forum/
forum.module
Implements
hook_node_load
().
hook_field_storage_query
in drupal/
core/
modules/
field/
field.api.php
Execute a Drupal\Core\Entity\EntityFieldQuery.
IndexTidDepth::query
in drupal/
core/
modules/
taxonomy/
lib/
Drupal/
taxonomy/
Plugin/
views/
argument/
IndexTidDepth.php
Set up the query for this argument.
InsertTest::testInsertSelect
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
InsertTest.php
Tests that the INSERT INTO ... SELECT ... syntax works.
JoinTest::testBasePlugin
in drupal/
core/
modules/
views/
lib/
Drupal/
views/
Tests/
Plugin/
JoinTest.php
Tests the join plugin base.
JoinTest::testExamplePlugin
in drupal/
core/
modules/
views/
lib/
Drupal/
views/
Tests/
Plugin/
JoinTest.php
Tests an example join plugin.
menu_tree_check_access
in drupal/
core/
includes/
menu.inc
Checks access and performs dynamic operations for each link in the tree.
NodeAccessController::accessGrants
in drupal/
core/
modules/
node/
lib/
Drupal/
node/
NodeAccessController.php
Determines access to nodes based on node grants.
NodeNewComments::pre_render
in drupal/
core/
modules/
comment/
lib/
Drupal/
comment/
Plugin/
views/
field/
NodeNewComments.php
Run before any fields are rendered.
NodeTermData::query
in drupal/
core/
modules/
taxonomy/
lib/
Drupal/
taxonomy/
Plugin/
views/
relationship/
NodeTermData.php
Called to implement a relationship in a query.
node_access_view_all_nodes
in drupal/
core/
modules/
node/
node.module
Determines whether the user has a global viewing grant for all nodes.
node_get_recent
in drupal/
core/
modules/
node/
node.module
Finds the most recently changed nodes that are available to the current user.
overlay_update_8000
in drupal/
core/
modules/
overlay/
overlay.install
Migrate {users}.data into {users_data}.
Permissions::pre_render
in drupal/
core/
modules/
user/
lib/
Drupal/
user/
Plugin/
views/
field/
Permissions.php
Run before any fields are rendered.
Roles::pre_render
in drupal/
core/
modules/
user/
lib/
Drupal/
user/
Plugin/
views/
field/
Roles.php
Run before any fields are rendered.
SearchQuery::countQuery
in drupal/
core/
modules/
search/
lib/
Drupal/
search/
SearchQuery.php
Builds the default count query for SearchQuery.
SelectCloneTest::testSelectConditionSubQueryCloning
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectCloneTest.php
Test that subqueries as value within conditions are cloned properly.
SelectComplexTest::testCountQuery
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectComplexTest.php
Tests that we can generate a count query from a built query.
SelectComplexTest::testCountQueryDistinct
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectComplexTest.php
Tests that we can generate a count query from a query with distinct.
SelectComplexTest::testCountQueryFieldRemovals
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectComplexTest.php
Tests that countQuery properly removes fields and expressions.
SelectComplexTest::testCountQueryGroupBy
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectComplexTest.php
Tests that we can generate a count query from a query with GROUP BY.
SelectComplexTest::testCountQueryRemovals
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectComplexTest.php
Tests that countQuery removes 'all_fields' statements and ordering clauses.
SelectComplexTest::testDefaultJoin
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectComplexTest.php
Tests simple JOIN statements.
SelectComplexTest::testDistinct
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectComplexTest.php
Tests distinct queries.
SelectComplexTest::testGroupBy
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectComplexTest.php
Tests GROUP BY clauses.
SelectComplexTest::testGroupByAndHaving
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectComplexTest.php
Tests GROUP BY and HAVING clauses together.
SelectComplexTest::testJoinSubquery
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectComplexTest.php
Tests that we can join on a query.
SelectComplexTest::testLeftOuterJoin
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectComplexTest.php
Tests LEFT OUTER joins.
SelectComplexTest::testNestedConditions
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectComplexTest.php
Confirms that we can properly nest conditional clauses.
SelectComplexTest::testRange
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectComplexTest.php
Tests range queries.
SelectOrderedTest::testSimpleSelectMultiOrdered
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectOrderedTest.php
Tests multiple ORDER BY.
SelectOrderedTest::testSimpleSelectOrdered
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectOrderedTest.php
Tests basic ORDER BY.
SelectOrderedTest::testSimpleSelectOrderedDesc
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectOrderedTest.php
Tests ORDER BY descending.
SelectPagerDefaultTest::testInnerPagerQuery
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectPagerDefaultTest.php
Confirms that a pager query results with an inner pager query are valid.
SelectSubqueryTest::testConditionSubquerySelect
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectSubqueryTest.php
Tests that we can use a subquery in a WHERE clause.
SelectSubqueryTest::testFromSubquerySelect
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectSubqueryTest.php
Tests that we can use a subquery in a FROM clause.
SelectSubqueryTest::testFromSubquerySelectWithLimit
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectSubqueryTest.php
Tests that we can use a subquery in a FROM clause with a LIMIT.
SelectSubqueryTest::testJoinSubquerySelect
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectSubqueryTest.php
Tests that we can use a subquery in a JOIN clause.
SelectTest::testSelectDuplicateAlias
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectTest.php
Tests that aliases are renamed when they are duplicates.
SelectTest::testSimpleSelect
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectTest.php
Tests rudimentary SELECT statements.
SelectTest::testSimpleSelectConditional
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectTest.php
Tests basic conditionals on SELECT statements.
SelectTest::testSimpleSelectExpression
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectTest.php
Tests SELECT statements with expressions.
SelectTest::testSimpleSelectExpressionMultiple
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SelectTest.php
Tests SELECT statements with multiple expressions.
SerializeQueryTest::testSerializeQuery
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
SerializeQueryTest.php
Confirms that a query can be serialized and unserialized.
shortcut_current_displayed_set
in drupal/
core/
modules/
shortcut/
shortcut.module
Returns the current displayed shortcut set for the provided user account.
statistics_title_list
in drupal/
core/
modules/
statistics/
statistics.module
Returns the most viewed content of all time, today, or the last-viewed node.
TaggingTest::testHasAllTags
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
TaggingTest.php
Tests query tagging "has all of these tags" functionality.
TaggingTest::testHasAnyTag
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
TaggingTest.php
Tests query tagging "has at least one of these tags" functionality.
TaggingTest::testHasTag
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
TaggingTest.php
Confirms that a query has a tag added to it.
TaggingTest::testMetaData
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
TaggingTest.php
Tests that we can attach metadata to a query object.
TaxonomyIndexTid::pre_render
in drupal/
core/
modules/
taxonomy/
lib/
Drupal/
taxonomy/
Plugin/
views/
field/
TaxonomyIndexTid.php
Run before any fields are rendered.
TaxonomyIndexTid::validate_term_strings
in drupal/
core/
modules/
taxonomy/
lib/
Drupal/
taxonomy/
Plugin/
views/
filter/
TaxonomyIndexTid.php
Validate the user string. Since this can come from either the form or the exposed filter, this is abstracted out a bit so it can handle the multiple input sources.
TaxonomyIndexTid::valueForm
in drupal/
core/
modules/
taxonomy/
lib/
Drupal/
taxonomy/
Plugin/
views/
filter/
TaxonomyIndexTid.php
Options form subform for setting options.
TaxonomyIndexTidDepth::query
in drupal/
core/
modules/
taxonomy/
lib/
Drupal/
taxonomy/
Plugin/
views/
filter/
TaxonomyIndexTidDepth.php
Add this filter to the query.
taxonomy_autocomplete
in drupal/
core/
modules/
taxonomy/
taxonomy.pages.inc
Page callback: Outputs JSON for taxonomy autocomplete suggestions.
taxonomy_get_tree
in drupal/
core/
modules/
taxonomy/
taxonomy.module
Create a hierarchical representation of a vocabulary.
taxonomy_select_nodes
in drupal/
core/
modules/
taxonomy/
taxonomy.module
Return nodes attached to a term across all field instances.
taxonomy_term_load_children
in drupal/
core/
modules/
taxonomy/
taxonomy.module
Finds all children of a term ID.
taxonomy_term_load_parents
in drupal/
core/
modules/
taxonomy/
taxonomy.module
Finds all parents of a given term ID.
taxonomy_tokens
in drupal/
core/
modules/
taxonomy/
taxonomy.tokens.inc
Implements
hook_tokens
().
toolbar_get_rendered_subtrees
in drupal/
core/
modules/
toolbar/
toolbar.module
Returns the rendered subtree of each top-level toolbar link.
tracker_cron
in drupal/
core/
modules/
tracker/
tracker.module
Implements
hook_cron
().
translation_node_get_translations
in drupal/
core/
modules/
translation/
translation.module
Gets all nodes in a given translation set.
UpdateComplexTest::testSubSelectUpdate
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
UpdateComplexTest.php
Test UPDATE with a subselect value.
User::validateArgument
in drupal/
core/
modules/
user/
lib/
Drupal/
user/
Plugin/
views/
argument_validator/
User.php
UserDeleteTest::testUserDeleteMultiple
in drupal/
core/
modules/
user/
lib/
Drupal/
user/
Tests/
UserDeleteTest.php
Test deleting multiple users.
UserUid::query
in drupal/
core/
modules/
comment/
lib/
Drupal/
comment/
Plugin/
views/
argument/
UserUid.php
Set up the query for this argument.
UserUid::query
in drupal/
core/
modules/
comment/
lib/
Drupal/
comment/
Plugin/
views/
filter/
UserUid.php
Add this filter to the query.
UserUid::title
in drupal/
core/
modules/
comment/
lib/
Drupal/
comment/
Plugin/
views/
argument/
UserUid.php
Get the title this argument will assign the view, given the argument.
user_admin_account
in drupal/
core/
modules/
user/
user.admin.inc
Page callback: User administration page.
views_ajax_autocomplete_taxonomy
in drupal/
core/
modules/
views/
includes/
ajax.inc
Page callback for views taxonomy autocomplete.
_forum_topics_unread
in drupal/
core/
modules/
forum/
forum.module
Calculates the number of new posts in a forum that the user has not yet read.