abstract public function DatabaseConnection::queryRange

Runs a limited-range query on this database object.

Use this as a substitute for ->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.

Parameters

$query: A string containing an SQL query.

$args: An array of values to substitute into the query at placeholder markers.

$from: The first result row to return.

$count: The maximum number of result rows to return.

$options: An array of options on the query.

Return value

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

3 methods override DatabaseConnection::queryRange()
DatabaseConnection_mysql::queryRange in drupal/includes/database/mysql/database.inc
Runs a limited-range query on this database object.
DatabaseConnection_pgsql::queryRange in drupal/includes/database/pgsql/database.inc
Runs a limited-range query on this database object.
DatabaseConnection_sqlite::queryRange in drupal/includes/database/sqlite/database.inc
Runs a limited-range query on this database object.

File

drupal/includes/database/database.inc, line 1204
Core systems for the database layer.

Class

DatabaseConnection
Base Database API class.

Code

public abstract function queryRange($query, $from, $count, array $args = array(), array $options = array());