Sometimes, we want to insert a row and then get ‘id’ with PHP/MySQL.
In this article, we’ll look at how to insert a row and then get ‘id’ with PHP/MySQL.
How to insert a row and then get ‘id’ with PHP/MySQL?
To insert a row and then get ‘id’ with PHP/MySQL, we can use the mysqli_insert_id function.
For instance, we write
$link = mysqli_connect("127.0.0.1", "my_user", "my_pass", "my_db");
mysqli_query($link, "INSERT INTO mytable (1, 2, 3, 'blah')");
$id = mysqli_insert_id($link);
to connect to the database with mysqli_connect.
Then we call mysqli_query function to run the insert statement.
Finally, we get the ID of the last row inserted with mysqli_insert_id.
Conclusion
To insert a row and then get ‘id’ with PHP/MySQL, we can use the mysqli_insert_id function.
