db_query

Related topics

Namesort iconDescription
Database abstraction layerAllow the use of different database servers using the same code base.

Functions that call db_query()

Namesort iconLocationDescription
aggregator_blockmodules/aggregator.moduleImplementation of hook_block().
aggregator_cronmodules/aggregator.moduleImplementation of hook_cron().
aggregator_form_category_validatemodules/aggregator.moduleValidate aggregator_form_feed form submissions.
aggregator_form_feedmodules/aggregator.moduleGenerate a form to add/edit feed sources.
aggregator_form_feed_validatemodules/aggregator.moduleValidate aggregator_form_feed form submissions.
aggregator_menumodules/aggregator.moduleImplementation of hook_menu().
aggregator_page_categoriesmodules/aggregator.moduleMenu callback; displays all the categories used by the aggregator.
aggregator_page_categorymodules/aggregator.moduleMenu callback; displays all the items aggregated in a particular category.
aggregator_page_opmlmodules/aggregator.moduleMenu callback; generates an OPML representation of all feeds.
aggregator_page_rssmodules/aggregator.moduleMenu callback; generate an RSS 0.92 feed of aggregator items or categories.
aggregator_page_sourcemodules/aggregator.moduleMenu callback; displays all the items captured from a particular feed.
aggregator_page_sourcesmodules/aggregator.moduleMenu callback; displays all the feeds used by the aggregator.
aggregator_refreshmodules/aggregator.moduleChecks a news feed for new items.
aggregator_save_categorymodules/aggregator.moduleAdd/edit/delete aggregator categories.
aggregator_save_feedmodules/aggregator.moduleAdd/edit/delete an aggregator feed.
archive_calendarmodules/archive.moduleGenerates a monthly calendar, for display in the archive block.
block_admin_configuremodules/block.moduleMenu callback; displays the block configuration form.
block_admin_display_submitmodules/block.moduleProcess main block administration form submission.
block_blockmodules/block.moduleImplementation of hook_block().
block_box_delete_confirm_submitmodules/block.moduleDeletion of custom blocks.
block_listmodules/block.moduleReturn all blocks in the specified region for the current user.
block_usermodules/block.moduleImplementation of hook_user().
blog_formmodules/blog.moduleImplementation of hook_form().
book_admin_orphanmodules/book.moduleMenu callback; displays a listing of all orphaned book pages.
book_admin_overviewmodules/book.moduleReturns an administrative overview of all books.
book_blockmodules/book.moduleImplementation of hook_block().
book_deletemodules/book.moduleImplementation of hook_delete().
book_exportmodules/book.moduleMenu callback; Generates various representation of a book page with all descendants and prints the requested representation to output.
book_insertmodules/book.moduleImplementation of hook_insert().
book_loadmodules/book.moduleImplementation of hook_load().
book_locationmodules/book.moduleGiven a node, this function returns an array of 'book node' objects representing the path in the book tree from the root to the parent of the given node.
book_location_downmodules/book.moduleGiven a node, this function returns an array of 'book node' objects representing the path in the book tree from the given node down to the last sibling of it.
book_menumodules/book.moduleImplementation of hook_menu().
book_nextmodules/book.moduleFetches the node object of the next page of the book.
book_nodeapimodules/book.moduleImplementation of hook_nodeapi().
book_outline_submitmodules/book.moduleHandles book outline form submissions.
book_prevmodules/book.moduleFetches the node object of the previous page of the book.
book_recursemodules/book.moduleTraverses the book tree. Applies the $visit_pre() callback to each node, is called recursively for each child of the node (in weight, title order). Finally appends the output of the $visit_post() callback to the output before returning the generated...
book_rendermodules/book.moduleMenu callback; prints a listing of all books.
book_tocmodules/book.moduleReturns an array of titles and nid entries of book pages in table of contents order.
book_treemodules/book.moduleReturns an HTML nested list (wrapped in a menu-class div) representing the book nodes as a tree.
book_updatemodules/book.moduleImplementation of hook_update().
cache_clear_allincludes/bootstrap.incExpire data from the cache.
cache_getincludes/bootstrap.incReturn data from the persistent cache.
cache_setincludes/bootstrap.incStore data in the persistent cache.
comment_admin_overview_submitmodules/comment.moduleExecute the chosen 'Update option' on the selected comments, such as publishing, unpublishing or deleting.
comment_deletemodules/comment.moduleMenu callback; delete a comment.
comment_multiple_delete_confirmmodules/comment.moduleList the selected comments and verify that the admin really wants to delete them.
comment_nodeapimodules/comment.moduleImplementation of hook_nodeapi().
comment_num_newmodules/comment.moduleget number of new comments for current user and specified node
comment_savemodules/comment.moduleAccepts a submission of new or changed comment content.
comment_usermodules/comment.moduleImplementation of hook_user().
contact_admin_categoriesmodules/contact.moduleCategories/list tab.
contact_admin_deletemodules/contact.moduleCategory delete page.
contact_admin_delete_submitmodules/contact.moduleProcess category delete form submission.
contact_admin_editmodules/contact.moduleCategory edit page.
contact_admin_edit_submitmodules/contact.moduleProcess the contact category edit page form submission.
contact_mail_pagemodules/contact.moduleSite-wide contact page
contact_mail_page_submitmodules/contact.moduleProcess the site-wide contact page form submission.
db_check_setupincludes/database.pgsql.incVerify if the database is set up correctly.
db_lock_tableincludes/database.pgsql.incLock a table. This function automatically starts a transaction.
db_next_idincludes/database.pgsql.incReturn a new unique ID in the given sequence.
db_queryincludes/database.incRuns a basic query in the active database.
db_unlock_tablesincludes/database.pgsql.incUnlock all locked tables. This function automatically commits a transaction.
do_searchmodules/search.moduleDo a query on the full-text search index for a word or words.
drupal_client_pagemodules/drupal.moduleFormats a list of all clients.
drupal_client_pingmodules/drupal.moduleCallback function from drupal_xmlrpc() called when another site pings this one.
drupal_cronmodules/drupal.moduleImplementation of hook_cron(); handles pings to and from the site.
drupal_get_filenameincludes/bootstrap.incReturns and optionally sets the filename for a system item (module, theme, etc.). The filename, whether provided, cached, or retrieved from the database, is only returned if the file exists.
drupal_get_installed_schema_versionincludes/install.incReturns the currently installed schema version for a module.
drupal_is_deniedincludes/bootstrap.incPerform an access check for a given mask and rule type. Rules are usually created via admin/access/rules page.
drupal_lookup_pathincludes/path.incGiven an alias, return its Drupal system URL if one exists. Given a Drupal system URL return its alias if one exists.
drupal_notifymodules/drupal.moduleSends a ping to the Drupal directory server.
drupal_set_installed_schema_versionincludes/install.incUpdate the installed version information for a module.
fileupload_deletedeveloper/examples/fileupload.moduleImplementation of hook_delete().
fileupload_file_downloaddeveloper/examples/fileupload.moduleImplementation of hook_file_download.
fileupload_insertdeveloper/examples/fileupload.moduleImplementation of hook_insert().
fileupload_loaddeveloper/examples/fileupload.moduleImplementation of hook_load().
fileupload_updatedeveloper/examples/fileupload.moduleImplementation of hook_update().
filter_admin_deletemodules/filter.moduleMenu callback; confirm deletion of a format.
filter_admin_delete_submitmodules/filter.moduleProcess filter delete form submission.
filter_admin_format_form_submitmodules/filter.moduleProcess filter format form submissions.
filter_admin_format_form_validatemodules/filter.moduleValidate filter format form submissions.
filter_admin_order_submitmodules/filter.moduleProcess filter order configuration form submission.
filter_formatsmodules/filter.moduleRetrieve a list of input formats.
filter_format_allowcachemodules/filter.moduleCheck if text in a certain input format is allowed to be cached.
filter_list_formatmodules/filter.moduleRetrieve a list of filters for a certain format.
flood_is_allowedincludes/common.incCheck if the current visitor (hostname/IP) is allowed to proceed with the specified event. The user is allowed to proceed if he did not trigger the specified event more than $threshold times per hour.
flood_register_eventincludes/common.incRegister an event for the current visitor (hostname/IP) to the flood control mechanism.
forum_deletemodules/forum.moduleImplementation of hook_delete().
forum_get_forumsmodules/forum.moduleReturns a list of all forums for a given taxonomy id
forum_insertmodules/forum.moduleImplementation of hook_insert().
forum_loadmodules/forum.moduleImplementation of hook_load().
forum_nodeapimodules/forum.moduleImplementation of hook_nodeapi().
forum_taxonomymodules/forum.moduleImplementation of hook_taxonomy().
forum_updatemodules/forum.moduleImplementation of hook_update().
forum_validatemodules/forum.moduleImplementation of hook_validate().
hook_crondeveloper/hooks/core.phpPerform periodic actions.
hook_deletedeveloper/hooks/node.phpRespond to node deletion.
hook_exitdeveloper/hooks/core.phpPerform cleanup tasks.
hook_file_downloaddeveloper/hooks/core.phpAllow file downloads.
hook_initdeveloper/hooks/core.phpPerform setup tasks.
hook_insertdeveloper/hooks/node.phpRespond to node insertion.
hook_installdeveloper/hooks/install.phpInstall the current version of the database schema.
hook_loaddeveloper/hooks/node.phpLoad node-type-specific information.
hook_updatedeveloper/hooks/node.phpRespond to node updating.
list_themesincludes/theme.incProvides a list of currently available themes.
list_theme_enginesincludes/theme.incProvides a list of currently available theme engines
localemodules/locale.moduleProvides interface translation services.
locale_add_language_form_validateincludes/locale.incValidate the language addition form.
locale_admin_manage_delete_form_submitmodules/locale.moduleProcess language deletion submissions.
locale_admin_string_deletemodules/locale.moduleDelete a string.
locale_refresh_cachemodules/locale.moduleRefreshes database stored cache of translations.
locale_supported_languagesmodules/locale.moduleReturns list of languages supported on this site.
menu_delete_itemmodules/menu.moduleDelete a menu item from the database. If $item['mid'] is specified, then this is used to find the existing item; otherwise, $item['path'] is used.
menu_edit_item_formmodules/menu.modulePresent the menu item editing form.
menu_edit_menu_formmodules/menu.moduleMenu callback; handle the adding/editing of a new menu.
menu_form_altermodules/menu.moduleImplementation of hook_form_alter(). Add menu item fields to the node form.
menu_item_delete_formmodules/menu.moduleMenu callback; delete a single custom item.
menu_reset_itemmodules/menu.moduleMenu callback; reset a single modified item.
menu_save_itemmodules/menu.moduleSave a menu item to the database.
module_listincludes/module.incCollect a list of all loaded modules. During the bootstrap, return only vital modules. See bootstrap.inc
nodeapi_example_nodeapideveloper/examples/nodeapi_example.moduleImplementation of hook_nodeapi().
node_accessmodules/node.moduleDetermine whether the current user may perform the given operation on the specified node.
node_access_example_form_alterdeveloper/examples/node_access_example.moduleImplementation of hook_form_alter().
node_access_example_nodeapideveloper/examples/node_access_example.moduleImplementation of hook_nodeapi().
node_access_view_all_nodesmodules/node.moduleDetermine whether the user has a global viewing grant for all nodes.
node_admin_nodes_submitmodules/node.moduleGenerate the content administration overview.
node_comment_modemodules/node.moduleRetrieve the comment mode for the given node ID (none, read, or read/write).
node_cronmodules/node.moduleImplementation of hook_cron().
node_deletemodules/node.moduleDelete a node.
node_example_deletedeveloper/examples/node_example.moduleImplementation of hook_delete().
node_example_insertdeveloper/examples/node_example.moduleImplementation of hook_insert().
node_example_loaddeveloper/examples/node_example.moduleImplementation of hook_load().
node_example_nodeapideveloper/examples/node_example.moduleImplementation of hook_nodeapi().
node_example_updatedeveloper/examples/node_example.moduleImplementation of hook_update().
node_last_viewedmodules/node.moduleRetrieves the timestamp at which the current user last viewed the specified node.
node_loadmodules/node.moduleLoad a node object from the database.
node_menumodules/node.moduleImplementation of hook_menu().
node_pagemodules/node.moduleMenu callback; dispatches control to the appropriate operation handler.
node_revision_deletemodules/node.moduleDelete the revision with specified revision number. A "delete revision" nodeapi event is invoked when a revision is deleted.
node_revision_listmodules/node.moduleReturn a list of all the existing revision numbers.
node_savemodules/node.moduleSave a node object into the database.
node_searchmodules/node.moduleImplementation of hook_search().
node_tag_newmodules/node.moduleUpdate the 'last viewed' timestamp of the specified node for current user.
node_update_indexmodules/node.moduleImplementation of hook_update_index().
node_usermodules/node.moduleImplementation of hook_user().
pager_queryincludes/pager.incPerform a paged database query.
path_admin_deletemodules/path.modulePost-confirmation; delete an URL alias.
path_form_altermodules/path.moduleImplementation of hook_form_alter().
path_form_validatemodules/path.moduleVerify that URL alias is valid.
path_loadmodules/path.moduleFetch a specific URL alias from the database.
path_nodeapimodules/path.moduleImplementation of hook_nodeapi().
path_set_aliasmodules/path.moduleSet an aliased path for a given Drupal path, preventing duplicates.
ping_cronmodules/ping.moduleImplementation of hook_cron().
poll_blockmodules/poll.moduleImplementation of hook_block().
poll_cronmodules/poll.moduleImplementation of hook_cron().
poll_deletemodules/poll.moduleImplementation of hook_delete().
poll_loadmodules/poll.moduleImplementation of hook_load().
poll_updatemodules/poll.moduleImplementation of hook_update().
poll_usermodules/poll.moduleImplementation of hook_user().
poll_votemodules/poll.moduleCallback for processing a vote
profile_admin_overviewmodules/profile.moduleMenu callback; display a listing of all editable profile fields.
profile_blockmodules/profile.moduleImplementation of hook_block().
profile_browsemodules/profile.moduleMenu callback; display a list of user information.
profile_field_deletemodules/profile.moduleMenu callback; deletes a field from all user profiles.
profile_field_delete_submitmodules/profile.moduleProcess a field delete form submission.
profile_field_formmodules/profile.moduleMenu callback: Generate a form to add/edit a user profile field.
profile_field_form_submitmodules/profile.moduleProcess profile_field_form submissions.
profile_field_form_validatemodules/profile.moduleValidate profile_field_form submissions.
profile_usermodules/profile.moduleImplementation of hook_user().
search_indexmodules/search.moduleUpdate the full-text search index for a particular item.
search_update_totalsmodules/search.moduleThis function is called on shutdown to ensure that search_total is always up to date (even if cron times out or otherwise fails).
search_wipemodules/search.moduleWipes a part of or the entire search index.
sess_regenerateincludes/session.incCalled when an anonymous user becomes authenticated or vice-versa.
statistics_cronmodules/statistics.moduleImplementation of hook_cron().
statistics_exitmodules/statistics.moduleImplementation of hook_exit().
statistics_getmodules/statistics.moduleRetrieves a node's "view statistics".
statistics_nodeapimodules/statistics.moduleImplementation of hook_nodeapi().
statistics_usermodules/statistics.moduleImplementation of hook_user().
system_get_files_databasemodules/system.moduleRetrieves the current status of an array of files in the system table.
system_initialize_theme_blocksmodules/system.moduleAssign an initial, default set of blocks for a theme.
system_modulesmodules/system.moduleMenu callback; displays a listing of all modules.
system_region_listmodules/system.moduleGet a list of available regions from a specified theme.
system_theme_datamodules/system.moduleCollect data about all currently available themes
system_update_159database/updates.incRetrieve data out of the old_revisions table and put into new revision system.
system_update_178database/updates.incUpdate base paths for relative URLs in node and comment content.
system_update_179database/updates.incUpdate base paths for relative URLs in custom blocks, profiles and various variables.
taxonomy_form_altermodules/taxonomy.moduleGenerate a form for selecting terms to associate with a node.
taxonomy_get_childrenmodules/taxonomy.moduleFind all children of a term ID.
taxonomy_get_parentsmodules/taxonomy.moduleFind all parents of a given term ID.
taxonomy_get_relatedmodules/taxonomy.moduleFind all term objects related to a given term ID.
taxonomy_get_synonymsmodules/taxonomy.moduleReturn an array of synonyms of the given term ID.
taxonomy_get_synonym_rootmodules/taxonomy.moduleReturn the term object that has the given string as a synonym.
taxonomy_get_termmodules/taxonomy.moduleReturn the term object matching a term ID.
taxonomy_get_term_by_namemodules/taxonomy.moduleTry to map a string to an existing term, as for glossary use.
taxonomy_get_treemodules/taxonomy.moduleCreate a hierarchical representation of a vocabulary.
taxonomy_get_vocabulariesmodules/taxonomy.moduleReturn an array of all vocabulary objects.
taxonomy_get_vocabularymodules/taxonomy.moduleReturn the vocabulary object matching a vocabulary ID.
taxonomy_node_deletemodules/taxonomy.moduleRemove associations of a node to its terms.
taxonomy_node_get_termsmodules/taxonomy.moduleFind all terms associated to the given node, ordered by vocabulary and term weight.
taxonomy_node_get_terms_by_vocabularymodules/taxonomy.moduleFind all terms associated to the given node, within one vocabulary.
taxonomy_node_savemodules/taxonomy.moduleSave term associations for a given node.
taxonomy_term_count_nodesmodules/taxonomy.moduleGiven a term id, count the number of published nodes in it.
taxonomy_term_pagemodules/taxonomy.moduleMenu callback; displays all nodes associated with a term.
theme_aggregator_page_itemmodules/aggregator.moduleFormat an individual feed item for display on the aggregator page.
theme_forum_topic_navigationmodules/forum.moduleFormat the next/previous forum topic navigation links.
throttle_exitmodules/throttle.moduleImplementation of hook_exit().
update_convert_table_utf8update.phpConvert a single MySQL table to UTF-8.
update_do_updatesupdate.phpPerform updates for one second or until finished.
update_fix_schema_versionupdate.phpIf the schema version for Drupal core is stored in the variables table (4.6.x and earlier) move it to the schema_version column of the system table.
update_fix_sessionsupdate.phpSystem update 130 changes the sessions table, which breaks the update script's ability to use session variables. This changes the table appropriately.
update_fix_watchdogupdate.phpSystem update 142 changes the watchdog table, which breaks the update script's ability to use logging. This changes the table appropriately.
upload_space_usedmodules/upload.moduleDetermine how much disk space is occupied by a user's uploaded files.
upload_total_space_usedmodules/upload.moduleDetermine how much disk space is occupied by uploaded files.
user_accessmodules/user.moduleDetermine whether the user has a given privilege.
user_admin_accessmodules/user.moduleMenu callback: list all access rules
user_admin_access_addmodules/user.moduleMenu callback: add an access rule
user_admin_access_deletemodules/user.moduleMenu callback: delete an access rule
user_admin_access_editmodules/user.moduleMenu callback: edit an access rule
user_admin_permmodules/user.moduleMenu callback: administer permissions.
user_admin_rolemodules/user.moduleMenu callback: administer roles.
user_blockmodules/user.moduleImplementation of hook_block().
user_get_authmapsmodules/user.moduleAccepts an user object, $account, or a DA name and returns an associative array of modules and DA names. Called at external login.
user_is_blockedmodules/user.moduleChecks for usernames blocked by user administration
user_loadmodules/user.moduleFetch a user object.
user_pass_resetmodules/user.moduleMenu callback; process one time login link and redirects to the user page on success.
user_rolesmodules/user.moduleRetrieve an array of roles matching specified conditions.
user_savemodules/user.moduleSave changes to a user account or add a new user.
variable_delincludes/bootstrap.incUnset a persistent variable.
variable_initincludes/bootstrap.incLoad the persistent variable table.
variable_setincludes/bootstrap.incSet a persistent variable.
watchdogincludes/bootstrap.incLog a system message.
watchdog_cronmodules/watchdog.moduleImplementation of hook_cron().
watchdog_eventmodules/watchdog.moduleMenu callback; displays details about a log message.
watchdog_usermodules/watchdog.moduleImplementation of hook_user().
_aggregator_page_listmodules/aggregator.modulePrints an aggregator page listing a number of feed items. Various menu callbacks use this function to print their feeds.
_block_rehashmodules/block.moduleUpdate the 'blocks' DB table with the blocks currently exported by modules.
_comment_loadmodules/comment.moduleLoad the entire comment by cid.
_comment_update_node_statisticsmodules/comment.moduleUpdates the comment statistics for a given node. This should be called any time a comment is added, deleted, or updated.
_filter_tipsmodules/filter.moduleHelper function for fetching filter tips.
_forum_get_vidmodules/forum.moduleReturns the vocabulary id for forum navigation.
_forum_topics_unreadmodules/forum.moduleCalculate the number of nodes the user has not yet read and are newer than NODE_NEW_LIMIT.
_locale_add_languageincludes/locale.incHelper function to add a language
_locale_admin_manage_screenincludes/locale.incUser interface for the language management screen.
_locale_admin_manage_screen_submitincludes/locale.incProcess locale admin manager form submissions.
_locale_export_poincludes/locale.incExports a Portable Object (Template) file for a language
_locale_import_one_stringincludes/locale.incImports a string into the database
_locale_import_poincludes/locale.incParses Gettext Portable Object file information and inserts into database
_locale_string_deleteincludes/locale.incDelete a language string.
_locale_string_editincludes/locale.incUser interface for string editing.
_locale_string_edit_submitincludes/locale.incProcess string editing form submissions. Saves all translations of one string submitted from a form.
_menu_buildincludes/menu.incBuild the menu by querying both modules and the database.
_system_update_utf8database/updates.incConverts a set of tables to UTF-8 encoding.
_taxonomy_term_childrenmodules/taxonomy.moduleHelper for taxonomy_term_count_nodes().

Functions called by db_query()

Namesort iconLocationDescription
db_prefix_tablesincludes/database.incAppend a database prefix to all tables in a query.
db_queryincludes/database.incRuns a basic query in the active database.
_db_queryincludes/database.pgsql.incHelper function for db_query().
_db_query_callbackincludes/database.incHelper function for db_query().
 
 

All source code and documentation on this site is released under the terms of the GNU General Public License, version 2 and later. Drupal is a registered trademark of Dries Buytaert.