How to insert an array to database in Laravel 5.6

Question

How to insert an array to database in Laravel 5.6 Array in controller

public function insert(Request $request )
{
    $idsArry = $request->input('id'); 

    DB::table('work_user')->insert(array(['WorkID' => $idsArry]));

    return redirect ("/works_assign")->with("Success", "Deleted Successfully") ;
}

json_encode(['WorkID'=>$idsArry]) your array and save it in a varchar or text — Muhammad
– Muhammad, Commented Jan 14, 2020 at 9:23
you would like to insert multiple row for each id in $idsArry there; or you can just json_encode() the array and json_decode() to get data back. — Anmup Giri
– Anmup Giri, Commented Jan 14, 2020 at 9:25
Id int(11) WorkID int(11) CusName varchar(100) $idsArry=[1,2,3]; @TsaiKoga — Test Check
– Test Check, Commented Jan 14, 2020 at 9:39

mohammad fallahpoor · Accepted Answer · 2020-01-14 14:28:09Z

0

  $array = [
    'one' => $one,
    'two' => $two,
    'nine' => $nine,
    'ten' => $ten,
   ];

  YourModel::create($array)

answered Jan 14, 2020 at 14:28

mohammad fallahpoor

583 bronze badges

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

1 Comment

mohammad fallahpoor Over a year ago

@ArunVinoth this is easy, just put array in create() and it will work

Collectives™ on Stack Overflow

How to insert an array to database in Laravel 5.6

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related