PEAR Handbuch
ZurückNach vorne

Finding and fetching

Finding and fetching --  Simple Querying methods ::staticGet() ::get() ::find() ::fetch() ::count()

::get()

Simple Get (Select) request, are achieved using the get method

::get (mixed Key or Value [, mixed Value])

The basic get method for an extended class can be used in two ways, to get based on the primary key (one parameter) or based on a key and value (two parameters)

Beispiel 1. Simple fetch of data based on Primary Key

$person = new DataObjects_Person;
$person->get(12);
print_r($person);

This would execute the following SQL statement and fetch the results into the objects variables

Beispiel 2. Resulting SQL 

SELECT * FROM person WHERE id=12

To use another field other than the primary key, you would use it with two parameters

Beispiel 3. Simple fetch of data based on Key and Value

$person = new DataObjects_Person;
$person->get('email','test@example.com');
print_r($person);

This would execute the following SQL statement and fetch the results into the objects variables

Beispiel 4. Resulting SQL 

SELECT * FROM person WHERE email='test@example.com'

The result of these two queries would be that all the objects variables would contain the matched row's data and the variable $person->N would contain the number of matches.

Beispiel 5. Results of example code

Object (DataObjects_Person) =>
    [N] => 1
    [id] => 12
    [group] => 5
    [has_glasses] => 1
    [name] => 'fred blogs'
    [password] => '**testing'
    [email] => 'test@example.com'

::staticGet()

Simple Get (Select) request, abbreviated get request.

::staticGet (mixed Key or Value [, mixed Value])

The static method is similar to the get request, however it does not require the initial instantiation of the class. staticGet also caches the result.

Beispiel 6. Simple fetch of data based on Primary Key

$person = DataObjects_Person::staticGet(12);
print_r($person);

You may also use the DB_DataObject staticGet method directly, however you need to specify which class you wish to use. In this case, the Class file will be automatically loaded.

Beispiel 7. Simple fetch of data based on Primary Key

$person = DB_DataObject::staticGet('DataObjects_Person',12);
print_r($person);

::find()

Searching for Items

integer ::find ([boolean AutoFetch])

The find method builds and executes the current Query, based on the object variables and any 'WhereAdd' conditions , If the AutoFetch is TRUE, then it will also call the fetch method automatically.

Beispiel 8. Simple find of data based on Object Vars

$person = new DataObjects_Person;
$person->hair = 'red';
$person->has_glasses = 1;
$number_of_rows = $person->find();

This would execute the following SQL statement and fetch the results into the objects variables

Beispiel 9. Resulting SQL 

SELECT * FROM person WHERE hair='red' and has_glasses = 1

::fetch()

Getting the data.

boolean ::fetch ()

The fetch method gets the next row and sets the objects variables to the rows data. It returns true if data has been collected, and false when there is no more data.

Beispiel 10. Simple find and fetch of data based on Object Vars

$person = new DataObjects_Person;

$person->hair = 'red';
$person->has_glasses = 1;

$number_of_rows = $person->find();

$people = array();
while ($person->fetch()) {
    /* store the results in an array */
    $people[] = $person->__clone();
    echo "GOT {$person->name}<BR>";
}

::count()

Performs a select count() request

int ::count ()

Performs a select count() request on the tables key column, and returns the number of rows returned

Beispiel 11. Simple find and fetch of data based on Object Vars

$person = new DataObjects_Person;

$person->whereAdd('name like '%test%');
$total = $person->count();

echo "There are {$total} people with a name like test";

This would execute the following SQL statement and fetch the results into the objects variables

Beispiel 12. Resulting SQL 

SELECT count(id) FROM person WHERE name like '%test%'

ZurückZum AnfangNach vorne
Auto BuildingNach obenModifying the database