int $DB_DataObject->get (
mixed Key or Value
,
mixed value
)
Get a result using key, value. Returns Number of rows located (usually 1) for success, and puts all the table columns into this classes variables. If only one parameter is used, it is assumed that first parameter is a value and get() will use the primary key.
mixed $key or $value - column (or value if only one parameter)
mixed $value - value
int - Number of rows
| Error code | Error message | Meaning | Solution |
|---|---|---|---|
| DB_DATAOBJECT_ERROR_INVALIDCONFIG | "No Keys available for $table" | ||
| DB_DATAOBJECT_ERROR_INVALIDARGS | "No Value specified for get" |
This function can not be called statically.
You should avoid calling get on the same object instance twice, as this will result in unexpected results.
Simple fetch of data based on Primary Key
<?php
$person = new DataObjects_Person;
$person->get(12);
print_r($person);
?>
Resulting SQL
Simple fetch of data based on Key and Value
<?php
$person = new DataObjects_Person;
$person->get('email','test@example.com');
print_r($person);
?>
Resulting SQL
Results of example code
<?php
Object (DataObjects_Person) =>
[N] => 1
[id] => 12
[group] => 5
[has_glasses] => 1
[name] => 'fred blogs'
[password] => '**testing'
[email] => 'test@example.com'
?>