php - Add multiple data at once in laravel?

I have a field gender, age-group and patient_type. I want to store count for each patient type with age-group and gender. This is my form formData. And this is array of data I get arrayData. Also multiple age-group can be added.

For example, age-group=0-1, new_patient=>male=10,Female=60, old_patient=>male=50, female=20. How can I store this form data for multiple age-groups.

My Form code

<div class="newAgeGroup mt-5" id="newAgeGroup_0">
                <div class="form-group row">
                    <div class="col-md-2">
                        <label for="">Select Age Group</label>
                    </div>
                    <div class="col-md-5 mb-3">
                        <select name="age_id[]" class="form-control" id="">
                            <option value="">Select Age Group</option>
                            @foreach($ages as $age)
                            <option value="{{$age->id}}">{{$age->start_age}}
                                -{{$age->end_age}}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-5">
                            <button type="button" onclick="addAgeGroup();"
                            class="btn btn-primary rounded-0 float-right addAgeGroup">Add Age Group
                        </button>

                    </div>
                </div>
                <table class="table table-bordered">
                    <thead>
                        <tr>
                            <th></th>
                            @foreach($patient_types as $patient_type)
                            <th>
                                {{$patient_type->name}}
                                <input type="hidden" name="patient_type_id[]" value="{{ $patient_type->id }}">
                            </th>
                            @endforeach
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($genders as $gender)
                        <tr>
                            <th>
                                {{$gender->name}}
                                <input type="hidden" name="gender_id[]" value="{{ $gender->id }}">
                            </th>
                            @foreach($patient_types as $patient_type)
                            <?php 
                            $name = 
                            "number_".$patient_type->id."_".$gender->id ;

                            ?>
                            <td>
                                <input type="text" name="{{ $name }}[]" class="form-control">
                            </td>
                            @endforeach
                        </tr>
                        @endforeach
                    </tbody>
                </table>
                
        </div>
Copy code

And this is what I have tried.

foreach ($request->input('age_id') as $key => $value) {
            foreach ($request->input('patient_type_id') as $pt => $ptvalue) {
                foreach ($request->input('gender_id') as $gkey => $gvalue) {

                    foreach ($request->input('number_'.$ptvalue.'_'.$gvalue) as $nkey => $nvalue) {
                        $report = new Report();
                        $report->admin_id = $this->admin()->id;
                        $report->category_id = $request->center_type;
                        $report->center_id = $request->center_id;
                        $report->dateTime = $request->dateTime;
                        $report->nationality = $request->nationality;
                        $report->type = 'OPD';
                        $report->age_id = collect($request->get('age_id')[$key])->implode(',');
                        $report->patient_type_id = collect($request->get('patient_type_id')[$pt])->implode(',');
                        $report->gender_id = collect($request->get('gender_id')[$gkey])->implode(',');
                        $report->number = collect($request->get('number_'.$ptvalue.'_'.$gvalue)[$nkey])->implode(',');
                        $report->save();
                    }
                }
            }
        }Copy code

Undefined asked

2021-12-1

Write your answer

---

34

votes

Answer

Solution:

If I understand well, you want a single age group to have multiple records associated with it.

If that's the case I recommend you, to use relation in the database to achieve that.

For example these two tables:

Age group	age group attributes
id	id
age	age_group_id
	gender
	patient type

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2021-12-1

Link To Source
Link To Answer People are also looking for solutions of the problem: undefined array key

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

720 php - Save data to two different tables in CakePHP 3

11 php - Using JQuery UI's sortable('serialize') after loading data in via .load();

628 Laravel php artisan shows error of JWT

620 php - Insert Variable into Laravel CSV file import array

579 PHP + SQL - Using SQL Server 'Create To' scripts to create tables through PHP

821 PHP running out of memory when uploading to s3 bucket - Laravel 5.2

319 php - Variable disappearing after adding text

502 preg replace - PHP preg_replace multiple rules

223 php - Database Error mysqli_init()

825 php - WooCommerce: Custom function adding free product - Cart page getting broken for orders up to 3000

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.