PHP MySQL insert row then get id

Question

The  id  field of my table auto increases when I insert a row  I want to insert a row and then get that ID   I would do it just as I said it  but is there a way I can do it without worrying about the time between inserting the row and getting the id   I know I can query the database for the row that matches the information that was entered  but there is a high change there will be duplicates  with the only difference being the id

User · Answer

As  NaturalBornCamper said  mysql insert id is now deprecated and should not be used  The options are now to use  either PDO or mysqli  NaturalBornCamper explained PDO in his answer  so I ll show how to do it with MySQLi  MySQL Improved  using mysqli insert id      First  connect to your database with the usual info     db   new mysqli  hostname   username   password   databaseName      Let s assume we have a table called  people  which has a column    called  people id  which is the PK and is auto-incremented     db- gt query  INSERT INTO people  people name  VALUES   Mr  X         We ve now entered in a new row  which has automatically been     given a new people id  We can get it simply with   lastInsertedPeopleId    db- gt insert id     OR  lastInsertedPeopleId   mysqli insert id  db     Check out the PHP documentation for more examples  http   php net manual en mysqli insert-id php

User · Answer

Another possible answer will be   When you define the table  with the columns and data it ll have  The column id can have the property AUTO INCREMENT   By this method  you don t have to worry about the id  it ll be made automatically   For example  taken from w3schools    CREATE TABLE Persons   ID int NOT NULL AUTO INCREMENT  LastName varchar 255  NOT NULL  FirstName varchar 255   Address varchar 255   City varchar 255   PRIMARY KEY  ID      Hope this will be helpful for someone   Edit  This is only the part where you define how to generate an automatic ID  to obtain it after created  the previous answers before are right

User · Answer

Try this    it worked for me    sql    INSERT INTO tablename  row name  VALUES   row value         if  mysqli query  conn   sql          last id   mysqli insert id  conn        msg1    New record created successfully  Last inserted ID is       last id    else        msg error    Error       sql     lt br gt     mysqli error  conn

User · Answer

The MySQL function LAST INSERT ID   does just what you need  it retrieves the id that was inserted during this session  So it is safe to use  even if there are other processes  other people calling the exact same script  for example  inserting values into the same table   The PHP function mysql insert id   does the same as calling SELECT LAST INSERT ID   with mysql query

User · Answer

An example          query new    INSERT INTO students courseid  coursename  VALUES                query new    databaseConnection- gt prepare  query new        query new- gt bind param  s     POST  coursename          query new- gt execute         course id    query new- gt insert id       query new- gt close      The code line  course id    query new- gt insert id  will display the ID of the last inserted row   Hope this helps

User · Answer

Try like this you can get the answer    lt  php  con mysqli connect  localhost   root      new       Check connection if  mysqli connect errno          echo  Failed to connect to MySQL      mysqli connect error         mysqli query  con  INSERT INTO new values  nameuser   2015-09-12          Print auto-generated id echo  New record has id      mysqli insert id  con    mysqli close  con     gt    Have a look at following links   http   www w3schools com php func mysqli insert id asp  http   php net manual en function mysql-insert-id php  Also please have a note that this extension was deprecated in PHP 5 5 and removed in PHP 7 0

User · Answer

As to PHP s website  mysql insert id is now deprecated and we must use either PDO or MySQLi  See  Luke s answer for MySQLi   To do this with PDO  proceed as following   db   new PDO  mysql dbname database host localhost    user    pass     statement    db- gt prepare  INSERT INTO people name  city  VALUES  name   city      statement- gt execute    name    gt   Bob     city    gt   Montreal      echo  db- gt lastInsertId

User · Answer

I just want to add a small detail concerning lastInsertId     When entering more than one row at the time  it does not return the last Id  but the first Id of the collection of last inserts   Consider the following example   sql    INSERT INTO my table  varNumb userid  VALUES       1   userid         2   userid     sql- gt addNewNames    db- gt prepare  sql   addNewNames- gt execute array   userid    gt   userid     echo  db- gt lastInsertId      What happens here is that I push in my table two new rows  The id of the table is auto-increment  Here  for the same user  I add two rows with a different varNumb   The echoed value at the end will be equal to the id of the row where varNumb 1  which means not the id of the last row  but the id of the first row that was added in the last request

User · Answer

I found an answer in the above link http   php net manual en function mysql-insert-id php  The answer is   mysql query  INSERT INTO tablename  columnname  values    value              echo  Id mysql insert id

User · Answer

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

[php] PHP/MySQL insert row then get 'id'

Examples related to php

Examples related to mysql