Db\Adapter::fetchColumn

public string | ** fetchColumn (string $sqlQuery, [array $placeholders], [int | string $column])

Returns the n’th field of first row in a SQL query result

//Getting count of robots
$robotsCount = $connection->fetchColumn("SELECT count(*) FROM robots");
print_r($robotsCount);
 
//Getting name of last edited robot
$robot = $connection->fetchColumn("SELECT id, name FROM robots order by modified desc", 1);
print_r($robot);

Links:

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

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::limit public limit (mixed $sqlQuery, mixed $number) Appends a LIMIT clause to $sqlQuery argument echo $connection->limit("SELECT * FROM robots", 5);

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\Pdo extends abstract class Phalcon\Db\Adapter implements Phalcon\Events\EventsAwareInterface Source on GitHub Phalcon\Db\Adapter\Pdo is the Phalcon\Db th

Db\Adapter::createSavepoint public createSavepoint (mixed $name) Creates a new savepoint