Laravel database insert with combining array and string

Question

I should insert an array such as $attendanceList = [18354012,18354013,18354014,18354015] and $present = "FALSE" and same for all item of $attendanceList. As you see $attendanceList is array but $present is String.

When I insert like DB::table("attendance")->insert(["id"=>$attendanceList,"present"=>"FALSE"]) returns error.

What should I do? Pairing all item of $attendanceList and $present or there are another ways?

Note: I don't want to use loop if it is possible.

Are you trying to insert four rows? Or one row with four values in a single column? — Alex Howansky
– Alex Howansky, Commented May 2, 2022 at 15:27
@AlexHowansky second one, I try to insert four rows with same $present value. — Wtow
– Wtow, Commented May 2, 2022 at 15:28

Slava Rozhnev · Accepted Answer · 2022-05-02 20:40:38Z

1

You can prepare array from your data and do bulk insert in one query:

<?php
$attendanceList = [18354012,18354013,18354014,18354015];
$present = "FALSE";

$insertData = array_map(
    fn($el)=>['id'=>$el, 'present'=>$present],
    $attendanceList
);

$db::table("attendance")->insert($insertData);

Test Laravel DB insert online

answered May 2, 2022 at 20:40

Slava Rozhnev

10.2k6 gold badges27 silver badges43 bronze badges

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

3 Comments

Wtow Over a year ago

I think that is better as syntax than a loop but come to the same thing. Maybe I can put the reference.

Slava Rozhnev Over a year ago

@Wtow, I'm not sure but consider eloquent insert with array process bulk insert instead multiple single inserts in loop

Wtow Over a year ago

That is good idea to optimize database querry if not possible to optimize loop.

Alex Howansky · Accepted Answer · 2022-05-02 15:32:54Z

0

I'm not sure why you don't want to use a loop. If you want to insert four separate rows, you're going to need one:

foreach ($attendanceList as $id) {
    DB::table("attendance")->insert(["id" => $id,"present" => $present]);
}

answered May 2, 2022 at 15:32

Alex Howansky

54k8 gold badges85 silver badges102 bronze badges

2 Comments

Wtow Over a year ago

I have some for loop before this statement, so another for loop will increase complexity. Thank you for your answer, but I prefer to not use if it is possible.

Alex Howansky Over a year ago

You can not perform this insert without a loop somewhere. Stop micro-optimizing.

Collectives™ on Stack Overflow

Laravel database insert with combining array and string

2 Answers 2

3 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related