Display pdf from database using php

Question

There is a pdf file stored in my database as a [BLOB - 143.3 KiB]. It's got a userid of 12. I am trying to call it to the page so that when I click on a button, the pdf populates the webpage.

if (isset($_POST["work"]) && !empty($_POST["work"])) 
 {
   $result = mysql_query("SELECT file FROM ce WHERE userid=12", $c) or die("six");
   $document1=mysql_result($result, 0, 'file'); 
   echo $document1;
 }

 echo '
       <form action="yourcase.php" method="post">
          <input type="hidden" name="work" value="1">
          <input type="image" id="work" src="images/papers.png">
       </form>';

Currently, it echos out a page of this: ‰ŒA Â@E÷9Å_ê&&Ói[Å½Â€°£ ZqŠôúÆŽ@ïåÿ&ŠÆÑ,¢Y[«*ÆX%Ó@/RˆOÝçÇ¡.

Using another post, I was able to call a pdf file from my desktop, but I can't figure out how to do it from the database.

$file = 'sample.pdf';
$filename = 'sample.pdf'; 
header('Content-type: application/pdf');
header('Content-Disposition: inline; filename="' . $filename . '"');
header('Content-Transfer-Encoding: binary');
header('Content-Length: ' . filesize($file));
header('Accept-Ranges: bytes');
@readfile($file);

Thanks to @Fred, I was able to piece together a working solution. This does what I've been trying to do:

if (isset($_POST["work"]) && !empty($_POST["work"])) 
 { 
   $result = mysql_query("SELECT file FROM ce WHERE userid=12", $c) or die("six");
   $document1=mysql_result($result, 0, 'file'); 
   header('Content-type: application/pdf');
   echo $document1;
 }

 echo '
        <form action="fetchdoc.php" method="post">
           <input type="hidden" name="work" value="1">    
           <input type="image" id="work" src="images/papers.png">
        </form>';

That's in case you wish to call it "another" name, hence $filename = 'Custom file name for the.pdf'; which I doubt you want to do, unless you want to email it as an attachment or for downloading under another name. — Funk Forty Niner
– Funk Forty Niner, Commented Aug 10, 2013 at 2:32
Have a look at this question on SO, including my answer on the same page. It may be of help stackoverflow.com/questions/17872470/… — Funk Forty Niner
– Funk Forty Niner, Commented Aug 10, 2013 at 2:37

Community · Accepted Answer · 2017-05-23 12:24:38Z

1

Look through these links which may be of help.

edited May 23, 2017 at 12:24

CommunityBot

11 silver badge

answered Aug 10, 2013 at 3:18

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

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

Comments

wesleywmd · Accepted Answer · 2013-08-10 02:23:16Z

0

Your going to have to create the pdf file and then use header to read that file. If you don't plan on keep the files, you can load them to a temp directory and then delete them when your done. If you echo the blob data from your database, its like opening a .pdf file with notepad.

answered Aug 10, 2013 at 2:23

wesleywmd

6052 gold badges7 silver badges21 bronze badges

1 Comment

Tim Over a year ago

Great. Could you show how to do that. I'm very new and all I can think of is this

Tim · Accepted Answer · 2013-08-14 01:57:40Z

0

Thanks to @Fred, I was able to piece together a working solution. This does what I've been trying to do:

if (isset($_POST["work"]) && !empty($_POST["work"])) { 
$result = mysql_query("SELECT file FROM ce WHERE userid=12", $c) or die("six");
$document1=mysql_result($result, 0, 'file'); 
header('Content-type: application/pdf');
echo $document1;}
echo '<form action="fetchdoc.php" method="post"><input type="hidden" name="work" value="1">    
<input type="image" id="work" src="images/papers.png"></form>';

answered Aug 14, 2013 at 1:57

Tim

631 gold badge1 silver badge10 bronze badges

Collectives™ on Stack Overflow

Display pdf from database using php

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related