Previous Page
fetchPairs()

Solar_Model
fetchValue()

Next Page
fixSelectParams()

fetchValue()

public mixed fetchValue ( array $params default array () )

Fetches a single value from the model (i.e., the first column of the first record of the returned page set).

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

  • (mixed) The single value from the model query, or null.

Description

Fetches a single value from the model (i.e., the first column of the first record of the returned page set).

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; only the first one will be honored.
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 elements from this page-number.
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.