Tools, FAQ, Tutorials:
Retrieving the Last Auto Increment ID in PHP
How To Get the Last ID Assigned by MySQL in PHP?
✍: FYIcenter.com
If you use an ID column with AUTO_INCREMENT attribute, you can use the mysql_insert_id() function to get the last ID value assigned by the MySQL server, as shown in the sample script below:
<?php include "mysql_connection.php"; $sql = "INSERT INTO fyi_users (name) VALUES ('John King')"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows inserted.\n"); print("Last ID inserted: ".mysql_insert_id()."\n"); } else { print("SQL statement failed.\n"); } mysql_close($con); ?>
If you run this script, you will get something like this:
1 rows inserted. Last ID inserted: 3
⇒ Uploading Files to Web Servers in PHP
⇐ Setting ID Column as Auto-Incremented in PHP
2016-10-17, 1362🔥, 0💬
Popular Posts:
How to include additional claims in Azure AD v2.0 id_tokens? If you want to include additional claim...
What is Azure API Management Developer Portal Admin? The Developer Portal Admin is an Azure Web port...
Why I am getting "The Windows SDK version 8.1 was not found" error, when building my C++ application...
How To Read the Entire File into a Single String in PHP? If you have a file, and you want to read th...
How to register and get an application ID from Azure AD? The first step to use Azure AD is to regist...