Using Prepared Statement, how I return the id of the inserted row?

I w开发者_如何转开发ant retrieve the id of a inserted row in the database, but I don't know how to do this.

I tried to return using the SQL clause RETURNING id, but not works.

How I can return the id after the insertion of a row?

After calling the execute() method on the Prepared Statement, the id of the insert row will be in the insert_id attribute.

$pstm->execute();
$pstm->insert_id;

$newid = mysqli_insert_id($mysqli_db);

$mysqli_db is your mysqli database connection. As far as I know it shouldn't matter on which way ou inserted the row (prepared statement or direct INSERT INTO). mysqli_insert_id() should return the id of the last inserted row using this db connection.

The alternative is to make another query like SELECT LAST_INSERT_ID();.

You need to use:

$stmt = $db->prepare("SQL Query");
$stmt->execute();
$id = $db->lastInsertId();