Db\Adapter::fetchOne

public fetchOne (mixed $sqlQuery, [mixed $fetchMode], [mixed $bindParams], [mixed $bindTypes])

Returns the first row in a SQL query result

//Getting first robot
$robot = $connection->fetchOne("SELECT * FROM robots");
print_r($robot);

//Getting first robot with associative indexes only
$robot = $connection->fetchOne("SELECT * FROM robots", Phalcon\Db::FETCH_ASSOC);
print_r($robot);

Links:

https://docs.phalconphp.com/en/latest/api/Phalcon_Db_Adapter.html#fetchone

doc_Phalcon

2025-01-10 15:47:30

Comments

Popular Articles

Db\Adapter implements Phalcon\Events\EventsAwareInterface Source on GitHub Base class for Phalcon\Db adapters Methods public getDialectType () Name of the diale

Db\Adapter::describeReferences public describeReferences (mixed $table, [mixed $schema]) Lists table references print_r($connection->describeReferences('robots_parts'));

Db\Adapter::tableExists public tableExists (mixed $tableName, [mixed $schemaName]) Generates SQL checking for the existence of a schema.table var_dump($connection->tableE

Db\Adapter::delete public boolean delete (string | array $table, [string $whereCondition], [array $placeholders], [array $dataTypes]) Deletes data from a table using cu

Db\Adapter\Pdo extends abstract class Phalcon\Db\Adapter implements Phalcon\Events\EventsAwareInterface Source on GitHub Phalcon\Db\Adapter\Pdo is the Phalcon\Db th