Symfony display blob value

Question

I have a project to Symfony 3. With MySQL I have a blob field for a profile user image (in bin extension).

This one is saved from my entity user with the preUpload. (I had set the path new file for test only)

But I can't read the file. How can I do this?

The dump of the entity:

You should add how you're trying to use the image blob to the question. Also this stackoverflow.com/questions/7793009/… might be useful. — dlondero
– dlondero, Commented Dec 14, 2017 at 8:57

Ollie in PGH · Accepted Answer · 2018-01-23 13:03:58Z

1

You can display blobs as images with the following HTML5 tag.

<img src="data:image/jpeg;base64,<base64 code here>" />

If you're using this in a Symfony controller it would look like:

/// ... controller code

$user = $this->getDoctrine()->getRepository(User:class)->find($id);
$img = $user->getImg();

// ... more controller code

return $this->render('AppBundle:yourpage.html.twig', [
        'user' => $user,
        'img' => base64_encode($img),
]);

And in twig, you'd display the base64 data in an image tag like this:

<img src="data:image/jpeg;base64,{{ img }}" />

edited Jan 23, 2018 at 13:03

answered Dec 14, 2017 at 17:48

Ollie in PGH

2,6292 gold badges18 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Symfony display blob value

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related