Symfony 2: Display an image mediumblob

Question

I'm trying to display a MEDIUMBLOB field of my database, which contain images, with Symfony 2 but I can't do it...

To do this, I created my own Doctrine type. Here is the code:

<?php
/**
 * Personal type to support MediumBlob
 *
 * @author Leglopin
 */
namespace MC\UserBundle\Doctrine\Types;

use Doctrine\DBAL\Platforms\AbstractPlatform;
use Doctrine\DBAL\DBALException;
use Doctrine\DBAL\Types\Type;

/**
 * Type that maps a PHP object to a mediumblob SQL type.
 */
class MediumBlobType extends Type
{
    const MEDIUMBLOB = 'mediumblob';

    public function getName()
    {
        return self::MEDIUMBLOB;
    }

    public function getSQLDeclaration(array $fieldDeclaration, AbstractPlatform $platform)
    {
        return $platform->getDoctrineTypeMapping('MEDIUMBLOB');
    }

    public function convertToDatabaseValue($value, AbstractPlatform $platform)
    {
        return ($value === null) ? null : base64_encode($value);
    }

    public function convertToPHPValue($value, AbstractPlatform $platform)
    {
        return ($value === null) ? null : base64_decode($value);
    }
}

Then, to display the image I'm doing this:

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

where the photo variable is defined in my controller like this:

$photo = base64_encode($user->getPhoto());

But nothing is displayed

Thanks for your help !

Do you added the type? Take a look here

tttony
– tttony

2014-08-06 04:57:09 +00:00
Commented Aug 6, 2014 at 4:57 — tttony
– tttony, Commented Aug 6, 2014 at 4:57

Florentin · Accepted Answer · 2014-08-06 09:39:13Z

1

Yes, I added my type like that in my controller file:

public function boot()
{
    $em = $this->container->get('doctrine.orm.default_entity_manager');

    Type::addType('mediumblob', 'MC\UserBundle\Doctrine\Types\MediumBlobType');

    $em->getConnection()->getDatabasePlatform()
       ->registerDoctrineTypeMapping('MEDIUMBLOB', 'mediumblob');
}

answered Aug 6, 2014 at 9:39

Florentin

1,4332 gold badges13 silver badges22 bronze badges

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

1 Comment

Nickson Yap Over a year ago

The question and answer helped me implement MEDIUM blob in Laravel! Thanks! this Medium article too: medium.com/@matriphe/…

Collectives™ on Stack Overflow

Symfony 2: Display an image mediumblob

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related