Viewing PDF files stored in MySQL database using PHP error

Question

I am creating a button, that on click it views the PDF uploaded in the MySQL database in new window here's my code:

Button:

<td><a href='view.php?id={$row['id']}'>View</a></td>

view.php:

<?php

header('Content-type: application/pdf');
echo $pdf_from_database;

the code seems to work and newtab is started, adope start loading, and then I get an error:

file does not begin with "%pdf-"

Anyone knows how to solve the problem?

Whatever you have in $pdf_from_database is not a valid PDF file. Post the code that creates that. — Cfreak
– Cfreak, Commented Mar 13, 2012 at 21:46

Khalid · Accepted Answer · 2012-03-28 22:52:58Z

1

you are missing some links here.

first the pdf files should be stored somewhere on a server.
what you store in the database is information relative to the pdf file such as a url link to it.

so lets say you have a page http://www.mypage.com and your pdf files are store in http://www.mypage.com/pdf/

you have a pdf file stored in there called file_DBid_83.pdf

when you make a mysql query to open that file, your query returns $row['id'] which is 83 for example

so to open the file you go

header('Content-type: application/pdf');
echo "/pdf/file_DBid_" . $row['id'] . ".pdf";

answered Mar 28, 2012 at 22:52

Khalid

1901 gold badge1 silver badge7 bronze badges

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

1 Answer 1