hi all,
my code can upload/download to view msword , excel file to blob field of mysql
but it fails to handle the pdf file............
do i need different coding for handling pdf file format???
here is my code.....
upload.php
$fp = fopen($FILES['resumefile']['tmp_name'], 'rb');
$file = fread($fp, filesize($FILES['resumefile']['tmp_name']));
$file = addslashes($file);
fclose($fp);
$addStmt = "INSERT INTO $tablename values('$department','$job_no','$filename','$firstname','$lastname', '$submittime','$email','$phone','$mobile','$file','$type','$filename')";
download/view.php
assume retrieve from db...
if(mysql_num_rows($result) == 1)
{
$fileType = @mysql_result($result, 0, "filetype");
$fileContent = @mysql_result($result, 0, "data");
$filename = @mysql_result($result, 0, "display");
//header("Cache-Control: private");
header("Content-type: $fileType");
header("Content-Disposition: inline; filename=$filename" );
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Pragma: public");
echo $fileContent;
}
really appreciate if someone can figure out the problems
alex