Db\Adapter\Pdo::prepare

public prepare (mixed $sqlStatement)

Returns a PDO prepared statement to be executed with ‘executePrepared’

use Phalcon\Db\Column;

 $statement = $db->prepare('SELECT * FROM robots WHERE name = :name');
 $result = $connection->executePrepared($statement, ['name' => 'Voltron'], ['name' => Column::BIND_PARAM_INT]);

Links:

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

doc_Phalcon

2016-10-16 09:49:07

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::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::escapeIdentifier public string escapeIdentifier (string $identifier) Escapes a column/table/schema name $escapedTable = $connection->escapeIdentifier('robots'); $e

Db\Adapter\Pdo::query public query (mixed $sqlStatement, [mixed $bindParams], [mixed $bindTypes]) Sends SQL statements to the database server returning the success state.