Save multiple checkbox values ​​and different input values ​​as a whole to the database

Question

I'm trying to insert data/values ​​into my database.

It works, but the problem is that every time I select only the second value/checkbox, its other input values ​​get the value of the first input.

<form action="{{url('/reservation')}}" method="post">
    @csrf
    <div class="row col-12">
        <div>
            <p class='mybox text-dark'><input type="checkbox" name="prod_name[]" value="JasminBooks"/>JasminBooks</p>
        </div>
        <div>
            <input type="number" name="prod_qty[]" min="1" value="1"class="form-control ml-2">
        </div>
    <div class="row col-12">
        <div>
            <p class='mybox text-dark'><input type="checkbox" name="prod_name[]" value="KnowHowBooks"/>KnowHowBooks</p>
        </div>
        <div>
            <input type="number" name="prod_qty[]" min="1" value="1"class="form-control ml-2">
        </div>
    </div>
</form>

This is the code for my controller function

public function reservation(Request $request)
{
    $data = new reservation;
    $data->name = $request->name;
    $data->email = $request->email;
    $data->phone = $request->phone;
    $data->address = $request->address;
    $data->date = $request->date;
    $data->time = $request->time;

    $products = null;
    $checked_array = $_POST['prod_name'];

    foreach($_POST['prod_name'] as $key => $value) {
        if (in_array($_POST['prod_name'][$key], $checked_array)) {
            $products .= $_POST['prod_qty'][$key]." ".$_POST['prod_name'][$key].", ";
        }
    }

    $data->products = $products;
    $data->save();
    return redirect()->back();
}

When

1. When I select the first checkbox and enter a value of 5, the result is "5 JasminBooks,"

2. When I select both checkboxes and enter the quantity 12 in the first input box next to the first checkbox and the second input box next to the second checkbox When the quantity is 7, the result is "12 JasminBooks, 7 KnowHowBooks,"
3. But when I only select the second checkbox and enter 13 in the quantity input box, the result is "1 KnowHowBooks," which takes the default value entered in the first instead of what I entered in the second Insert the quantity 13 into the input box.

What should I add/change in my code?

Answer 1

This is because you define your quantity field based on the index. If one input is missing, it can affect your entire results. Use values ​​as keys:

HTML：

<div>
    <p class='mybox text-dark'><input type="checkbox" name="prod_name[]" value="JasminBooks"/>JasminBooks
    </p></div><div>
    <input type="number" name="prod_qty[JasminBooks]" min="1" value="1"class="form-control ml-2">
</div>

PHP：

$products = '';
$checked_array = $request->input('prod_name', []);
$quantities = $request->input('prod_qty', []);

foreach ($checked_array as $value) {
    if (array_key_exists($value, $quantities)) {
        $products .= "{$quantities[$value]} {$value}, ";
    }
}

// 移除末尾的 ', '
if (! empty($products)) {
    $products = substr($products, 0, -2);
} 

$data->products = $products;

P.S. Like Bhaumik said, don't use $_POST in Laravel.