Can't insert array with a variable in Laravel Controller

Question

I'm trying to insert an array in my database with a variable member_id.

HTML

My Controller

This work without member_id

 foreach ($request->moreFields as $key => $value) {
                Permit::create($value);
  }

This doesn't work with member id

foreach ($request->moreFields as $key => $value) {
            Permit::create([    
                'member_id' => $member_id,
                'license_type' => $request->license_type[$i],
                'license_number' => $request->license_number[$i],
                'registration_date' => $request->registration_date[$i],
                'expiration_date' => $request->expiration_date[$i],
            ]);
        }

I'm trying to insert an array with a variable so that it can have relationships in the member's table

Tpojka · Accepted Answer · 2022-05-01 14:33:18Z

2

You can just modify the array before insert it to Database like array_merge(),

foreach ($request->moreFields as $key => $value) {
    Permit::create(array_merge($value, ['member_id' => $member_id]));
}

edited May 1, 2022 at 14:33

Tpojka

7,0812 gold badges32 silver badges41 bronze badges

answered May 1, 2022 at 12:27

Localhousee

9321 gold badge7 silver badges18 bronze badges

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

Comments

rgdigi · Accepted Answer · 2022-05-01 11:51:21Z

0

I can't see the rest of the code to be sure but my guess is you're using a closure which removes $member_id form the scope of your loop. If that's the case, then the use keyword will allow you to access variables outside of the scope of the closure. For example -

function () use ($member_id) { // pass $member_id into scope of closure
    foreach ($request->moreFields as $key => $value) {
        Permit::create([    
            'member_id' => $member_id,
            'license_type' => $request->license_type[$i],
            'license_number' => $request->license_number[$i],
            'registration_date' => $request->registration_date[$i],
            'expiration_date' => $request->expiration_date[$i],
        ]);
    }
};

answered May 1, 2022 at 11:51

rgdigi

1,7462 gold badges21 silver badges31 bronze badges

3 Comments

Harvz Mendoza Over a year ago

\DB::transaction(function () use($request,$member_id, $license){ actually i have in db::transaction

Harvz Mendoza Over a year ago

i tried same as here positronx.io/… but want to add member_id

rgdigi Over a year ago

Then I guess member_id isn't returning anything, and if there are no errors then it's failing gracefully. If this is an AJAX call what is the response in dev tools? And how is member_id defined?

Collectives™ on Stack Overflow

Can't insert array with a variable in Laravel Controller

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related