Get the Last Inserted Id Using Laravel Eloquent

Question

I m currently using the below code to insert data in a table    lt  php  public function saveDetailsCompany          post   Input  All          data   new Company       data- gt nombre    post  name         data- gt direccion    post  address         data- gt telefono    post  phone         data- gt email    post  email         data- gt giro    post  type         data- gt fecha registro   date  Y-m-d H i s         data- gt fecha modificacion   date  Y-m-d H i s         if   data- gt save              return Response  json array  success    gt  true   200             I want to return the last ID inserted but I don t know how to get it   Kind regards

User · Answer

Use insertGetId to insert and get inserted id at the same time   From doc     If the table has an auto-incrementing id  use the insertGetId method   to insert a record and then retrieve the ID    By Model   id   Model  insertGetId   name   gt  Niklesh   email   gt  myemail gmail com       By DB   id   DB  table  users  - gt insertGetId   name   gt  Niklesh   email   gt  myemail gmail com       For more details   https   laravel com docs 5 5 queries inserts

User · Answer

After saving model  the initialized instance has the id    report   new Report     report- gt user id    request- gt user id   report- gt patient id    request- gt patient id   report- gt diseases id    request- gt modality   isReportCreated    report- gt save    return  report- gt id      this will return the saved report id

User · Answer

This worked for me in laravel 4 2   id   User  insertGetId        username    gt  Input  get  username         password    gt  Hash  make  password         active      gt  0

User · Answer

You can get last inserted id with same object you call save method     data- gt save     inserted id    data- gt id    So you can simply write    if   data- gt save          return Response  json array  success    gt  true  inserted id   gt  data- gt id   200

User · Answer

After saving a record in database  you can access id by  data- gt id  return Response  json   success    gt  true   last insert id    gt   data- gt id   200

User · Answer

After Saving  data- gt save    all data is pushed inside  data  As this is an object and the current row is just saved recently inside  data  so last insertId will be found inside  data- gt id    Response code will be   return Response  json array  success    gt  true   last insert id    gt   data- gt id   200

User · Answer

If the table has an auto-incrementing id  use the insertGetId method to insert a record and then retrieve the ID    id   DB  table  users  - gt insertGetId        email    gt   john example com        votes    gt  0       Refer  https   laravel com docs 5 1 queries inserts

User · Answer

After save   data- gt id should be the last id inserted    data- gt save     data- gt id    Can be used like this     return Response  json array  success    gt  true   last insert id    gt   data- gt id   200     For updated laravel version try this  return response  - gt json array  success    gt  true   last insert id    gt   data- gt id   200

User · Answer

Optional method will be    lastID   DB  table  EXAMPLE-TABLE                   - gt orderBy  id    desc                   - gt first      lastId    lastProduct- gt id     Source from Laravel 5 8 version

User · Answer

You can also try like this   public function storeAndLastInrestedId          data   new ModelName         data- gt title    request- gt title       data- gt save          last insert id    data- gt id      return  last insert id

User · Answer

public function store  UserStoreRequest  request          input    request- gt all         user   User  create  input        userId  user- gt id

User · Answer

You can easily fetch last inserted record Id    user   User  create  userData    lastId    user- gt value  id      It s an awesome trick to fetch Id from the last inserted record in the DB

User · Answer

xdazz is right in this case  but for the benefit of future visitors who might be using DB  statement or DB  insert  there is another way   DB  getPdo  - gt lastInsertId

User · Answer

For insert    Example    data1   array            company id       gt   company id            branch id           gt   branch id           insert id   CreditVoucher  insert  data1    id   DB  getPdo  - gt lastInsertId    dd  id

User · Answer

The shortest way is probably a call of the refresh   on the model   public function create array  data   MyModel        myModel   new MyModel  dataArray        myModel- gt saveOrFail        return  myModel- gt refresh

User · Answer

Here s an example   public static function saveTutorial          data   Input  all          Tut   new Tutorial       Tut- gt title    data  title         Tut- gt tutorial    data  tutorial            Tut- gt save         LastInsertId    Tut- gt id       return Response  json array  success    gt  true  last id   gt  LastInsertId   200

User · Answer

Although this question is a bit dated  My quick and dirty solution would look like this    last entry   Model  latest  - gt first      But I guess it s vulnerable to race conditions on highly frequented databases

User · Answer

Here is how we can get last inserted id in Laravel 4     public function store          input   Input  all          validation   Validator  make  input  user   rules        if   validation- gt passes                 user   this- gt user- gt create array               name                 gt  Input  get  name                 email                gt  Input  get  email                 password             gt  Hash  make Input  get  password                          lastInsertedId   user- gt id    get last inserted record s user id value          userId  array  user id   gt  lastInsertedId     put this value equal to datatable column name where it will be saved          user- gt update  userId     update newly created record by storing the value of last inserted id             return Redirect  route  users index                  return Redirect  route  users create  - gt withInput  - gt withErrors  validation - gt with  message    There were validation errors

User · Answer

There are several ways to get the last inserted id  All are based on what method do you used when inserting  In your case you can get last Id like the following   data- gt save     data- gt id   For others who need to know how can they get last inserted id if they use other insert methods here is how   Using create   method  book   Book  create   name   gt  Laravel Warrior      lastId    book- gt id   Using insertGetId    id   DB  table  books  - gt insertGetId    name    gt   Laravel warrior           lastId    id   Using lastInsertId   method  lastId   DB  getPdo  - gt lastInsertId      Reference https   easycodesolution com 2020 08 22 last-inserted-id-in-laravel

User · Answer

Using Eloquent Model    user   new Report             user- gt email   johndoe example com      user- gt save     lastId    user- gt id    Using Query Builder   lastId   DB  table  reports  - gt insertGetId   email    gt   johndoe example com

User · Answer

For Laravel  If you insert a new record and call  data- gt save   this function executes an INSERT query and returns the primary key value  i e  id by default    You can use following code   if  data- gt save          return Response  json array  status    gt  1   primary id   gt  data- gt id   200

User · Answer

For Laravel       Firstly create an object  Then set attributes value for that object  Then save the object record  and then get the last inserted id  such as   user   new User              user- gt name    John       user- gt save         Now Getting The Last inserted id   insertedId    user- gt id   echo  insertedId

User · Answer

You can use  this constructor variable to achieve  Last Inserted Id Using Laravel Eloquent   without adding any extra column  in current function or controller   public function store Request  request        request- gt validate            title    gt   required max 255            desc    gt   required max 5000                this- gt project   Project  create            name    gt   request- gt title           description    gt   request- gt desc               dd  this- gt project- gt id      This is your current latest project id      request- gt session  - gt flash  project added   Project added successfully         return redirect  - gt back

User · Answer

objPost   new Post   objPost- gt title    Title    objPost- gt description    Description       objPost- gt save     recId    objPost- gt id     If Id in table column name if other then id then user the other column name  return Response  json   success    gt  true  id    gt   recId   200

User · Answer

Here it is how it worked for me  family id is the primary key with auto increment I am using Laravel7     public function store Request  request            family   new Family             family- gt family name    request- gt get  FamilyName             family- gt family no    request- gt get  FamilyNo             family- gt save              family id is the primary key and auto increment         return redirect   family detail       family- gt family id          Also in the Model Family file which extends Model  should have the increment set to true otherwise the above  family-- gt family id will return empty     public  incrementing   true

User · Answer

You can do this    result app  db  - gt insert  INSERT INTO table         lastInsertId app  db  - gt getPdo  - gt lastInsertId

User · Answer

After   data- gt save      data- gt id will give you the inserted id   Note  If your autoincrement column name is sno then you should use  data- gt sno and not  data- gt id

User · Answer

For anyone who also likes how Jeffrey Way uses Model  create   in his Laracasts 5 tutorials  where he just sends the Request straight into the database without explicitly setting each field in the controller  and using the model s  fillable for mass assignment  very important  for anyone new and using this way   I read a lot of people using insertGetId   but unfortunately this does not respect the  fillable whitelist so you ll get errors with it trying to insert  token and anything that isn t a field in the database  end up setting things you want to filter  etc  That bummed me out  because I want to use mass assignment and overall write less code when possible  Fortunately Eloquent s create method just wraps the save method  what  xdazz cited above   so you can still pull the last created ID     public function store           input   Request  all         id   Company  create  input - gt id       return redirect  company    id

User · Answer

In laravel 5  you can do this       use App Http Requests UserStoreRequest  class UserController extends Controller       private  user      public function    construct  User  user                  this- gt user    user            public function store  UserStoreRequest  request                 user   this- gt user- gt create                name                 gt   request  name                 email                gt   request  email                 password             gt  Hash  make  request  password                         lastInsertedId   user- gt id

User · Answer

For get last inserted id in database You can use   data   new YourModelName   data- gt name    Some Value    data- gt email    abc mail com    data- gt save     lastInsertedId    data- gt id    here  lastInsertedId will gives you last inserted auto increment id

User · Answer

Using Eloquent Model   use App Company   public function saveDetailsCompany Request  request      createcompany Company  create   nombre   gt  request- gt input  name    direccion   gt  request- gt input  address    telefono   gt  request- gt input  phone    email   gt  request- gt input  emaile    giro   gt  request- gt input  type          Last Inserted Row ID  echo  createcompany- gt id       Using Query Builder   createcompany DB  table  company  - gt create   nombre   gt  request- gt input  name    direccion   gt  request- gt input  address    telefono   gt  request- gt input  phone    email   gt  request- gt input  emaile    giro   gt  request- gt input  type       echo  createcompany- gt id    For more methods to get Last Inserted Row id in Laravel   http   phpnotebook com 95-laravel 127-3-methods-to-get-last-inserted-row-id-in-laravel

User · Answer

In Laravel 5 2 i would make it as clean as possible   public function saveContact Request  request  Contact  contact        create    contact- gt create  request- gt all        return response  - gt json  create- gt id   201

[php] Get the Last Inserted Id Using Laravel Eloquent

Examples related to php

Examples related to database

Examples related to laravel

Examples related to eloquent