Retrieving the Last Auto Increment ID in PHP
Q
How To Get the Last ID Assigned by MySQL in PHP?
✍: FYIcenter.com
A
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, 1521🔥, 0💬
Related Topics:
