PHP/MySQL insert row then get ‘id’

by 
$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);

See mysqli_insert_id().

Whatever you do, don’t insert and then do a “SELECT MAX(id) FROM mytable“. Like you say, it’s a race condition and there’s no need. mysqli_insert_id() already has this functionality.

Another way would be to run both queries in one go, and using MySQL‘s LAST_INSERT_ID() method, where both tables get modified at once (and PHP does not need any ID), like:

mysqli_query($link, "INSERT INTO my_user_table ...;
  INSERT INTO my_other_table (`user_id`) VALUES (LAST_INSERT_ID())");

Note that Each connection keeps track of ID separately (so, conflicts are prevented already).

More Related Contents:

  1. While loop inserts three times
  2. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in? [duplicate]
  3. regarding installation of php in windows
  4. save user images in MYSQL database by which method? [closed]
  5. How to apply bindValue method in LIMIT clause?
  6. Best way to INSERT many values in mysqli?
  7. Error when preparing a multiple insert query
  8. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  9. What is the best collation to use for MySQL with PHP? [closed]
  10. mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_object
  11. Export MySQL database using PHP [closed]
  12. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  13. How to add new column to MYSQL table?
  14. Do SQL connections opened with PDO in PHP have to be closed
  15. mysql select query within a serialized array
  16. mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in php [duplicate]
  17. Whats the easiest way to determine if a user is online? (PHP/MYSQL)
  18. What is the advantage of using try {} catch {} versus if {} else {}
  19. Category Hierarchy (PHP/MySQL)
  20. Alternative for mysql_num_rows using PDO
  21. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  22. How to convert ISO8601 to Date format in php
  23. belongsToMany relationship in Laravel across multiple databases
  24. Algorithm for generating a random number
  25. return one value from database with mysql php pdo
  26. onbeforeprint() and onafterprint() equivalent for non IE browsers
  27. How can I pass an array of PDO parameters yet still specify their types?
  28. MySQL & PHP Parameter 1 as Resource
  29. How to check if a value already exists to avoid duplicates?
  30. MYSQL select a piece of a string and order by that piece

Leave a Comment