PEAR Manual
Prev |  | Next

# ->fetch()

->fetch() -- fetch next row

## Synopsis

``boolean $DB_DataObject->fetch` ()`

## Description

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.

## Return value

`boolean` - `TRUE` on success and `FALSE` on failure.

## Note

This function can not be called statically.

Fetch is called by staticGet and get calls, so you can override this method in your classes, to add extra data to your object (like formated dates etc)

## Example

Example 33-1. 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[] = clone($person);
        echo "GOT {$person->name}<BR>";
    }

Example 33-2. Overriding fetch to add extra data.
    function fetch() {

      $ret = parent::fetch();
      if ($ret === false) {
          return false;
      }
      $this->dateFormated = date('d/M/Y', $this->date);
      return true;
    }

Prev | Home | Next
->find() | Up | ->count()