[RESOLVED] Store and retrieve PDF

[rogerl_uk]

I want to store pdf files in and then retrieve them from a MYSQL database.

I can do this with gifs and jpegs, but not with pdf. Can anyone point me to an appropriate turorial, please?

Please note that I do not want to store these ina diractory as it relates to a content management system for a website,m and the users may not have access to FTP.

[phprock]

Well, it should not make any diference what kind of file are u storing because its all in binary format.

have the pdf file field type as long blob

so, when u read or download the pdf file just sent header information

function viewFile(){
global $db,$prefix;
$id=intval($GET["id"]);
$result=$db->query("SELECT * FROM ".$prefix."file WHERE file_id=$id");
$file=$db->fetch_array($result);
header("Content-type: $file[file_type]");
header("Content-length: $file[file_size]");
header("Content-Disposition: attachment; filename=$file[file_name]");
header("Content-Description: PHP Generated Data");
echo $file[file_data];

}