Same name and namespace in other branches
  1. 4.6.x includes/database.inc \db_query()
  2. 5.x includes/database.inc \db_query()
  3. 6.x includes/database.pgsql.inc \db_query()
  4. 6.x includes/database.mysql-common.inc \db_query()
  5. 7.x includes/database/database.inc \db_query()
  6. 8.9.x core/includes/database.inc \db_query()

Runs a basic query in the active database.

User-supplied arguments to the query should be passed in as separate parameters so that they can be properly escaped to avoid SQL injection attacks.

Parameters

$query: A string containing an SQL query.

...: A variable number of arguments which are substituted into the query using printf() syntax. Instead of a variable number of query arguments, you may also pass a single array containing the query arguments.

Valid %-modifiers are: %s, %d, %f, %b (binary data, do not enclose in '') and %%.

NOTE: using this syntax will cast NULL and FALSE values to decimal 0, and TRUE values to decimal 1.

Return value

A database query result resource, or FALSE if the query was not executed correctly.

Related topics

280 calls to db_query()
aggregator_block in modules/aggregator.module
Implementation of hook_block().
aggregator_cron in modules/aggregator.module
Implementation of hook_cron().
aggregator_form_category_validate in modules/aggregator.module
Validate aggregator_form_feed form submissions.
aggregator_form_feed in modules/aggregator.module
Generate a form to add/edit feed sources.
aggregator_form_feed_validate in modules/aggregator.module
Validate aggregator_form_feed form submissions.

... See full list

File

includes/database.inc, line 188
Wrapper for database interface code.

Code

function db_query($query) {
  $args = func_get_args();
  array_shift($args);
  $query = db_prefix_tables($query);
  if (isset($args[0]) and is_array($args[0])) {

    // 'All arguments in one array' syntax
    $args = $args[0];
  }
  _db_query_callback($args, TRUE);
  $query = preg_replace_callback(DB_QUERY_REGEXP, '_db_query_callback', $query);
  return _db_query($query);
}