JDatabaseQueryLimitable
Joomla Database Query Limitable Interface.
Adds bind/unbind methods as well as a getBounded() method to retrieve the stored bounded variables on demand prior to query execution.
since |
3.0.0 |
---|---|
package |
Joomla.Platform |
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. This method is used automatically by the __toString() method if it detects that the query implements the JDatabaseQueryLimitable interface.
processLimit(string $query, integer $limit, integer $offset) : string
since |
3.0.0 |
---|
Arguments
- $query
string
The query in string format- $limit
integer
The limit for the result set- $offset
integer
The offset for the result set
Response
string
setLimit
Sets the offset and limit for the result set, if the database driver supports it.
setLimit(integer $limit, integer $offset) : \JDatabaseQuery
Usage: $query->setLimit(100, 0); (retrieve 100 rows, starting at first record) $query->setLimit(50, 50); (retrieve 50 rows, starting at 50th record)
since |
3.0.0 |
---|
Arguments
- $limit
integer
The limit for the result set- $offset
integer
The offset for the result set
Response
\JDatabaseQuery
Returns this object to allow chaining.