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, ∼2536🔥, 0💬
Popular Posts:
How to use urllib.parse.urlencode() function to encode HTTP POST data? My form data has special char...
What properties and functions are supported on requests.models.Response objects? "requests" module s...
How to use .NET CLR Types in Azure API Policy? By default, Azure imports many basic .NET CLR (Common...
Where to find tutorials on Using Azure API Management Publisher Dashboard? Here is a list of tutoria...
How to how to use matched string and groups in replacements with re.sub()? When calling the re.sub()...