How to get last inserted id from table MySQL [duplicate]

by

If you use php to connect to mysql you can use mysql_insert_id() to point to last inserted id.

Like this :

mysql_query("INSERT INTO mytable (1, 2, 3, 'blah')");
$last_id = mysql_insert_id();

See this : mysql_insert_id()

More Related Contents:

  1. Using PHP data in MySQL [closed]
  2. Gather column name of a table from database [closed]
  3. I am seeing this error on submitting form Error: query was empty [closed]
  4. How to convert the json image url string into Bitmap image to display images in android application
  5. save user images in MYSQL database by which method? [closed]
  6. How to use multiple databases in Laravel
  7. PDO get the last ID inserted
  8. Automated or regular backup of mysql data
  9. strange character encoding of stored data , old script is showing them fine new one doesn’t
  10. Show values from a MySQL database table inside a HTML table on a webpage [duplicate]
  11. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  12. How can I store and retrieve images from a MySQL database using PHP?
  13. PDO mysql: How to know if insert was successful
  14. Importing CSV data using PHP/MySQL
  15. How to loop through a mysql result set
  16. How to store file name in database, with other info while uploading image to server using PHP?
  17. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  18. Mechanisms for tracking DB schema changes [closed]
  19. Fetching single row, single column with PDO
  20. Is there any way to check the performance of mysql Indexing
  21. IP address storing in MySQL database using PHP [duplicate]
  22. How to store an array into mysql?
  23. Get all child, grandchild etc nodes under parent using php with mysql query results
  24. Saving images in database mysql
  25. PHP – Secure member-only pages with a login system
  26. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  27. Selecting all fields except only one field in mysql [duplicate]
  28. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  29. MySQL ORDER BY rand(), name ASC
  30. Auto Increment skipping numbers?

Leave a Comment