• ⌂ query
• Methods
  • and_where()
  • bind()
  • Constructor
  • from()
  • get()
  • get_first()
  • get_row()
  • get_rows()
  • group_by()
  • in()
  • limit()
  • limit_again()
  • order_by()
  • or_where()
  • or_where_in()
  • or_where_not_in()
  • or_where_null()
  • select()
  • where()
  • where_in()
  • where_not_in()
  • where_null()

query::limit()

Sets the LIMIT clause to limit the number of query results.

Prototype

limit(int $count): query
limit(int $offset, int $count): query
limit(array $offset_count): query

Parameters

The following parameters may be passed in any of the forms listed above.

• count - Restrict the number of results to count items.  Set to zero (0) to "unset" an existing limit, so there will no longer be a limit.
• offset - Exclude/skip rows before offset.
• offset_count - array containing [$count] or [$offset, $count].

Return

The updated query object is returned.  This is handy for chaining additional methods.

Example

// limit results to the second "page"
$page = 2;
$items_per_page = 10;
$offset = $page * $items_per_page;
$query->limit($offset, $items_per_page);

// same as above, but passed as array
$query->limit([$offset, $items_per_page]);

// limit to the first 12 items
$query->limit(12);

• < in()
• limit_again() >