Db\Result\Pdo::setFetchMode

public setFetchMode (mixed $fetchMode, [mixed $colNoOrClassNameOrObject], [mixed $ctorargs])

Changes the fetching mode affecting Phalcon\Db\Result\Pdo::fetch()

//Return array with integer indexes
$result->setFetchMode(\Phalcon\Db::FETCH_NUM);

//Return associative array without integer indexes
$result->setFetchMode(\Phalcon\Db::FETCH_ASSOC);

//Return associative array together with integer indexes
$result->setFetchMode(\Phalcon\Db::FETCH_BOTH);

//Return an object
$result->setFetchMode(\Phalcon\Db::FETCH_OBJ);

Links:

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

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::execute public execute () Allows to execute the statement again. Some database systems don’t support scrollable cursors, So, as cursors are forward only, we

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