Skip to main content
Hostdog docs
Documentation & API reference
Main menu
Drupal 7
Drupal 8
Drupal 9
You are here
Home
»
API reference
»
Drupal 7.x
»
database.inc
»
db_select
Search Drupal 7.x
Function, class, file, topic, etc.
*
Partial match search is supported
API Navigation
Drupal 7.x
Topics
Classes
Functions
Files
Namespaces
Constants
Globals
113 calls to db_select()
actions_do
in drupal/
includes/
actions.inc
Performs a given list of actions by executing their callback functions.
AggregatorUpdatePathTestCase::testAggregatorUpdate
in drupal/
modules/
simpletest/
tests/
upgrade/
update.aggregator.test
Tests that the
aggregator.module
update is successful.
aggregator_feed_items_load
in drupal/
modules/
aggregator/
aggregator.pages.inc
Loads and optionally filters feed items.
book_get_books
in drupal/
modules/
book/
book.module
Returns an array of all books.
book_menu_subtree_data
in drupal/
modules/
book/
book.module
Gets the data representing a subtree of the book hierarchy.
book_update_bid
in drupal/
modules/
book/
book.module
Updates the book ID of a page and its children when it moves to a new book.
comment_enable
in drupal/
modules/
comment/
comment.install
Implements
hook_enable
().
comment_form_validate
in drupal/
modules/
comment/
comment.module
Validate comment form submissions.
comment_get_display_ordinal
in drupal/
modules/
comment/
comment.module
Get the display ordinal for a comment, starting from 0.
comment_get_recent
in drupal/
modules/
comment/
comment.module
Find the most recent comments that are available to the current user.
comment_get_thread
in drupal/
modules/
comment/
comment.module
Retrieve comments for a thread.
comment_update_7006
in drupal/
modules/
comment/
comment.install
Migrate data from the comment field to field storage.
DatabaseAlterTestCase::testAlterChangeConditional
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can alter a query's conditionals.
DatabaseAlterTestCase::testAlterChangeFields
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can alter the fields of a query.
DatabaseAlterTestCase::testAlterExpression
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can alter expressions in the query.
DatabaseAlterTestCase::testAlterRemoveRange
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can remove a
range
() value from a query. This also tests
hook_query_TAG_alter
().
DatabaseAlterTestCase::testAlterWithJoin
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can alter the joins on a query.
DatabaseAlterTestCase::testSimpleAlter
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can do basic alters.
DatabaseAlterTestCase::testSimpleAlterSubquery
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can do basic alters on subqueries.
DatabaseInsertTestCase::testInsertSelectFields
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that the INSERT INTO ... SELECT (fields) ... syntax works.
DatabaseSelectCloneTest::testSelectConditionSubQueryCloning
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that subqueries as value within conditions are cloned properly.
DatabaseSelectComplexTestCase2::testJoinSubquery
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can join on a query.
DatabaseSelectComplexTestCase::testCountQuery
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can generate a count query from a built query.
DatabaseSelectComplexTestCase::testCountQueryDistinct
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can generate a count query from a query with distinct.
DatabaseSelectComplexTestCase::testCountQueryFieldRemovals
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that countQuery properly removes fields and expressions.
DatabaseSelectComplexTestCase::testCountQueryGroupBy
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can generate a count query from a query with GROUP BY.
DatabaseSelectComplexTestCase::testCountQueryRemovals
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that countQuery properly removes 'all_fields' statements and ordering clauses.
DatabaseSelectComplexTestCase::testDefaultJoin
in drupal/
modules/
simpletest/
tests/
database_test.test
Test simple JOIN statements.
DatabaseSelectComplexTestCase::testDistinct
in drupal/
modules/
simpletest/
tests/
database_test.test
Test distinct queries.
DatabaseSelectComplexTestCase::testGroupBy
in drupal/
modules/
simpletest/
tests/
database_test.test
Test GROUP BY clauses.
DatabaseSelectComplexTestCase::testGroupByAndHaving
in drupal/
modules/
simpletest/
tests/
database_test.test
Test GROUP BY and HAVING clauses together.
DatabaseSelectComplexTestCase::testLeftOuterJoin
in drupal/
modules/
simpletest/
tests/
database_test.test
Test LEFT OUTER joins.
DatabaseSelectComplexTestCase::testNestedConditions
in drupal/
modules/
simpletest/
tests/
database_test.test
Confirm that we can properly nest conditional clauses.
DatabaseSelectComplexTestCase::testRange
in drupal/
modules/
simpletest/
tests/
database_test.test
Test range queries. The SQL clause varies with the database.
DatabaseSelectOrderedTestCase::testSimpleSelectMultiOrdered
in drupal/
modules/
simpletest/
tests/
database_test.test
Test multiple order by.
DatabaseSelectOrderedTestCase::testSimpleSelectOrdered
in drupal/
modules/
simpletest/
tests/
database_test.test
Test basic order by.
DatabaseSelectOrderedTestCase::testSimpleSelectOrderedDesc
in drupal/
modules/
simpletest/
tests/
database_test.test
Test order by descending.
DatabaseSelectPagerDefaultTestCase::testInnerPagerQuery
in drupal/
modules/
simpletest/
tests/
database_test.test
Confirm that a pager query with inner pager query returns valid results.
DatabaseSelectSubqueryTestCase::testConditionSubquerySelect
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can use a subquery in a WHERE clause.
DatabaseSelectSubqueryTestCase::testFromSubquerySelect
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can use a subquery in a FROM clause.
DatabaseSelectSubqueryTestCase::testFromSubquerySelectWithLimit
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can use a subquery in a FROM clause with a limit.
DatabaseSelectSubqueryTestCase::testJoinSubquerySelect
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can use a subquery in a JOIN clause.
DatabaseSelectTestCase::testSelectDuplicateAlias
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that aliases are renamed when duplicates.
DatabaseSelectTestCase::testSimpleSelect
in drupal/
modules/
simpletest/
tests/
database_test.test
Test rudimentary SELECT statements.
DatabaseSelectTestCase::testSimpleSelectConditional
in drupal/
modules/
simpletest/
tests/
database_test.test
Test basic conditionals on SELECT statements.
DatabaseSelectTestCase::testSimpleSelectExpression
in drupal/
modules/
simpletest/
tests/
database_test.test
Test SELECT statements with expressions.
DatabaseSelectTestCase::testSimpleSelectExpressionMultiple
in drupal/
modules/
simpletest/
tests/
database_test.test
Test SELECT statements with multiple expressions.
DatabaseSerializeQueryTestCase::testSerializeQuery
in drupal/
modules/
simpletest/
tests/
database_test.test
Confirm that a query can be serialized and unserialized.
DatabaseTaggingTestCase::testHasAllTags
in drupal/
modules/
simpletest/
tests/
database_test.test
Test query tagging "has all of these tags" functionality.
DatabaseTaggingTestCase::testHasAnyTag
in drupal/
modules/
simpletest/
tests/
database_test.test
Test query tagging "has at least one of these tags" functionality.
DatabaseTaggingTestCase::testHasTag
in drupal/
modules/
simpletest/
tests/
database_test.test
Confirm that a query has a "tag" added to it.
DatabaseTaggingTestCase::testMetaData
in drupal/
modules/
simpletest/
tests/
database_test.test
Test that we can attach meta data to a query object.
database_test_even_pager_query
in drupal/
modules/
simpletest/
tests/
database_test.module
Run a pager query and return the results.
database_test_odd_pager_query
in drupal/
modules/
simpletest/
tests/
database_test.module
Run a pager query and return the results.
database_test_tablesort
in drupal/
modules/
simpletest/
tests/
database_test.module
Run a tablesort query and return the results.
database_test_tablesort_first
in drupal/
modules/
simpletest/
tests/
database_test.module
Run a tablesort query with a second order_by after and return the results.
database_test_theme_tablesort
in drupal/
modules/
simpletest/
tests/
database_test.module
Output a form without setting a header sort.
dblog_top
in drupal/
modules/
dblog/
dblog.admin.inc
Page callback: Shows the most frequent log messages of a given event type.
DrupalDatabaseCache::isEmpty
in drupal/
includes/
cache.inc
Implements
DrupalCacheInterface::isEmpty
().
DrupalDefaultEntityController::buildQuery
in drupal/
includes/
entity.inc
Builds the query to load the entity.
EntityFieldQuery::propertyQuery
in drupal/
includes/
entity.inc
Queries entity tables in SQL for property conditions and sorts.
field_read_fields
in drupal/
modules/
field/
field.crud.inc
Reads in fields that match an array of conditions.
field_read_instances
in drupal/
modules/
field/
field.crud.inc
Reads in field instances that match an array of conditions.
field_sql_storage_field_storage_query
in drupal/
modules/
field/
modules/
field_sql_storage/
field_sql_storage.module
Implements
hook_field_storage_query
().
file_space_used
in drupal/
includes/
file.inc
Determines total disk space used by a single user or the whole filesystem.
forum_forum_load
in drupal/
modules/
forum/
forum.module
Returns a tree of all forums for a given taxonomy term ID.
forum_get_topics
in drupal/
modules/
forum/
forum.module
Gets all the topics in a forum.
forum_node_load
in drupal/
modules/
forum/
forum.module
Implements
hook_node_load
().
forum_update_7001
in drupal/
modules/
forum/
forum.install
Create new {forum_index} table.
hook_field_storage_query
in drupal/
modules/
field/
field.api.php
Execute an EntityFieldQuery.
LocaleTranslationFunctionalTest::testJavaScriptTranslation
in drupal/
modules/
locale/
locale.test
locale_batch_by_language
in drupal/
includes/
locale.inc
Prepare a batch to import translations for all enabled modules in a given language.
menu_link_children_relative_depth
in drupal/
includes/
menu.inc
Finds the depth of an item's children relative to its depth.
menu_link_get_preferred
in drupal/
includes/
menu.inc
Looks up the preferred menu link for a given system path.
menu_link_load
in drupal/
includes/
menu.inc
Gets a translated, access-checked menu link that is ready for rendering.
menu_tree_check_access
in drupal/
includes/
menu.inc
Checks access and performs dynamic operations for each link in the tree.
node_access
in drupal/
modules/
node/
node.module
Determines whether the current user may perform the operation on the node.
node_access_view_all_nodes
in drupal/
modules/
node/
node.module
Determines whether the user has a global viewing grant for all nodes.
node_get_recent
in drupal/
modules/
node/
node.module
Finds the most recently changed nodes that are available to the current user.
node_update_7006
in drupal/
modules/
node/
node.install
Convert body and teaser from node properties to fields, and migrate status/comment/promote and sticky columns to the {node_revision} table.
path_load
in drupal/
includes/
path.inc
Fetches a specific URL alias from the database.
poll_block_view
in drupal/
modules/
poll/
poll.module
Implements
hook_block_view
().
poll_page
in drupal/
modules/
poll/
poll.pages.inc
Menu callback to provide a simple list of all polls available.
profile_field_form_validate
in drupal/
modules/
profile/
profile.admin.inc
Validate profile_field_form submissions.
SearchQuery::countQuery
in drupal/
modules/
search/
search.extender.inc
Builds the default count query for SearchQuery.
shortcut_current_displayed_set
in drupal/
modules/
shortcut/
shortcut.module
Returns the current displayed shortcut set for the provided user account.
statistics_title_list
in drupal/
modules/
statistics/
statistics.module
Returns the most viewed content of all time, today, or the last-viewed node.
statistics_top_pages
in drupal/
modules/
statistics/
statistics.admin.inc
Page callback: Displays statistics for the "top pages" (most accesses).
statistics_top_referrers
in drupal/
modules/
statistics/
statistics.admin.inc
Page callback: Displays the "top referrers" in the access logs.
statistics_top_visitors
in drupal/
modules/
statistics/
statistics.admin.inc
Page callback: Displays the "top visitors" page.
system_admin_menu_block
in drupal/
modules/
system/
system.module
Provide a single block on the administration overview page.
system_get_module_admin_tasks
in drupal/
modules/
system/
system.module
Generate a list of tasks offered by a specified module.
system_update_7061
in drupal/
modules/
system/
system.install
Migrate upload.module data to the newly created file field.
TaxonomyQueryAlterTestCase::testTaxonomyQueryAlter
in drupal/
modules/
taxonomy/
taxonomy.test
Tests that appropriate tags are added when querying the database.
taxonomy_autocomplete
in drupal/
modules/
taxonomy/
taxonomy.pages.inc
Page callback: Outputs JSON for taxonomy autocomplete suggestions.
taxonomy_get_children
in drupal/
modules/
taxonomy/
taxonomy.module
Finds all children of a term ID.
taxonomy_get_parents
in drupal/
modules/
taxonomy/
taxonomy.module
Finds all parents of a given term ID.
taxonomy_get_tree
in drupal/
modules/
taxonomy/
taxonomy.module
Create a hierarchical representation of a vocabulary.
taxonomy_select_nodes
in drupal/
modules/
taxonomy/
taxonomy.module
Return nodes attached to a term across all field instances.
taxonomy_tokens
in drupal/
modules/
taxonomy/
taxonomy.tokens.inc
Implements
hook_tokens
().
taxonomy_update_7005
in drupal/
modules/
taxonomy/
taxonomy.install
Migrate {taxonomy_term_node} table to field storage.
tracker_cron
in drupal/
modules/
tracker/
tracker.module
Implements
hook_cron
().
user_admin_account
in drupal/
modules/
user/
user.admin.inc
Form builder; User administration page.
user_roles
in drupal/
modules/
user/
user.module
Retrieve an array of roles matching specified conditions.
user_role_save
in drupal/
modules/
user/
user.module
Save a user role to the database.
_block_load_blocks
in drupal/
modules/
block/
block.module
Loads blocks' information from the database.
_forum_topics_unread
in drupal/
modules/
forum/
forum.module
Calculates the number of new posts in a forum that the user has not yet read.
_image_update_7002_populate_dimensions
in drupal/
modules/
image/
image.install
Populate image dimensions in a specific table.
_locale_translate_seek
in drupal/
includes/
locale.inc
Perform a string search and display results in a table
_menu_build_tree
in drupal/
includes/
menu.inc
Builds a menu tree.
_menu_link_find_parent
in drupal/
includes/
menu.inc
Finds a possible parent for a given menu link.
_menu_update_parental_status
in drupal/
includes/
menu.inc
Checks and updates the 'has_children' status for the parent of a link.
_profile_get_fields
in drupal/
modules/
profile/
profile.module