problem displaying pdfs from mysql

[monomaniac21]

Hi I have uploaded a pdf file into my db and am trying to display it
again here is the code i have used (at the moment it is just displaying
the binary file's code as text in a html page:

<?php session_start() ;
include("connec tion.php");

$query = "SELECT resource, resource_name FROM tblresources WHERE id =
'3' ";

$result = mysql_query($qu ery) or die(mysql_error () );

$row = mysql_fetch_arr ay($result);
$content = $row['resource'];

header("Content-type: application/pdf");

echo $content;

?>

//am i missing something else to go with header to make it be read as a
pdf file?

Please help!

[Rik]

monomaniac21 wrote:

header("Content-type: application/pdf");

add:
header('Content-Disposition: attachment; filename="somen ame.pdf"');

should work, BTW directy from
http://nl3.php.net/manual/en/function.header.php

Grtz,
--
Rik Wasmus

[monomaniac21]

Cheers Rik is that also required for displaying jpgs and stuff? i dont
remember using it.

[Rik]

monomaniac21 wrote:

Cheers Rik is that also required for displaying jpgs and stuff? i dont
remember using it.

Not for images, no. Allthough some browsers (I know IE does) display pdf's,
it's not HTML, it's officially not for a browser to handle. Browsers can
display HTML and other "simple" files (for instance XML, TXT, all files
easily made in notepad and the like), and (most) images.

Other files have to be first downloaded and then displayed with other
programs. IE uses an external pdf-reader (normally acrobat), but pretends it
is capable of displaying pdf's by running the program "inline" (for lack of
a better word, my english is limited). Hence the confusion.

That's putting it simple. I'm sure there are people on this ng that DO know
what they are talking about who can correct me, but this explanation has
sufficed for me so far :-)

Grtz,
--
Rik Wasmus

[Chuck Anderson]

Rik wrote:

monomaniac21 wrote:

header("Conte nt-type: application/pdf");

add:
header('Conten t-Disposition: attachment; filename="somen ame.pdf"');

should work, BTW directy from
http://nl3.php.net/manual/en/function.header.php

Grtz,

And I've found that you need to use:
header('Content-Disposition: inline; filename="somen ame.pdf"');
.... to display it in the browser

To create a download, save as dialog use:
header('Content-Disposition: attachment; filename="somen ame.pdf"');

--
*************** **************
Chuck Anderson • Boulder, CO
http://www.CycleTourist.com
The world is my country,
Science, my religion
*************** **************

[Rik]

Chuck Anderson wrote:

And I've found that you need to use:
header('Content-Disposition: inline; filename="somen ame.pdf"');
... to display it in the browser

To create a download, save as dialog use:
header('Content-Disposition: attachment; filename="somen ame.pdf"');

As I said, some people do know what they're talking about :-)

Grtz,
--
Rik Wasmus