Symfony upload file in MySQL blob

Question

I'm trying to save a PDF file in MySQL but It doesn't work. It seems Symfony and Doctrine are not able to save a file in blob row...

When I submit my form with the file, everything seems ok. But when I download the file from my database I have this:

/tmp/phpssT5KJ

It's like the blob row was the path of my file?

All my google research provide a way for moving a file but I don't want to move my file to /web/{something}...

Is it possible? Why my row contains the path instead of the file?

Best regards,

Vender Aeloth · Accepted Answer · 2014-06-03 14:28:09Z

1

So I found how to fix it:

Like the usual method when you save only the path you add a variable $file and the method upload. (On your form you use $file and not your field)

Upload needs this code:

public function upload(){  
    $pdfFile = $this->file;   
    $this->setPdf(file_get_contents($pdfFile));
}

answered Jun 3, 2014 at 14:28

Vender Aeloth

7981 gold badge13 silver badges29 bronze badges

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

Comments

cfv1000 · Accepted Answer · 2014-06-03 13:52:38Z

0

That path is path to your TMP location of the file. You need to put that files content in your DB.

answered Jun 3, 2014 at 13:52

cfv1000

4633 silver badges10 bronze badges

1 Comment

Vender Aeloth Over a year ago

I know that path is the TMP location of the file... But why Symfony/Doctrine puts the path instead of the file in my DB? How can I put the file if Symfony/Doctrine don't?

Collectives™ on Stack Overflow

Symfony upload file in MySQL blob

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related