function Connection::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
string $query: A string containing an SQL query.
int $from: The first result row to return.
int $count: The maximum number of result rows to return.
array $args: (optional) An array of values to substitute into the query at placeholder markers.
array $options: (optional) An array of options on the query.
Return value
\Drupal\Core\Database\StatementInterface A database query result resource, or NULL if the query was not executed correctly.
5 methods override Connection::queryRange()
- Connection::queryRange in core/
modules/ sqlite/ src/ Driver/ Database/ sqlite/ Connection.php - Runs a limited-range query on this database object.
- Connection::queryRange in core/
modules/ mysql/ src/ Driver/ Database/ mysql/ Connection.php - Runs a limited-range query on this database object.
- Connection::queryRange in core/
modules/ pgsql/ src/ Driver/ Database/ pgsql/ Connection.php - Runs a limited-range query on this database object.
- Connection::queryRange in core/
tests/ fixtures/ database_drivers/ custom/ fake/ Connection.php - Runs a limited-range query on this database object.
- StubConnection::queryRange in core/
tests/ Drupal/ Tests/ Core/ Database/ Stub/ StubConnection.php - Runs a limited-range query on this database object.
File
-
core/
lib/ Drupal/ Core/ Database/ Connection.php, line 1777
Class
- Connection
- Base Database API class.
Namespace
Drupal\Core\DatabaseCode
abstract public function queryRange($query, $from, $count, array $args = [], array $options = []);
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.