Db\Result\Pdo::dataSeek

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

Links:

https://docs.phalconphp.com/en/latest/api/Phalcon_Db_Result_Pdo.html#dataseek

doc_Phalcon

2025-01-10 15:47:30

Comments

Popular Articles

Db\Result\Pdo implements Phalcon\Db\ResultInterface Source on GitHub Encapsulates the resultset internals $result = $connection->query("SELECT * FROM robots ORD

Db\Result\Pdo::getInternalResult public getInternalResult () Gets the internal PDO result object

Db\Result\Pdo::numRows public numRows () Gets number of rows returned by a resultset $result = $connection->query("SELECT * FROM robots ORDER BY name"); echo 'There are

Db\Result\Pdo::setFetchMode public setFetchMode (mixed $fetchMode, [mixed $colNoOrClassNameOrObject], [mixed $ctorargs]) Changes the fetching mode affecting Phalcon\Db\Result\Pd

Db\Result\Pdo::execute public execute () Allows to execute the statement again. Some database systems don’t support scrollable cursors, So, as cursors are forward only, we