php - How to get last inserted ids in laravel

Question

I am inserting multiple rows at the same time, say 2 rows

$multiple_rows = [
    ['email' => '[email protected]', 'votes' => 0],
    ['email' => '[email protected]', 'votes' => 0]
];
DB::table('users')->insert($multiple_rows);

How can I get those inserted ids.

I am doing it, this way for now.

foreach($multiple_rows as $row){
  DB::table('users')->insert($row);
  $record_ids[] = DB::getPdo()->lastInsertId();
}

Any other good way to do it, without inserting single row each time.

Answer 1

You could do something like the following:

$latestUser = DB::table('users')->select('id')->orderBy('id', 'DESC')->first();

$multiple_rows = [
    ['email' => '[email protected]', 'votes' => 0],
    ['email' => '[email protected]', 'votes' => 0]
];

DB::table('users')->insert($multiple_rows);

$users = DB::table('users')->select('id')->where('id', '>', $latestUser->id)->get();