Skip to main content

How to Get the Latest Inserted Id in Laravel

An inserted id is an automatically-generated number that is assigned to a newly-added row in a database table. This number can be used to reference the row in subsequent queries. In Laravel, after you insert a new record into the database, you may need to get the id of the newly inserted record. For example, if you insert a new user into the user’s table, you may want to get the id of the new user in order to add that user to another table, such as a roles table.

//
$data = new Invoice;
$data->document = 'Invoice/2020/07';
$data->save();
$id = $data->id;

//
$saleId = DB::table('sales')->insertGetId([
    'document' => 'Invoice/2020/07'
]);

//
$order = Order::create(['document' => 'Invoice/2020/07']);
$id = $order->value('id');

By continuing to use the site, you agree to the use of cookies.