Level 75
It's same way like with DB::table(), but instead of that you can use model.
https://laravel.com/docs/8.x/queries#insert-statements
CollectionProduct::insert($data);
where $data is your array.
1 like
Apr 18, 2021
2
Level 5
How to insert data into Database with Eloquent laravel
array:2 [
0 => array:2 [
"collection_id" => 93
"product_id" => 1000092
]
1 => array:2 [
"collection_id" => 93
"product_id" => 1000093
]
]
Here, collection_id will be same for all products.
I have a database table named collection_products which have only two fields collection_id and product_id. Also have its' correspond Model CollectionProduct.php
Now, how can I insert the above data with Eloquent Model? I don't want to use DB::table()
Level 75
It means you don't have an array like you described above.
You may insert several records at once by passing an array of arrays.
Please or to participate in this conversation.