->get()
->get() -- Simple Get (Select) request
Synopsis
int $DB_DataObject->get (mixed Key or Value [, mixed value])
Description
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.
Return value
int - Number of rows
Throws
Table 39-1. Possible PEAR_Error values
| Error code | Error message | Meaning | Solution |
|---|
| DB_DATAOBJECT_ERROR_INVALIDCONFIG | "No Keys available for $table" | | |
| DB_DATAOBJECT_ERROR_INVALIDARGS | "No Value specified for get" | | |
Note
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.
Example
Example 39-1. Simple fetch of data based on Primary Key
<?php
$person = new DataObjects_Person;
$person->get(12);
print_r($person);
?>
|
|
Example 39-2. Resulting SQL SELECT * FROM person WHERE id=12 |
|
Example 39-3. Simple fetch of data based on Key and Value
<?php
$person = new DataObjects_Person;
$person->get('email','test@example.com');
print_r($person);
?>
|
|
Example 39-4. Resulting SQL SELECT * FROM person WHERE email='test@example.com' |
|
Example 39-5. 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'
?>
|
|