how to insert Multidimensional Arrays with query builder larave

hi, i have value array like this :

^ array:2 [▼
  3 => array:2 [▼
    "id" => "1"
    "name" => "<span>tester1</span>"
  ]
  8 => array:2 [▼
    "id" => "2"
    "name" => "<span>tester2</span>"
  ]
]

how to insert database with query builder in controller laravel ? i need to insert all array value in dimentional

Nakov

3 years ago

Level 73

Have you tried:

DB::table('users')->insert(YOUR_ARRAY);

and the id is most likely auto-incremented field, and it won't be affected by what you pass in your array.

vand

3 years ago

Level 1

sorry im forget, i need to modify my array, like name insert to user_name and the value need using explode to remove before insert to DB,

i cant using, DB::table('users')->insert(YOUR_ARRAY);

Please or to participate in this conversation.