⌂ 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::get_row()

The get_row method executes an assembled query like get_rows(), except only the first row is returned, instead of the entire rowset.

Prototype

get_row(array $options = []): object

Parameters

options - An associative array with zero or more of the following key/value pairs.
- checksum - If TRUE, a checksum unique to the resulting collection will be made available for retrieval with collection::get_result_checksum(). Otherwise do not produce a checksum (default).
- checksum_only - If TRUE, only produce the checksum, and do not return the results. This is the most efficient way to produce a checksum if you do not need the results.
- bind - An array of values to bind to ? placeholders, or an associative array of keys and values to bind to :key placeholders. As an alternative, call bind().

Return

The first object from the query results, NULL if not results, or FALSE if there was an error.

Example (Chained)

// create, assemble and execute the query as one chained statement
$contact = $repo->query()
	->select('Name', 'Phone');
	->from('Contact');
	->where('Name', 'John');
	->get_row();

print($contact['Name'] . ": " . $contact['Phone'] . "\n");

Example (Long-hand)

// create and assemble the query, one clause at a time
$query = $repo->query();
$query->select('Name', 'Phone');
$query->from('Contact');
$query->where('Name', 'John');

// execute the query assembled above
$contact = $query->get_row();
print($contact->Name . ": " . $contact->Phone . "\n");