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, Jan 14 '20 at 09: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, Jan 14 '20 at 09:25
Id int(11) WorkID int(11) CusName varchar(100) $idsArry=[1,2,3]; @TsaiKoga — Test Check, Jan 14 '20 at 09:39
@TestCheck So I think you want to insert the work_user with `cusName` and `workID`, however, you are inserting array only including `workID`, and another question: is $request->input('id') is a number ? — TsaiKoga, Jan 14 '20 at 09:43
Does this answer your question? [Storing array or std object in database of Laravel app](https://stackoverflow.com/questions/21658926/storing-array-or-std-object-in-database-of-laravel-app) — Rouhollah Mazarei, Jan 14 '20 at 09:49
So you need to get the column value from the `$request` and insert it, like `DB::table('work_user')->insert(['WorkID' => $request->id, 'cusName' => $request->cusName])` — TsaiKoga, Jan 14 '20 at 14:32

score 0 · Answer 1 · answered Jan 14 '20 at 14:28

0

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

  YourModel::create($array)

answered Jan 14 '20 at 14:28

mohammad fallahpoor

48
3

@ArunVinoth this is easy, just put array in create() and it will work – mohammad fallahpoor Jan 15 '20 at 06:53

How to insert an array to database in Laravel 5.6

1 Answers1