php - 如何使用相同名称的输入类型更新多个 mysql 行

Question

我正在创建一个网站。在这个网站中，只有一个 html 表单。但是，我将该表单包含在 foreach 中，然后根据数据库循环该表单。现在，我想更新表格。当我一次绑定(bind)一个表单时，我能够更新数据库值。但是，我无法一次更新所有表格。

如何通过单击一下按钮一次性更新所有表单？

这是路线。

Route::put('/UserBookingDetailsUpdate/{id}', 'PaymentController@UserBookingDetailsUpdate');

这里是 View 。 (MyDetails.blade.php)

    <?php $count = 0; ?>
    @foreach($GetAdultDetails as $GetAdultDetail)

    <?php $count = $count + 1; ?>

    <form class="form-horizontal UserBooking" action="{{ url('UserBookingDetailsUpdate/' .$GetAdultDetail['id']) }}" method="POST" enctype="multipart/form-data" id="UserBookingDetailsForm_{{$count}}">

    {{ method_field('PUT') }}
    {{ csrf_field() }}

        <div class="panel panel-default">

        <div id="collapseOne_{{$count}}" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingOne">
            <div class="panel-body">

                <div class="row col-md-12">
                <p class="de_topic" style="margin-top: 5px;">Personal Information</p>

                <div class="form-group adult_space col-md-6 col-xs-6 respo_pdin">
                    <label class="col-sm-4 control-label adult_topic de_fname respo_pdin">First name</label>
                    <div class="col-sm-8 respo_pdin">
                    <div class="input-group adult_group">
                        <input type="text" class="form-control adult_input" value="{{$GetAdultDetail['adult_first_name']}}" name="adult_first_name" aria-label="...">
                    </div><!-- id[{{$GetAdultDetail['id']}}]['fname'] /input-group -->
                        </div>
                    </div>

                    <div class="form-group adult_space col-md-6 col-xs-6 respo_pdin">
                        <label class="col-sm-4 control-label adult_topic de_fname respo_pdin">Last name</label>
                            <div class="col-sm-8 respo_pdin">
                            <div class="input-group adult_group">
                            <input type="text" class="form-control adult_input" value="{{$GetAdultDetail['adult_last_name']}}" name="adult_last_name" aria-label="...">
                            </div><!-- id[{{$GetAdultDetail['id']}}]['lname'] /input-group -->
                            </div>
                    </div>

                    <div class="form-group adult_space col-md-6 col-xs-6 respo_pdin" style="margin-bottom: 9px;">
                        <label class="col-sm-4 control-label adult_topic de_fname respo_pdin">Gender</label>
                        <div class="col-sm-8 bh respo_pdin">
                            <select class="selectpicker" data-style="select-with-transition" name="adult_gender" title="Choose Adult" data-size="7">
                            <option value="Male">Male</option>
                            <option value="Female">Female</option>
                            </select>
                        </div>
                    </div>

            </div>

        </div>

            <div class="row col-md-12">
                <div class="">
                <a role="button" data-toggle="collapse" data-parent="#accordion" href="#collapseMore_01_{{$count}}" aria-expanded="false" aria-controls="collapseMore_01" role="tab" id="headingOne1" class="titlec">
                <p class="panel-title_01">
                    More details <span class="arrow"><span></span><span></span></span>
                </p>
                </a>
            </div>

            <div class="panel panel-default in_panel">

                <input type="submit" value="Save" name="AdultSaveNow_{{$count}}" class="btn btn-default fghkl de_save AdultSaveNow_{{$count}}" id="AdultSaveNow_{{$count}}">
                </div>
            </div>
        </div>
    </div>
</form>
@endforeach

这是 Controller 。 (MyDetailsController.php)

 public function UserBookingDetailsUpdate(Request $request,$id)
{
    $adult_usersCount = PassengerAdultDetails::where('pnr_id', $id)->get();
    //$adult_usersNew = PassengerAdultDetails::find($id);

    $GetAdults = DB::table('passenger_adult_details')->where('pnr_id', $id)->get()->toArray();

 // for($i = 0; $i < $adult_usersCount->count() ; $i++)
    //{
      //$GetAdults = DB::table('passenger_adult_details')->where('pnr_id', $id)->get();
      //echo $GetAdults[$i]->id ."<br>"; die();

        $adult_users = PassengerAdultDetails::find($id);
        $adult_users->adult_first_name = $request->get('adult_first_name');
        $adult_users->adult_last_name = $request->get('adult_last_name');
        $adult_users->adult_gender = $request->input('adult_gender');
        $adult_users->update();

    //}

    return redirect()->back();

}

Answer 1

将表单放入 foreach 实际上会创建多个表单，并且您一次只能从 HTML 提交一个表单(如果您不执行 JS/AJAX 操作)。

将表单放在 foreach 之外，并创建一个 input 数组。

例如:

在 View 中:

    <form class="form-horizontal UserBooking" action="{{ url('UserBookingDetailsUpdate'}}" method="POST" enctype="multipart/form-data">

    <?php $count = 0; ?>
    @foreach($GetAdultDetails as $GetAdultDetail)

    <?php $count = $count + 1; ?>


    {{ method_field('PUT') }}
    {{ csrf_field() }}

        <div class="panel panel-default">

        <div id="collapseOne_{{$count}}" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingOne">
            <div class="panel-body">

                        <input type="hidden" value="{{$GetAdultDetail['id']}}" name="adults[{{$count}}][id]">


                <div class="row col-md-12">
                <p class="de_topic" style="margin-top: 5px;">Personal Information</p>

                <div class="form-group adult_space col-md-6 col-xs-6 respo_pdin">
                    <label class="col-sm-4 control-label adult_topic de_fname respo_pdin">First name</label>
                    <div class="col-sm-8 respo_pdin">
                    <div class="input-group adult_group">
                        <input type="text" class="form-control adult_input" value="{{$GetAdultDetail['adult_first_name']}}" name="adults[{{$count}}][first_name]" aria-label="...">
                    </div><!-- id[{{$GetAdultDetail['id']}}]['fname'] /input-group -->
                        </div>
                    </div>

                    <div class="form-group adult_space col-md-6 col-xs-6 respo_pdin">
                        <label class="col-sm-4 control-label adult_topic de_fname respo_pdin">Last name</label>
                            <div class="col-sm-8 respo_pdin">
                            <div class="input-group adult_group">
                            <input type="text" class="form-control adult_input" value="{{$GetAdultDetail['adult_last_name']}}" name="adults[{{$count}}][last_name]" aria-label="...">
                            </div><!-- id[{{$GetAdultDetail['id']}}]['lname'] /input-group -->
                            </div>
                    </div>
               </div>

    ...    ...
    ...    ...
    ...    ...

        </div>
    </div>
@endforeach
            <div class="panel panel-default in_panel">

                <input type="submit" value="Save" name="AdultSaveNow" class="btn btn-default fghkl de_save AdultSaveNow" id="AdultSaveNow">
                </div>
            </div>
</form>

在 Controller 中:

<?php
...
...

public function UserBookingDetailsUpdate(Request $request)
{
    $adults = $request->input('adults');
    foreach($adults as $adult) {
        $adult_users = PassengerAdultDetails::find($adult['id']);
        $adult_users->adult_first_name = $adult['first_name'];
        $adult_users->adult_last_name  = $adult['last_name'];
        $adult_users->adult_gender     = $adult['gender'];
        $adult_users->update();

    }

    return redirect()->back();

}

在路线中:

Route::put('/UserBookingDetailsUpdate', 'PaymentController@UserBookingDetailsUpdate');