Laravel DB Query insert list of ids

Question

How I can insert a list of ids with DB query without use foreach.

example with foreach :

$ids=[1,3,5];
foreach ($ids as $id) {
    DB::Table('user')->insert(['name'=>'test','user_id'=>$id]);
}

Ersoy · Accepted Answer · 2020-06-25 17:41:40Z

1

You may use array_map;

$ids = [1, 3, 5];
$data = array_map(function ($id) {
    return ['name' => 'test', 'id' => $id];
}, $ids);

DB::table('user')->insert($data);

answered Jun 25, 2020 at 17:41

Ersoy

9,8046 gold badges40 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

This solution will make me connect to the database only once, Thanks