Hello Devs, 

In this tutorial, we will learn Laravel insertGetId multiple Rows Example

The use of insertGetId query in laravel used to insert record and get insert record id. If the table has an auto-incrementing id, use the insertGetId method to insert a record and then retrieve the ID:

Follow this step by step guide below. 



Query 1

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
	$myarray = [
            ['name'=> 'one', 'email' => 'one@gmail.com'],
            ['name'=> 'two', 'email' => 'two@gmail.com'],
            ['name'=> 'three', 'email' => 'three@gmail.com'],
        ];  
        foreach ($myarray as $key => $value) {
            $id[] = User::insertGetId(
                ['email' => $value['email'],'name' => $value['name']]
            );
        }
}


Query 2

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $myarray = [
            ['name'=> 'one', 'email' => 'one@gmail.com'],
            ['name'=> 'two', 'email' => 'two@gmail.com'],
            ['name'=> 'three', 'email' => 'three@gmail.com'],
        ];  
        foreach ($myarray as $key => $value) {
            $id[] = DB::table('users')->insertGetId(
                ['email' => $value['email'],'name' => $value['name']]
            );
        }
}


May this example help you.