Class **Phalcon\\Db\\Adapter\\Pdo\\Mysql** ========================================== *extends* abstract class :doc:`Phalcon\\Db\\Adapter\\Pdo ` *implements* :doc:`Phalcon\\Events\\EventsAwareInterface `, :doc:`Phalcon\\Db\\AdapterInterface ` .. role:: raw-html(raw) :format: html :raw-html:`Source on GitHub` Specific functions for the Mysql database system .. code-block:: php "192.168.0.11", "dbname" => "blog", "port" => 3306, "username" => "sigma", "password" => "secret" ); $connection = new \Phalcon\Db\Adapter\Pdo\Mysql($config); Methods ------- public *string* **escapeIdentifier** (*string|array* $identifier) Escapes a column/table/schema name public **describeColumns** (*unknown* $table, [*unknown* $schema]) Returns an array of Phalcon\\Db\\Column objects describing a table .. code-block:: php describeColumns("posts")); public **__construct** (*array* $descriptor) inherited from Phalcon\\Db\\Adapter\\Pdo Constructor for Phalcon\\Db\\Adapter\\Pdo public *boolean* **connect** ([*array* $descriptor]) inherited from Phalcon\\Db\\Adapter\\Pdo This method is automatically called in Phalcon\\Db\\Adapter\\Pdo constructor. Call it when you need to restore a database connection .. code-block:: php '192.168.0.11', 'username' => 'sigma', 'password' => 'secret', 'dbname' => 'blog', )); //Reconnect $connection->connect(); public **prepare** (*unknown* $sqlStatement) inherited from Phalcon\\Db\\Adapter\\Pdo Returns a PDO prepared statement to be executed with 'executePrepared' .. code-block:: php prepare('SELECT * FROM robots WHERE name = :name'); $result = $connection->executePrepared($statement, array('name' => 'Voltron')); public *\PDOStatement* **executePrepared** (*\PDOStatement* $statement, *array* $placeholders, *array* $dataTypes) inherited from Phalcon\\Db\\Adapter\\Pdo Executes a prepared statement binding. This function uses integer indexes starting from zero .. code-block:: php prepare('SELECT * FROM robots WHERE name = :name'); $result = $connection->executePrepared($statement, array('name' => 'Voltron')); public **query** (*unknown* $sqlStatement, [*unknown* $bindParams], [*unknown* $bindTypes]) inherited from Phalcon\\Db\\Adapter\\Pdo 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 .. code-block:: php query("SELECT * FROM robots WHERE type='mechanical'"); $resultset = $connection->query("SELECT * FROM robots WHERE type=?", array("mechanical")); public **execute** (*unknown* $sqlStatement, [*unknown* $bindParams], [*unknown* $bindTypes]) inherited from Phalcon\\Db\\Adapter\\Pdo Sends SQL statements to the database server returning the success state. Use this method only when the SQL statement sent to the server doesn't return any rows .. code-block:: php execute("INSERT INTO robots VALUES (1, 'Astro Boy')"); $success = $connection->execute("INSERT INTO robots VALUES (?, ?)", array(1, 'Astro Boy')); public **affectedRows** () inherited from Phalcon\\Db\\Adapter\\Pdo Returns the number of affected rows by the lastest INSERT/UPDATE/DELETE executed in the database system .. code-block:: php execute("DELETE FROM robots"); echo $connection->affectedRows(), ' were deleted'; public **close** () inherited from Phalcon\\Db\\Adapter\\Pdo Closes the active connection returning success. Phalcon automatically closes and destroys active connections when the request ends public **escapeString** (*unknown* $str) inherited from Phalcon\\Db\\Adapter\\Pdo Escapes a value to avoid SQL injections according to the active charset in the connection .. code-block:: php escapeString('some dangerous value'); public **convertBoundParams** (*unknown* $sql, [*array* $params]) inherited from Phalcon\\Db\\Adapter\\Pdo Converts bound parameters such as :name: or ?1 into PDO bind params ? .. code-block:: php convertBoundParams('SELECT * FROM robots WHERE name = :name:', array('Bender'))); public *int|boolean* **lastInsertId** ([*string* $sequenceName]) inherited from Phalcon\\Db\\Adapter\\Pdo Returns the insert id for the auto_increment/serial column inserted in the lastest executed SQL statement .. code-block:: php insert( "robots", array("Astro Boy", 1952), array("name", "year") ); //Getting the generated id $id = $connection->lastInsertId(); public **begin** ([*unknown* $nesting]) inherited from Phalcon\\Db\\Adapter\\Pdo Starts a transaction in the connection public **rollback** ([*unknown* $nesting]) inherited from Phalcon\\Db\\Adapter\\Pdo Rollbacks the active transaction in the connection public **commit** ([*unknown* $nesting]) inherited from Phalcon\\Db\\Adapter\\Pdo Commits the active transaction in the connection public **getTransactionLevel** () inherited from Phalcon\\Db\\Adapter\\Pdo Returns the current transaction nesting level public **isUnderTransaction** () inherited from Phalcon\\Db\\Adapter\\Pdo Checks whether the connection is under a transaction .. code-block:: php begin(); var_dump($connection->isUnderTransaction()); //true public **getInternalHandler** () inherited from Phalcon\\Db\\Adapter\\Pdo Return internal PDO handler public *array* **getErrorInfo** () inherited from Phalcon\\Db\\Adapter\\Pdo Return the error info, if any public **getDialectType** () inherited from Phalcon\\Db\\Adapter Name of the dialect used public **getType** () inherited from Phalcon\\Db\\Adapter Type of database system the adapter is used for public **getSqlVariables** () inherited from Phalcon\\Db\\Adapter Active SQL bound parameter variables public **setEventsManager** (:doc:`Phalcon\\Events\\ManagerInterface ` $eventsManager) inherited from Phalcon\\Db\\Adapter Sets the event manager public **getEventsManager** () inherited from Phalcon\\Db\\Adapter Returns the internal event manager public **setDialect** (:doc:`Phalcon\\Db\\DialectInterface ` $dialect) inherited from Phalcon\\Db\\Adapter Sets the dialect used to produce the SQL public **getDialect** () inherited from Phalcon\\Db\\Adapter Returns internal dialect instance public **fetchOne** (*unknown* $sqlQuery, [*unknown* $fetchMode], [*unknown* $bindParams], [*unknown* $bindTypes]) inherited from Phalcon\\Db\\Adapter Returns the first row in a SQL query result .. code-block:: php 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); public *array* **fetchAll** (*string* $sqlQuery, [*int* $fetchMode], [*array* $bindParams], [*array* $bindTypes]) inherited from Phalcon\\Db\\Adapter Dumps the complete result of a query into an array .. code-block:: php fetchAll("SELECT * FROM robots", Phalcon\Db::FETCH_ASSOC); foreach ($robots as $robot) { print_r($robot); } //Getting all robots that contains word "robot" withing the name $robots = $connection->fetchAll("SELECT * FROM robots WHERE name LIKE :name", Phalcon\Db::FETCH_ASSOC, array('name' => '%robot%') ); foreach($robots as $robot){ print_r($robot); } public *string|* **fetchColumn** (*string* $sqlQuery, [*array* $placeholders], [*int|string* $column]) inherited from Phalcon\\Db\\Adapter Returns the n'th field of first row in a SQL query result .. code-block:: php 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); public *boolean* **insert** (*string|array* $table, *array* $values, [*array* $fields], [*array* $dataTypes]) inherited from Phalcon\\Db\\Adapter Inserts data into a table using custom RBDM SQL syntax .. code-block:: php insert( "robots", array("Astro Boy", 1952), array("name", "year") ); // Next SQL sentence is sent to the database system INSERT INTO `robots` (`name`, `year`) VALUES ("Astro boy", 1952); public *boolean* **insertAsDict** (*string* $table, *array* $data, [*array* $dataTypes]) inherited from Phalcon\\Db\\Adapter Inserts data into a table using custom RBDM SQL syntax .. code-block:: php insertAsDict( "robots", array( "name" => "Astro Boy", "year" => 1952 ) ); //Next SQL sentence is sent to the database system INSERT INTO `robots` (`name`, `year`) VALUES ("Astro boy", 1952); public *boolean* **update** (*string|array* $table, *array* $fields, *array* $values, [*string|array* $whereCondition], [*array* $dataTypes]) inherited from Phalcon\\Db\\Adapter Updates data on a table using custom RBDM SQL syntax .. code-block:: php update( "robots", array("name"), array("New Astro Boy"), "id = 101" ); //Next SQL sentence is sent to the database system UPDATE `robots` SET `name` = "Astro boy" WHERE id = 101 //Updating existing robot with array condition and $dataTypes $success = $connection->update( "robots", array("name"), array("New Astro Boy"), array( 'conditions' => "id = ?", 'bind' => array($some_unsafe_id), 'bindTypes' => array(PDO::PARAM_INT) //use only if you use $dataTypes param ), array(PDO::PARAM_STR) ); Warning! If $whereCondition is string it not escaped. public *boolean* **updateAsDict** (*string* $table, *array* $data, [*string* $whereCondition], [*array* $dataTypes]) inherited from Phalcon\\Db\\Adapter Updates data on a table using custom RBDM SQL syntax Another, more convenient syntax .. code-block:: php update( "robots", array( "name" => "New Astro Boy" ), "id = 101" ); //Next SQL sentence is sent to the database system UPDATE `robots` SET `name` = "Astro boy" WHERE id = 101 public *boolean* **delete** (*string|array* $table, [*string* $whereCondition], [*array* $placeholders], [*array* $dataTypes]) inherited from Phalcon\\Db\\Adapter Deletes data from a table using custom RBDM SQL syntax .. code-block:: php delete( "robots", "id = 101" ); //Next SQL sentence is generated DELETE FROM `robots` WHERE `id` = 101 public *string* **getColumnList** (*array* $columnList) inherited from Phalcon\\Db\\Adapter Gets a list of columns public **limit** (*unknown* $sqlQuery, *unknown* $number) inherited from Phalcon\\Db\\Adapter Appends a LIMIT clause to $sqlQuery argument .. code-block:: php limit("SELECT * FROM robots", 5); public **tableExists** (*unknown* $tableName, [*unknown* $schemaName]) inherited from Phalcon\\Db\\Adapter Generates SQL checking for the existence of a schema.table .. code-block:: php tableExists("blog", "posts")); public **viewExists** (*unknown* $viewName, [*unknown* $schemaName]) inherited from Phalcon\\Db\\Adapter Generates SQL checking for the existence of a schema.view .. code-block:: php viewExists("active_users", "posts")); public **forUpdate** (*unknown* $sqlQuery) inherited from Phalcon\\Db\\Adapter Returns a SQL modified with a FOR UPDATE clause public **sharedLock** (*unknown* $sqlQuery) inherited from Phalcon\\Db\\Adapter Returns a SQL modified with a LOCK IN SHARE MODE clause public **createTable** (*unknown* $tableName, *unknown* $schemaName, *array* $definition) inherited from Phalcon\\Db\\Adapter Creates a table public **dropTable** (*unknown* $tableName, [*unknown* $schemaName], [*unknown* $ifExists]) inherited from Phalcon\\Db\\Adapter Drops a table from a schema/database public **createView** (*unknown* $viewName, *array* $definition, [*unknown* $schemaName]) inherited from Phalcon\\Db\\Adapter Creates a view public **dropView** (*unknown* $viewName, [*unknown* $schemaName], [*unknown* $ifExists]) inherited from Phalcon\\Db\\Adapter Drops a view public **addColumn** (*unknown* $tableName, *unknown* $schemaName, :doc:`Phalcon\\Db\\ColumnInterface ` $column) inherited from Phalcon\\Db\\Adapter Adds a column to a table public **modifyColumn** (*unknown* $tableName, *unknown* $schemaName, :doc:`Phalcon\\Db\\ColumnInterface ` $column, [:doc:`Phalcon\\Db\\ColumnInterface ` $currentColumn]) inherited from Phalcon\\Db\\Adapter Modifies a table column based on a definition public **dropColumn** (*unknown* $tableName, *unknown* $schemaName, *unknown* $columnName) inherited from Phalcon\\Db\\Adapter Drops a column from a table public **addIndex** (*unknown* $tableName, *unknown* $schemaName, :doc:`Phalcon\\Db\\IndexInterface ` $index) inherited from Phalcon\\Db\\Adapter Adds an index to a table public **dropIndex** (*unknown* $tableName, *unknown* $schemaName, *unknown* $indexName) inherited from Phalcon\\Db\\Adapter Drop an index from a table public **addPrimaryKey** (*unknown* $tableName, *unknown* $schemaName, :doc:`Phalcon\\Db\\IndexInterface ` $index) inherited from Phalcon\\Db\\Adapter Adds a primary key to a table public **dropPrimaryKey** (*unknown* $tableName, *unknown* $schemaName) inherited from Phalcon\\Db\\Adapter Drops a table's primary key public **addForeignKey** (*unknown* $tableName, *unknown* $schemaName, :doc:`Phalcon\\Db\\ReferenceInterface ` $reference) inherited from Phalcon\\Db\\Adapter Adds a foreign key to a table public **dropForeignKey** (*unknown* $tableName, *unknown* $schemaName, *unknown* $referenceName) inherited from Phalcon\\Db\\Adapter Drops a foreign key from a table public **getColumnDefinition** (:doc:`Phalcon\\Db\\ColumnInterface ` $column) inherited from Phalcon\\Db\\Adapter Returns the SQL column definition from a column public **listTables** ([*unknown* $schemaName]) inherited from Phalcon\\Db\\Adapter List all tables on a database .. code-block:: php listTables("blog")); public **listViews** ([*unknown* $schemaName]) inherited from Phalcon\\Db\\Adapter List all views on a database .. code-block:: php listViews("blog")); public :doc:`Phalcon\\Db\\Index ` [] **describeIndexes** (*string* $table, [*string* $schema]) inherited from Phalcon\\Db\\Adapter Lists table indexes .. code-block:: php describeIndexes('robots_parts')); public **describeReferences** (*unknown* $table, [*unknown* $schema]) inherited from Phalcon\\Db\\Adapter Lists table references .. code-block:: php describeReferences('robots_parts')); public **tableOptions** (*unknown* $tableName, [*unknown* $schemaName]) inherited from Phalcon\\Db\\Adapter Gets creation options from a table .. code-block:: php tableOptions('robots')); public **createSavepoint** (*unknown* $name) inherited from Phalcon\\Db\\Adapter Creates a new savepoint public **releaseSavepoint** (*unknown* $name) inherited from Phalcon\\Db\\Adapter Releases given savepoint public **rollbackSavepoint** (*unknown* $name) inherited from Phalcon\\Db\\Adapter Rollbacks given savepoint public **setNestedTransactionsWithSavepoints** (*unknown* $nestedTransactionsWithSavepoints) inherited from Phalcon\\Db\\Adapter Set if nested transactions should use savepoints public **isNestedTransactionsWithSavepoints** () inherited from Phalcon\\Db\\Adapter Returns if nested transactions should use savepoints public **getNestedTransactionSavepointName** () inherited from Phalcon\\Db\\Adapter Returns the savepoint name to use for nested transactions public **getDefaultIdValue** () inherited from Phalcon\\Db\\Adapter Returns the default identity value to be inserted in an identity column .. code-block:: php insert( "robots", array($connection->getDefaultIdValue(), "Astro Boy", 1952), array("id", "name", "year") ); public **getDefaultValue** () inherited from Phalcon\\Db\\Adapter Returns the default value to make the RBDM use the default value declared in the table definition .. code-block:: php insert( "robots", array("Astro Boy", $connection->getDefaultValue()), array("name", "year") ); public **supportSequences** () inherited from Phalcon\\Db\\Adapter Check whether the database system requires a sequence to produce auto-numeric values public **useExplicitIdValue** () inherited from Phalcon\\Db\\Adapter Check whether the database system requires an explicit value for identity columns public *array* **getDescriptor** () inherited from Phalcon\\Db\\Adapter Return descriptor used to connect to the active database public *string* **getConnectionId** () inherited from Phalcon\\Db\\Adapter Gets the active connection unique identifier public **getSQLStatement** () inherited from Phalcon\\Db\\Adapter Active SQL statement in the object public **getRealSQLStatement** () inherited from Phalcon\\Db\\Adapter Active SQL statement in the object without replace bound paramters public *array* **getSQLBindTypes** () inherited from Phalcon\\Db\\Adapter Active SQL statement in the object