How do I display image path stored in database PHP? (Laravel Orchid)

I want to display images in my Laravel Orchid admin panel. Orchid stores the uploaded images in this folder, with the folder name being the date it was uploaded:

storageapppublic2021421<name>

Laravel stores the image original name, path, extension etc in a special table called ‘attachments’. It is linked to my main table called ‘users’ by an id, image_id in ‘users’ and id in ‘attachments’. In my database, the path is stored as the date, e.g:

2021/04/21/

I did this SQL join query to retrieve the image:

$image = $user->image_id;
$images = DB::table('users')
          ->leftJoin('attachments', 'users.image_id', '=', 'attachments.id')
          ->where('users.image_id', '=', $image)
          ->get(['name', 'original_name', 'path', 'extension']);
            
            foreach($images as $image)
            {
                
                $image_url = $image->path.$image->name.'.'.$image->extension;
                return "<img src='{$image_url}'
                <span class='small text-muted mt-1 mb-0'>{$image->original_name}</span>";
            }

I can display the original name however the image does not display. I would like to know if there is anything wrong with the way i retrieved the image. Thank you.

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

The public path to your images is configured in your configfilesystems.php file.

There will be a section that looks something like this:

'public' => [
            'driver' => 'local',
            'root' => storage_path('app/public'),
            'url' => env('APP_URL').'/storage',
            'visibility' => 'public',
        ],

You likely need to correct the image’s path you are saving into the database to match what’s configured here, note the ‘url’ value matches what you mentioned it the working location to your photos.

Method 2

Assuming $image_url="2021/04/21/12876b4a034032120b0a3cc3972f19cf2411aaaf.png" and your file is in /storage/public/2021/04/21/12876b4a034032120b0a3cc3972f19cf2411aaaf.png

As the image is in storage path you can create a route which response the image.

Route::get('/image/{path}', function ($path) {
   return IlluminateSupportFacadesStorage::disk('public')->response($path);
})->where('path', '.*')->name('show.image');

And replace your return "<img src='{$image_url}' with return "<img src='{route('show.image',['path'=>$image_url])}'

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0