PDO - get the current inserted identifier

Question

$query = "INSERT INTO news VALUES (NULL, :param1 , :param2 )"; $stmt = $pdo->prepare($query); $params = array( "param1" => $p['title'], "param2" => $p['body'], ); $data = $stmt->execute($params); // here i would like get current inserted ID. Is possible? $id = $data->id ???? ; 

How can i do this?

Answer 1

 $query = "INSERT INTO news VALUES (NULL, :param1 , :param2 )"; $stmt = $pdo->prepare($query); $params = array( "param1" => $p['title'], "param2" => $p['body'], ); $data = $stmt->execute($params); 

so you can do this to get the last inserted id

 $last_id = $pdo->lastInsertId(); 

Answer 2

Using:

 $last_insert_id = $pdo->lastInsertId(); 

Answer 3

You can use PDO :: lastInsertId

 $last_insert_id = $pdo->lastInsertId();