Download PDF from Binary SQL SERVER With PHP

Question

I need help with this script. I'm trying to get this binary file stored in a sql server DB . The main problem is that , each time im trying to show it in my browser or to download it, the file is corrupted . Heres my code:

       $binary = $row['PDF_FILE_STORED'];
        file_put_contents('my.pdf', $binary);
        header('Content-type: application/pdf');
        header("Content-Transfer-Encoding: Binary"); 
        header("Content-Length: ".filesize($binary));
        header("Content-Disposition: attachment;filename=my.pdf");
        ob_clean();
        flush();
        echo $binary;

Is there a problem with the encoding aspect? I just got this warning in my brower's console : "Resource interpreted as Document but transferred with MIME type application/pdf" . Any advices ?

Peter Rakmanyi · Accepted Answer · 2018-07-16 15:43:43Z

1

To just download the pdf file, you don't need to save it locally on the server. You don't need to send content-length as that should be done automatically and I would skip the content-transfer-encoding as well.

If there was no output yet, you can also skip dealing with the output buffer.

Try this:

header('Content-Type: application/pdf');
header('Content-Disposition: attachment; filename=my.pdf');
echo $row['PDF_FILE_STORED'];

answered Jul 16, 2018 at 15:43

Peter Rakmanyi

1,7951 gold badge12 silver badges13 bronze badges

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

6 Comments

Random_Display_Name Over a year ago

Thanks for your answer but my pdf is still corrupted for some reason ....

Peter Rakmanyi Over a year ago

What does it look like when you read it from the db? Is it corrupted if you file_put_contents('my.pdf', $row['PDF_FILE_STORED']);?

Peter Rakmanyi Over a year ago

Also, for storing files you should take a look at this answer

Random_Display_Name Over a year ago

In the db i got a binary file, when i try to use file_put_contents('my.pdf', $row['PDF_FILE_STORED']); , it is still corrupted (bad encrypted error from adobe) . But i got an .net app that can read it properly and download it . So actually i don't know whats the main problem...

Peter Rakmanyi Over a year ago

There must be a difference in how it is read by the other .net app and this script. Can you check what query is used in each one and compare?

|

Collectives™ on Stack Overflow

Download PDF from Binary SQL SERVER With PHP

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related