insert multiple checkbox values in multiple rows in db

Question

  <form action="{{ route('associates_staff') }}" method="POST" class="card-title mb-0" style="margin-left: 5px">
                        @csrf
                        @method('PATCH')
                        <table class="table">
                            <thead>
                                <tr>
                                    <th class="d-none d-md-table-cell">Area e Subarea</th>
                                    <th class="d-none d-md-table-cell" style="text-align: center">Check Per Associare</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($selectA as $item)
                                    <tr>
                                        <td style="color:red;">Area Selezionata :
                                             {{ $item->nome_area }}
                                        </td>
                                        <td style="text-align: center">
                                            <input type="checkbox" name="selezionearea" value="{{ $item->nome_area }}" checked />
                                        </td>
                                    </tr>
                                @endforeach
                                @foreach ($selectS as $item)
                                    <tr>
                                        <td>Subarea : {{ $item->subareas }}</td>
                                        <td style="text-align: center">
                                            <input type="checkbox" name="subarea[]" value="{{ $item->subareas }}" />
                                        </td>
                                    </tr>
                                @endforeach
                                </tr>
                            </tbody>
                        </table>
                        <div id="buttinsert">
                            <input type="text" name="employee" value="{{ $search }}" hidden />
                            <button class="btn btn-lg btn-success" type="submit">
                                ASSOCIA
                            </button>
                        </div>
                        </form>

/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $subareas = $request->subarea;

    for ($i = 0; $i < count($subareas); $i++) {
        $subarea = $subareas;
        $area = $request->selezionearea;
        $employee = $request->employee;

        DB::insert(
            'insert into assoc (nome_area,employee,subarea)
        values (?,?,?)',
            [$area, $employee, $subarea]
        );

        DB::table('personale')->where('nome_cognome', $employee)->update(['status' => 'Assegnato']);

        return $this->index($request)->withErrors(['msgSuccess' => 'Associazione Completata']);
    }

error : Array to string conversion

Welcome to SOF, Moreno! Please edit your question to provide more details, such as what your problem is. Check out stackoverflow.com/help/how-to-ask for more details. — Ars_Codicis
– Ars_Codicis, Commented Apr 8, 2023 at 16:45
$subarea = $subareas[$i]; also, u can use buli insert for only one query to db, queries in the loop is not really good — InDevX
– InDevX, Commented Apr 8, 2023 at 16:46
$subarea = $subareas[$i]; I insert only the first value of the array and not all I would like id 1 and id 2 with subarea the different values — Morex
– Morex, Commented Apr 8, 2023 at 16:58

Khang Tran · Accepted Answer · 2023-04-09 00:50:37Z

1

Because $subareas is an array, you can't insert to table. You should also insert multiple records to table one time. You can consider doing:

$insertedData = [];

foreach ($subareas as $subarea) {
    $insertedData[] = [
        'nome_area' => $request->selezionearea,
        'employee' => $request->employee,
        'subarea' => $subarea
    ];
}

DB::table('assoc')->insert($insertedData);

DB::table('personale')->where('nome_cognome', $request->employee)->update(['status' => 'Assegnato']);

return $this->index($request)->withErrors(['msgSuccess' => 'Associazione Completata']);

answered Apr 9, 2023 at 0:50

Khang Tran

2,3353 gold badges9 silver badges14 bronze badges

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

1 Comment

Morex Over a year ago

thank you very much what I wanted.....

Collectives™ on Stack Overflow

insert multiple checkbox values in multiple rows in db

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related