Previous Page
fetchAll()

Solar_Example_Model_Areas
fetchArray()

Next Page
fetchAssoc()

fetchArray()

public array fetchArray ( array $params default array () )

Fetches an array of rows by arbitrary parameters.

Inherited from Solar_Sql_Model.

Parameters

  • (array) $params: An array of parameters for the fetch, with keys for 'cols', 'where', 'group', 'having', 'order', etc.

Returns

  • (array)

Description

Fetches an array of rows by arbitrary parameters.

Recognized parameters for the fetch are:

eager
(string|array) Eager-fetch records from these related models.
distinct
(bool) Use DISTINCT?
cols
(string|array) Return only these columns.
where
(string|array) A Solar_Sql_Select::multiWhere() value parameter to restrict which records are returned.
group
(string|array) GROUP BY these columns.
having
(string|array) HAVING these column values.
order
(string|array) ORDER BY these columns.
paging
(int) Return this many records per page.
page
(int) Return only records from this page-number.
limit
(int|array) Limit to a count of this many records (when an integer), or limit by count and offset (when an array). When limit is non- empty, the page and paging params are ignored.
bind
(array) Key-value pairs to bind into the query.
cache
(bool) Use the cache?
cache_key
(bool) An explicit cache key to use; otherwise, defaults to the serialized SELECT params.