public fetch ([mixed $fetchStyle], [mixed $cursorOrientation], [mixed $cursorOffset]) Fetches an array/object of strings that corresponds to the fetched row, or FALSE if there are no more rows. This method is affected by the active fetch flag set using Phalcon\Db\Result\Pdo::setFetchMode $result = $connection->query("SELECT * FROM robots ORDER BY name"); $result->setFetchMode(Phalcon\Db::FETCH_OBJ); while ($robot = $result->fetch()) { echo $robot->name; }

public execute () Allows to execute the statement again. Some database systems don’t support scrollable cursors, So, as cursors are forward only, we need to execute the cursor again to fetch rows from the begining

public dataSeek (mixed $number) Moves internal resultset cursor to another position letting us to fetch a certain row $result = $connection->query("SELECT * FROM robots ORDER BY name"); $result->dataSeek(2); // Move to third row on result $row = $result->fetch(); // Fetch third row

implements Phalcon\Db\ResultInterface Source on GitHub Encapsulates the resultset internals $result = $connection->query("SELECT * FROM robots ORDER BY name"); $result->setFetchMode(Phalcon\Db::FETCH_NUM); while ($robot = $result->fetchArray()) { print_r($robot); } Methods public __construct (Phalcon\Db\AdapterInterface $connection, PDOStatement $result, [string $sqlStatement], [array $bindParams], [array $bindTypes]) Phalcon\Db\Result\Pdo constructor public execute () Allows to e

abstract public setFetchMode (mixed $fetchMode) ...

abstract public numRows () ...

abstract public getInternalResult () ...

abstract public fetchArray () ...

abstract public fetchAll () ...

abstract public fetch () ...