Question

How to get last Insert id when using on duplicate key update with PDO MySQL SQL and PHP

Answer 1

$query = "INSERT INTO $table ($field) 
                      VALUES(:$field) ON DUPLICATE KEY UPDATE $field = $field, 
                      id = LAST_INSERT_ID(id);";
$data = array($field => $value);

$inserting = conn->prepare($query);
$inserting->execute($data);

$id = conn->lastInsertId();

 

70+ SQL courses for beginners and professionals