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 includes/
database/ mysql/ database.inc - Runs a limited-range query on this database object.
- DatabaseConnection_pgsql::queryRange in includes/
database/ pgsql/ database.inc - Runs a limited-range query on this database object.
- DatabaseConnection_sqlite::queryRange in includes/
database/ sqlite/ database.inc - Runs a limited-range query on this database object.
File
-
includes/
database/ database.inc, line 1251
Class
- DatabaseConnection
- Base Database API class.
Code
public abstract function queryRange($query, $from, $count, array $args = array(), array $options = array());
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.