- ⌂ 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_first()
Perform a query and return the first matching object.
New to COMAND queries? Check out the COMAND API Queries Tutorial.
Prototype
cObject get_first(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
The first cObject to match the query, otherwise NULL.
Example
$contacts = $repo->get_first("SELECT Name, Phone FROM Contact WHERE Name='John'");
echo($contact->Name . " - " . $contact->Phone . "\n");