Laravel - Insert array of objects to the database

Asked Feb 14 '23 at 14:34

Active Feb 14 '23 at 14:34

Viewed 49 times

I have this variable which I want to insert to the database. Basically I want to insert array of objects:

$data['matching_competitors'] = [
    [
        'id_project'            =>  $id_project, 
        'id_product'            =>  $product_id, 
        'link'                  =>  $link, 
        'id_product_competitor' =>  $id_competitor, 
        'link_competitor'       =>  ''
    ], 
    [
        'id_project'            =>  $id_project, 
        'id_product'            =>  $product_id, 
        'link'                  =>  $link, 
        'id_product_competitor' =>  $id_competitor, 
        'link_competitor'       =>  ''
    ], 
    
];

$insert_matching = DB::connection( $db_name )
                ->table( $db_name . '.product_matching')
                ->insert( $data );

but I got an error:

"Array to string conversion"

asked Feb 14 '23 at 14:34

Shibbir

1,963
2
25
48

Your best bet is encoding it to JSON, saving it, and upon retrieval decoding it again. Or create a relation for this? – geertjanknapen Feb 14 '23 at 14:36
Do you mean this `$data = json_encode($data);` – Shibbir Feb 14 '23 at 14:38
4

Is each array a new row? If so, you have one too many array levels. Assign that array to `$data` instead of `$data['matching_competitors']` – aynber Feb 14 '23 at 14:40
Is that a typo ? `->insert( $data['matching_competitors'] );` – angel.bonev Feb 14 '23 at 14:45
@aynber You are correct, thats' what I need :) – Shibbir Feb 14 '23 at 14:48

Laravel - Insert array of objects to the database

0 Answers0