I am trying to submit this data to a database in Laravel. My intention is to submit all at the same time, this is just two rows but I would like to send them together even if it gets to 10 rows I can submit.
0: {item: "Electronics", subitem: "Laptop", subitem2: "Hard D", unit: "Length - meter (m)"}
1: {item: "Electronics", subitem: "Laptop", subitem2: "Hard D", unit: "Length - meter (m)"}
What I have tried
for ($i = 1; $i < count($request->all()); $i++) {
$answers[] = [
'item' => $request->item[$i],
'subitem' => $request->subitem[$i],
'subitem2' => $request->subitem2[$i]
];
I tried to do a for loop using the above code but its not working..got the below error
count(): Parameter must be an array or an object that implements Countable
So after discussion in comments the solution for what you are trying to achieve can be:
foreach ($request->all() as $data){
Items::insert([
'item' => $data['item'],
'subitem' => $data['subitem'],
'subitem2' => $data['subitem2'],
'unit' => $data['unit']
]);
}
If you don't have a model and you literally insert using DB facade then you can do:
DB::table('items')->insert([
'item' => $data['item'],
'subitem' => $data['subitem'],
'subitem2' => $data['subitem2'],
'unit' => $data['unit']
]);
But you must build dedicated models.
Also you need to validate your input, $request->all() is way too general but this is a suggestion for future improvements and something to keep in mind.
Don't trust the data that the users are sending from the front-end. Back-end should always validate.
Take a look at the laravel documentation here: https://laravel.com/docs/8.x/queries#insert-statements
Here is an example of they use for inserting multiple records
DB::table('users')->insert([
['email' => 'picard@example.com', 'votes' => 0],
['email' => 'janeway@example.com', 'votes' => 0],
]);