LimitableInterface
Joomla Database Query LimitableInterface.
deprecated
| since |
1.0 |
|---|---|
| deprecated |
3.0 Capabilities will be required in Joomla\Database\QueryInterface |
| package |
Joomla Framework |
Methods
processLimit
Method to modify a query already in string format with the needed additions to make the query limited to a particular number of results, or start at a particular offset.
processLimit(string query, int limit, int offset) : string
| since |
1.0 |
|---|
Arguments
- query
stringThe query in string format- limit
intThe limit for the result set- offset
intThe offset for the result set
Response
string
setLimit
Sets the offset and limit for the result set, if the database driver supports it.
setLimit(int limit, int offset) : $this
Usage: $query->setLimit(100, 0); (retrieve 100 rows, starting at first record) $query->setLimit(50, 50); (retrieve 50 rows, starting at 50th record)
| since |
1.0 |
|---|
Arguments
- limit
intThe limit for the result set- offset
intThe offset for the result set
Response
$this