Home / Questions / 303670
Accepted
Noob Dev
Asked: 2020-10-26 10:59:39 +0800 CST 2020-10-26 10:59:39 +0800 CST

How to get last inserted ID in Laravel?

  • 772

I'm working on Backpack and I need to save a variable that ends with the number of the last ID.

I have tried the following in the store method of my CRUD Controller, in the $last variable I want to store the value of the ID of the last record.

I have seen the last() and lastInsertId() methods but I don't know how to implement them in my solution.

<?php
public function store(StoreRequest $request)
{

    $rfc = ...
    $cli_rfc = ...
    $date = ...

    $last = Object::all()->lastInsertId();

    $request->ultimo_numero =
        $rfc.'-'.
        $cli_rfc.'-'.
        $date. '/'.
        $last->id+1;
    $request->request->set('ultimo_numero',$request->ultimo_numero);
    // your additional operations before save here
    $redirect_location = parent::storeCrud($request);
    // your additional operations after save here
    // use $this->data['entry'] or $this->crud->entry
    return $redirect_location;
}
laravel

2 Answers

  1. Best Answer

    I don't know about backpack, but with Eloquent you can get the most recent record and set a variable equal to that value like so:

    $data = Modelo::latest('id')->first();

    Pass latest()the column as an argument to the method idso that it is by this that you order descending and thus obtain the last record made.

    You chain the method firstto only return the first record

    • 4

  2. Backpack offers you the new model generated by calling either of these two variables

    $model = $this->data['entry'];
$model = $this->crud->entry;

    In both cases it just points to id

    $latest_id = $model->id;
    • 2