LimitableInterface
interface LimitableInterface (View source)
Windwalker Query LimitableInterface.
Adds bind/unbind methods as well as a getBounded() method to retrieve the stored bounded variables on demand prior to query execution.
Methods
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 LimitableInterface.
Sets the offset and limit for the result set, if the database driver supports it.
Details
at line line 37
string
processLimit(string $query, integer $limit, integer $offset)
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 LimitableInterface.
at line line 53
LimitableInterface
setLimit(integer $limit, integer $offset)
Sets the offset and limit for the result set, if the database driver supports it.
Usage: $query->setLimit(100, 0); (retrieve 100 rows, starting at first record) $query->setLimit(50, 50); (retrieve 50 rows, starting at 50th record)