i really run out idea.
my code version can works on the word and excel file(up/download and readable again)
but for pdf file, it can't be opened after download from mysql db...
any trick part to handle pdf file to upload to blob field??
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','$first
name','$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
