last insert id

1<?php
2$servername = "localhost";
3$username = "username";
4$password = "password";
5$dbname = "myDB";
6
7// Create connection
8$conn = mysqli_connect($servername, $username, $password, $dbname);
9// Check connection
10if (!$conn) {
11    die("Connection failed: " . mysqli_connect_error());
12}
13
14$sql = "INSERT INTO MyGuests (firstname, lastname, email)
15VALUES ('John', 'Doe', 'john@example.com')";
16
17if (mysqli_query($conn, $sql)) {
18    $last_id = mysqli_insert_id($conn);
19    echo "New record created successfully. Last inserted ID is: " . $last_id;
20} else {
21    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
22}
23
24mysqli_close($conn);
25?>

1$last_id = $conn->insert_id;

1-- To get the last inserted auto-increment row ID: --
2SELECT LAST_INSERT_ID( optional_expression )
3
4-- If you have just inserted it using a command in C# use: --
5int lastId = (Int32)yourCommand.LastInsertedId;