Db\Adapter\Pdo::lastInsertId

public int | boolean lastInsertId ([string $sequenceName])

Returns the insert id for the auto_increment/serial column inserted in the lastest executed SQL statement

//Inserting a new robot
 $success = $connection->insert(
     "robots",
     array("Astro Boy", 1952),
     array("name", "year")
 );

 //Getting the generated id
 $id = $connection->lastInsertId();

Links:

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

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

Db\Adapter\Pdo::commit public commit ([mixed $nesting]) Commits the active transaction in the connection

Db\Adapter\Pdo::convertBoundParams public convertBoundParams (mixed $sql, [array $params]) Converts bound parameters such as :name: or ?1 into PDO bind params ? print_r($connection->

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