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

2016-10-16 09:49:52

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::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::getInternalResult public getInternalResult () Gets the internal PDO result object

Db\Result\Pdo::fetchAll public fetchAll ([mixed $fetchStyle], [mixed $fetchArgument], [mixed $ctorArgs]) Returns an array of arrays containing all the records in the result

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