Db\Result\Pdo::fetch

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;
}

Links:

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

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::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::fetchArray public fetchArray () Returns an array of strings that corresponds to the fetched row, or FALSE if there are no more rows. This method is affected by

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