problem while trying to display image from database

Question

I am trying to display a row from my database by id, the data displayed successfully but the image doesn't show (showing a broken link icon).

Here is the index.blade.php where the href to the row:

<a href="singlepost/{{$products->id}}">
<img src="storage/{{$templates->image_path2}}">

The route:

Route::get('/singlepost/{id}', 'App\http\controllers\TemplatesController@getPostById')->name('single.post');

The function getPostById

public function getPostById($id){
    $products = DB::table('templates')->where('id', $id)->first();

    return view('singlepost', compact('products'));
}

The singlepage.blade.php

<div class="row">
    <div class="col-lg-4">
        <img src="storage/{{$products->image_path}}">
    </div>
    <div class="col-lg-7">
        <h2>{{$products->name}}</h2>
        <p>{{$products->description}}</p>
    </div>
</div>

Can you share the image link you are getting ? Right click on the broken image icon and click copy image address and paste it here please — matiaslauriti
– matiaslauriti, Commented Jun 6, 2021 at 19:19
Your current src is relative src="storage..., add a slash before storage, or try with the asset helper <img src="{{ asset('storage'.$products->image_path) }}">. — porloscerros Ψ
– porloscerros Ψ, Commented Jun 6, 2021 at 19:46
here is the link (127.0.0.1:8000/singlepost/storage/…) @matiaslauriti — Gazdallah Amira
– Gazdallah Amira, Commented Jun 6, 2021 at 19:50
Did you run the php artisan storage:link command? Is the file stored in your-project/storage/app/public directory? — porloscerros Ψ
– porloscerros Ψ, Commented Jun 6, 2021 at 19:55

Peppermintology · Accepted Answer · 2021-06-07 07:12:15Z

1

When referencing publically accessible files, you want to do so from the /public/storage directory. Files from the /storage/app/public directory should be mapped from this directory to /public/storage using a symbloic link,

You create the symlink using:

php artisan storage:link

With that done, assets in /storage/app/public can now be accessed as if they existed in /public/storage. Use the asset helper to get your image.

<img src="{{ asset($templates->image_path2) }}" alt="Some alt tag ..." />

The above assumes a relative path of the asset from the /public/storage root, if you had the image in a subdirectory you would need to include that too.

For example, if you had your images in an img subdirectoy:

<img src="{{ asset('/img/' . $templates->image_path2) }}" alt="Some alt tag ..." />

answered Jun 7, 2021 at 7:12

Peppermintology

10.4k4 gold badges34 silver badges60 bronze badges

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

Collectives™ on Stack Overflow

problem while trying to display image from database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related