Skip to main content
Hostdog docs
Documentation & API reference
Main menu
Drupal 7
Drupal 8
Drupal 9
You are here
Home
»
API reference
»
Drupal 9.x
»
database.inc
»
db_select
Search Drupal 9.x
Function, class, file, topic, etc.
*
Partial match search is supported
API Navigation
Drupal 9.x
Topics
Classes
Functions
Files
Namespaces
Constants
Globals
Deprecated
121 calls to db_select()
actions_do
in drupal/
core/
modules/
action/
action.module
Performs a given list of actions by executing their callback functions.
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}.
book_get_books
in drupal/
core/
modules/
book/
book.module
Returns an array of all books.
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}.
DatabaseStorageController::buildQuery
in drupal/
core/
lib/
Drupal/
Core/
Entity/
DatabaseStorageController.php
Builds the query to load the entity.
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.
FieldInfo::getFieldMap
in drupal/
core/
modules/
field/
lib/
Drupal/
field/
FieldInfo.php
Collects a lightweight map of fields across bundles.
field_read_fields
in drupal/
core/
modules/
field/
field.crud.inc
Reads in fields that match an array of conditions.
field_read_instances
in drupal/
core/
modules/
field/
field.crud.inc
Reads in field instances that match an array of conditions.
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_link_children_relative_depth
in drupal/
core/
includes/
menu.inc
Finds the depth of an item's children relative to its depth.
menu_link_get_preferred
in drupal/
core/
includes/
menu.inc
Looks up the preferred menu link for a given system path.
menu_link_load
in drupal/
core/
includes/
menu.inc
Gets a translated, access-checked menu link that is ready for rendering.
menu_tree_check_access
in drupal/
core/
includes/
menu.inc
Checks access and performs dynamic operations for each link in the tree.
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
in drupal/
core/
modules/
node/
node.module
Access callback: Checks a user's permission for performing a node operation.
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.
node_views_analyze
in drupal/
core/
modules/
node/
node.views.inc
Implements hook_views_analyze().
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.
poll_block_view
in drupal/
core/
modules/
poll/
poll.module
Implements
hook_block_view
().
poll_page
in drupal/
core/
modules/
poll/
poll.pages.inc
Page callback: Displays a simple list of all available polls.
Roles::pre_render
in drupal/
core/
modules/
user/
lib/
Drupal/
user/
Plugin/
views/
field/
Roles.php
Run before any fields are rendered.
RolesRid::title_query
in drupal/
core/
modules/
user/
lib/
Drupal/
user/
Plugin/
views/
argument/
RolesRid.php
Override for specific title lookups.
SearchQuery::countQuery
in drupal/
core/
modules/
search/
lib/
Drupal/
search/
SearchQuery.php
Builds the default count query for SearchQuery.
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.
statistics_top_pages
in drupal/
core/
modules/
statistics/
statistics.admin.inc
Page callback: Displays statistics for the "top pages" (most accesses).
statistics_top_referrers
in drupal/
core/
modules/
statistics/
statistics.admin.inc
Page callback: Displays the "top referrers" in the access logs.
statistics_top_visitors
in drupal/
core/
modules/
statistics/
statistics.admin.inc
Page callback: Displays the "top visitors" page.
system_admin_menu_block
in drupal/
core/
modules/
system/
system.module
Provide a single block on the administration overview page.
system_get_module_admin_tasks
in drupal/
core/
modules/
system/
system.module
Generate a list of tasks offered by a specified module.
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::value_form
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
().
UpdateComplexTest::testSubSelectUpdate
in drupal/
core/
modules/
system/
lib/
Drupal/
system/
Tests/
Database/
UpdateComplexTest.php
Test UPDATE with a subselect value.
User::validate_argument
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
Form builder; User administration page.
user_roles
in drupal/
core/
modules/
user/
user.module
Retrieve an array of roles matching specified conditions.
user_role_save
in drupal/
core/
modules/
user/
user.module
Save a user role to the database.
views_ajax_autocomplete_taxonomy
in drupal/
core/
modules/
views/
includes/
ajax.inc
Page callback for views taxonomy autocomplete.
VocabularyMachineName::title
in drupal/
core/
modules/
taxonomy/
lib/
Drupal/
taxonomy/
Plugin/
views/
argument/
VocabularyMachineName.php
Override the behavior of title(). Get the name of the vocabulary..
VocabularyVid::title
in drupal/
core/
modules/
taxonomy/
lib/
Drupal/
taxonomy/
Plugin/
views/
argument/
VocabularyVid.php
Override the behavior of title(). Get the name of the vocabulary.
_block_load_blocks
in drupal/
core/
modules/
block/
block.module
Loads blocks' information from the database.
_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.
_menu_build_tree
in drupal/
core/
includes/
menu.inc
Builds a menu tree.
_menu_link_find_parent
in drupal/
core/
includes/
menu.inc
Finds a possible parent for a given menu link.
_menu_update_parental_status
in drupal/
core/
includes/
menu.inc
Checks and updates the 'has_children' status for the parent of a link.