Laravel Input array update with single submit

Question

I am updating a header amount with each header i am new to laravel please help below is my table, forms, view and controller update function code

View Add Head Name

div class="tab-pane fade show active" id="pills-home" role="tabpanel" aria-labelledby="pills-home-tab">
            <form action="/headers" method="POST">
                @csrf
                <div class="row">
                    <div class="col">
                        <label for="">Header Name</label>
                        <input type="text" name="header_name" required="required">
                        <input type="submit" class="btn btn-primary" name="submit">
                    </div>
                </div>
            </form>
        </div>

View Add Head Amount

<div class="tab-pane fade" id="pills-profile" role="tabpanel" aria-labelledby="pills-profile-tab">
            <form action="/headers" method="POST">
                @csrf
                @foreach ($data as $header)
                    <div class="row">
                        <div class="col">
                            <label for="">Header Name</label>
                            <input type="text" name="header_name[]" value="{{$header->header_name}}" required="required" readonly="readonly">
                            <input type="number" min="0" name="header_amount[]" placeholder="Amount" required="required">
                        </div>
                    </div>
                @endforeach
                <input type="submit" class="btn btn-primary" name="submit1">
            </form>
        </div>

Controller Function

$count = Header::count();
for ($i = 1; $i <= $count; $i++)
            {
                $header = Header::find($i);
                $header->header_amount = $request->input('header_amount');
                $header->save();
            }
            exit();

Maulik Shah · Accepted Answer · 2019-02-23 08:42:30Z

1

Try this code:

$count = Header::count();
$header = Header::find($i);

foreach ($header as $key => $detail) {
   $header->header_amount = $request->input('header_amount')[$key];
   $detail->save();
}

I hope it would be helpful.

answered Feb 23, 2019 at 8:42

Maulik Shah

1,0501 gold badge8 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Amir Khan Over a year ago

thanks got the logic from your code this works

$header = Header::all();             foreach ($header as $key => $detail)             {                 $detail->header_amount = $request->input('header_amount')[$key];                 $detail->save();             }

Rwd · Accepted Answer · 2019-02-23 08:59:52Z

1

I would suggest adding the header ids[] as a hidden input so that you don't have to initially get all of the Header's which will mean one less query.

<div class="row">
    <div class="col">
        <input type="hidden" name="ids[]" value="{{ $header->id }}">
        <label for="">Header Name</label>
        <input type="text" name="header_name[]" value="{{$header->header_name}}" required="required" readonly="readonly">
        <input type="number" min="0" name="header_amount[]" value="{{ $header->header_amount }}" placeholder="Amount" required="required">
    </div>
</div>

Then in your controller you could have something like:

$amounts = request('header_amount');

foreach (request('ids') as $key => $id) {
    Header::where('id', $id)->update(['header_amount' => $amounts[$key]]);
}

answered Feb 23, 2019 at 8:59

Rwd

35.3k7 gold badges71 silver badges85 bronze badges

1 Comment

Amir Khan Over a year ago

will try this great one less query

Amir Khan · Accepted Answer · 2019-02-23 10:19:14Z

0

Getting all data from headers table and using foreach loop to update each header row amount

$header = Header::all();
            foreach ($header as $key => $detail)
            {
                $detail->header_amount = $request->input('header_amount')[$key];
                $detail->save();
            }
            exit();

edited Feb 23, 2019 at 10:19

answered Feb 23, 2019 at 8:56

Amir Khan

4415 silver badges14 bronze badges

2 Comments

Amir Khan Over a year ago

sure i added little explaination

Nico Haase Over a year ago

Please explain what you need to change in the original code and why

Collectives™ on Stack Overflow

Laravel Input array update with single submit

3 Answers 3

1 Comment

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related