bulk insert the Array still Considered as Object NOT DUPLICATE

Question

i try the answer to this about bulk insert in laravel Query builder. my query output is

[
 {"name":"Dayle","id":1,"email":"[email protected]"},
 {"name":"John","id":2,"email":"[email protected]"}
]

but when i try

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

i get error Query\Builder::insert() must be of the type array, object given,

when i try

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

i get error Object of class stdClass could not be converted to string.

how can i insert inn bulk ?

Answer 1

$data is encoded as JSON object, you need to decode it to make an array:

$data = json_decode($x, true); // array
DB::table('staff')->insert($data);