Db\Adapter\Pdo::query

public query (mixed $sqlStatement, [mixed $bindParams], [mixed $bindTypes])

Sends SQL statements to the database server returning the success state. Use this method only when the SQL statement sent to the server is returning rows

//Querying data
$resultset = $connection->query("SELECT * FROM robots WHERE type='mechanical'");
$resultset = $connection->query("SELECT * FROM robots WHERE type=?", array("mechanical"));

Links:

https://docs.phalconphp.com/en/latest/api/Phalcon_Db_Adapter_Pdo.html#query

doc_Phalcon

2025-01-10 15:47:30

Comments

Popular Articles

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\Pdo\Mysql extends abstract class Phalcon\Db\Adapter\Pdo implements Phalcon\Events\EventsAwareInterface, Phalcon\Db\AdapterInterface Source on GitHub Specific f

Db\Adapter\Pdo::prepare public prepare (mixed $sqlStatement) Returns a PDO prepared statement to be executed with ‘executePrepared’ use Phalcon\Db\Column; $statement = $db

Db\Adapter\Pdo::lastInsertId public int | boolean lastInsertId ([string $sequenceName]) Returns the insert id for the auto_increment/serial column inserted in the lastest execute

Db\Adapter\Pdo::connect public connect ([array $descriptor]) This method is automatically called in \Phalcon\Db\Adapter\Pdo constructor. Call it when you need to restore a d