How to add a variable value for database columns named as an array?

Question

/* Place uploaded images into appropriate columns. */
for($i = 1; $i <= 5; $i++)
{
    if(Input::file('image' . $i . '.size') >= 1)
    {
        $randomName = substr( md5( rand(1,9999999) ), 1, 15);
        Input::upload('image' . $i, path('public') . 'uploads/backgrounds/', Auth::user()->username . $randomName . '.jpg');

        $wedding= Wedding::where('wedding_owner', '=', Auth::user()->username)->first();
            $wedding->image1 = $randomName;
        $wedding->save();
    }
}

User may upload 5 pictures. The uploaded images should be placed in image1, image2, image3, image4 and image5 columns in wedding table.

Basically,

$wedding->image1 = $randomName;

Should be something like:

$wedding->image{$i} = $randomName;

How can I solve this?

Having enumerated fields names always smells of a bad design — Your Common Sense
– Your Common Sense, Commented May 12, 2013 at 14:02

Muhammad Usman · Accepted Answer · 2013-05-29 13:41:49Z

2

Concat the name inside the {} :

$wedding->{'image' . $i} = $randomName;

Thus you can add dynamic fields/properties to an object/stdClass instance.

edited May 29, 2013 at 13:41

answered May 12, 2013 at 14:04

Muhammad Usman

12.5k6 gold badges39 silver badges60 bronze badges

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

5 Comments

Aristona Over a year ago

This is the answer. What's the meaning of {} in PHP? I never use them, but I often see people using { } between " " brackets.

Your Common Sense Over a year ago

This is not. An array have to be used instead

Muhammad Usman Over a year ago

@Imaqtpie There are various uses of {}, but here it allows you to use dynamic property name.

Muhammad Usman Over a year ago

@YourCommonSense Would like to hear why it shouldn't work, have you tested?

Muhammad Usman Over a year ago

Here are some: stackoverflow.com/q/2596837/656489 , Googling will show other uses.

Collectives™ on Stack Overflow

How to add a variable value for database columns named as an array?

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related