How to show image (type binary) from mysql on a view in Laravel 4?

Question

I have the table users on mysql and added a column "image" which is a type binary (image png). When I show the image on a view, I use this code :

<p>Avatar: {{Auth::user()->image}}</p>

but it shows something like that: �PNG IHDR,,y}�u pHYs��tEXtSoftwareAdobe ImageReadyq�e<�nIDATx�� Gy7��}K��]I�...

How can I solve this problem please ?

lemiech · Accepted Answer · 2014-08-21 12:21:42Z

1

Try use something like this:

<img src="data:image/png{{-- change mime type if it's not png --}};base64,{{ base64_decode(Auth::user()->image) }}" />

edited Aug 21, 2014 at 12:21

answered Aug 21, 2014 at 12:14

lemiech

112 bronze badges

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

1 Comment

mbuuuuuuu Over a year ago

Thank you for your help but it didn't work (the image is not shown) so I make some changes on the code, like this : <p>Avatar: <img alt="embedded image" src="data:image/png;base64,{{chunk_split(base64_encode(Auth::user()->image))}}"></p> And now it works :) (y)

Collectives™ on Stack Overflow

How to show image (type binary) from mysql on a view in Laravel 4?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related