Laravel - Display my array images in view that is stored in one ROW in my Database

Question

I want to display all of my images that is displayed on my database in one ROW. The images are stores in an array in my database so it is in one ROW. Currently in my code the image is not showing and it is UNAVAILABLE

Here is my CONTROLLER

Storing Data

    $this->validate($request, [
        'promotion_image' => 'required'
    ]);

    if ($request->has('promotion_image'))
    {   
        //Handle File Upload

        $promotion = [];
        foreach ($request->file('promotion_image') as $key => $file)
        {
            // Get FileName
            $filenameWithExt = $file->getClientOriginalName();
            //Get just filename
            $filename = pathinfo( $filenameWithExt, PATHINFO_FILENAME);
            //Get just extension
            $extension = $file->getClientOriginalExtension();
            //Filename to Store
            $fileNameToStore = $filename.'_'.time().'.'.$extension;
            //Upload Image
            $path = $file->storeAs('public/promotion_images',$fileNameToStore);
            array_push($promotion, $fileNameToStore);
        }

        $fileNameToStore = serialize($promotion);
    }
    else
    {
        $fileNameToStore='noimage.jpg';
    }


if (count($promotion)) {
        $implodedPromotion = implode(' , ', $promotion);
        $promotionImage = new Promotion;
        $promotionImage->promotion_image = $implodedPromotion;
        $promotionImage->save();

        return redirect('/admin/airlineplus/promotions')->with('success', 'Image Inserted');
    }

    return redirect('/admin/airlineplus/promotions')->with('error', 'Something went wrong.');

Here is my VIEW

 @foreach($promotions as $promotion)
           <tr>  

            <th><img src="{{ asset('storage/promotion_images/' . $promotion->promotion_image) }}" style="width:50px;height:50px;"></th>
 @endforeach

Check your console. It will show the Image URL that couldn't load. According to that URL you need to modify the image path. Can you show you console Error please? — BadPiggie
– BadPiggie, Commented Nov 25, 2018 at 4:43
Please see the new edit. I added the problem .. there is no error just the image are not showing — user10665294
– user10665294, Commented Nov 25, 2018 at 4:46
@BanujanBalendrakumar I Edit the question above please see the image .. It has no error, my problem is that the images are not showing — user10665294
– user10665294, Commented Nov 25, 2018 at 4:46
The error only shows in console. you should check your path. Right-Click on image and click on Open Image in New Tab then show the image URL, And also show the directory tree. — BadPiggie
– BadPiggie, Commented Nov 25, 2018 at 4:48
@BanujanBalendrakumar I did that and it is said The Page cannot be found — user10665294
– user10665294, Commented Nov 25, 2018 at 5:01

Sagar Gautam · Accepted Answer · 2018-11-25 05:20:58Z

0

All you have done for storing images seems okay, what you have to do is explode the image data store in the database. So, change your view code like this:

@foreach($promotions as $promotion)
       <tr>  

        <th>
            @foreach(explode(',' ,$promotion->promotion_image) as $image)
                <img src="{{ asset('storage/promotion_images/' . $image) }}" style="width:50px;height:50px;"><br/>
            @endforeach
        </th>
     </tr>
@endforeach

I think this will work for you. If you have any confusion regarding above code, feel free to ask.

answered Nov 25, 2018 at 5:20

Sagar Gautam

9,4099 gold badges62 silver badges95 bronze badges

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

5 Comments

user10665294 Over a year ago

SO CLOSE ... It stores 1 value .. the other image is not available why is that

Sagar Gautam Over a year ago

@SummerWinter Can you please describe it in more detail so that i might help you

user10665294 Over a year ago

I have a dynamic form using jquery and all images are stored in one ROW.. your code showed me 1 image only I have 2 images in a row in my database.. so the other 1 image is not shown in my view.

Sagar Gautam Over a year ago

@SummerWinter please add the screenshot of the database table

user10665294 Over a year ago

hey sir can you answer this question of mine please link

xzees · Accepted Answer · 2018-11-25 04:43:25Z

0

if (count($promotion)) {
        $implodedPromotion = implode(' , ', $promotion);
        $promotionImage = new Promotion;
        $promotionImage->promotion_image = $implodedPromotion;
        $promotionImage->save();

        return redirect('/admin/airlineplus/promotions',$promotion)->with('success', 'Image Inserted');
    }

    return redirect('/admin/airlineplus/promotions',$promotion)->with('error', 'Something went wrong.');

answered Nov 25, 2018 at 4:43

xzees

1

2 Comments

BadPiggie Over a year ago

Can you explain your answer please?

user10665294 Over a year ago

what's that? it doesnt seems to help me

Collectives™ on Stack Overflow

Laravel - Display my array images in view that is stored in one ROW in my Database

2 Answers 2

5 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related