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, May 12 '13 at 14:02

Muhammad Usman · Accepted Answer · 2013-05-29T13:41:49.357

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 '13 at 13:41

answered May 12 '13 at 14:04

Muhammad Usman

12,439
6
36
59

This is the answer. What's the meaning of {} in PHP? I never use them, but I often see people using { } between " " brackets. – Aristona May 12 '13 at 14:07
This is not. An array have to be used instead – Your Common Sense May 12 '13 at 14:08
@Imaqtpie There are various uses of `{}`, but here it allows you to use dynamic property name. – Muhammad Usman May 12 '13 at 14:10
@YourCommonSense Would like to hear why it shouldn't work, have you tested? – Muhammad Usman May 12 '13 at 14:12
Here are some: http://stackoverflow.com/q/2596837/656489 , Googling will show other uses. – Muhammad Usman May 12 '13 at 14:18

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

1 Answers1