DrupalAPI.de

1. drupal
   1. drupal6
   2. drupal6 database.mysqli.inc
   3. drupal6 database.pgsql.inc
   4. drupal7 database.inc

Runs a limited-range query in the active database.

Use this as a substitute for db_query() when a subset of the query is to be returned. 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.

Übergabeparameter

$query A string containing an SQL query.

... A variable number of arguments which are substituted into the query using printf() syntax. The query arguments can be enclosed in one array instead. 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.

$from The first result row to return.

$count The maximum number of result rows to return.

Rückgabewert

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

Verwandte Themen

Database abstraction layer

Allow the use of different database servers using the same code base.

Code

includes/database.mysql.inc, line 238

<?php
function db_query_range($query) {
  $args = func_get_args();
  $count = array_pop($args);
  $from = array_pop($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);
  $query .= ' LIMIT ' . (int) $from . ', ' . (int) $count;
  return _db_query($query);
}
?>