• ⌂ repo
• Methods
  • Constructor
  • execute()
  • get()
  • get_content_type()
  • get_first()
  • get_object()
  • get_object_by_id()
  • get_object_by_oid()
  • get_object_by_doid()
  • get_object_by_uuid()
  • get_objects_by_id()
  • get_objects_by_oid()
  • get_objects_by_doid()
  • get_objects_by_uuid()
  • get_root()
  • get_row()
  • get_rows()
  • get_system_property()
  • log_alert()
  • log_critical()
  • log_to_file()
  • log_to_html()
  • new_collection()
  • new_object()
  • peek_user()
  • pop_user()
  • push_super_user()
  • push_user()
  • query()
  • supports_dimensions()
  • switch_user()
  • uninit()
  • with()

repo::get_row()

Perform a query and return the first matching object's field values in an associative array, like a row in a row set.

Prototype

array get_row(mixed $query, array $options = [])

Parameters

• query - Query Array, Query Object or cQL string.
• options
  • bind - Array of variables to bind to the query.  If the binding is a question mark (ie. ?), the array index is an index to the question mark (first question mark is represented by index zero, etc.).  If the binding is a named binding (ie. :Name), the array index is the binding name.

Return

An associative array of field values of the first object to match the query, otherwise NULL.

Example

$contacts = $repo->get_row("SELECT Name, Phone FROM Contact WHERE Name='John'");
echo($contact['Name'] . " - " . $contact['Phone'] . "\n");

• < get_root()
• get_rows() >