I don't think that it will help :-( I've tried to set different
headers but still I end up with some strange response, like:
%PDF-1.3
3 0 obj
<</Type /Page
/Parent 1 0 R
/Resources 2 0 R
/Contents 4 0 R>>
endobj
4 0 obj
<</Filter /FlateDecode /Length 1214>>
stream
....
So, if we try to look into this problem as basic. For example, I'm
trying to store file test.pdf from some location on server into my db
like this:
$fp = fopen(PATH_TO_PDF_FILE.'test.pdf', "r");
$size = filesize(PATH_TO_PDF_FILE.'test.pdf');
$type = mime_content_type(PATH_TO_PDF_FILE.'test.pdf');
$file = fread($fp, $size);
Here if I do : var_dump($file) how the content should look like?
$file = base64_encode($file);
close($fp);
$query = sprintf("INSERT INTO `table` SET `file`='%s', `name`='%s',
`size`='%s', `type`='%s'",
mysql_real_escape_string($file),
mysql_real_escape_string('test.pdf'),
mysql_real_escape_string($size),
mysql_real_escape_string($type)
);
mysql_query($query);
And lets try to retrive data now and show them on page:
$query = sprintf("SELECT * FROM `table` WHERE `id`='something'");
$res= mysql_query($query);
$row = mysql_fetch_assoc($res);
header("{$_SERVER['SERVER_PROTOCOL']} 200 OK", True, 200);
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Content-Length: ' . $row['size']);
header('Content-Type: ' . $row['type']);
header('Expires: 0');
header('Pragma: public');
header('Content-Description: File Transfer');
header('Content-Disposition: attachment; filename=" . $row['name']);
header('Content-Transfer-Encoding: binary');
readfile(base64_decode($row['file']));
And here I should get PDF file, but instead I get the same symbols on
the top of page :-(
Any suggestion? Some different header or ... ?
2010/7/27 Richard Quadling <rquadling@xxxxxxxxx>:
> 2010/7/27 Dušan Novaković <ndusan@xxxxxxxxx>:
>> hello,
>>
>> I have some problems with storing files in db and retriving them, so
>> probably I'm doing something wrong :-)
>> Here is the case:
>> I have on one of the pages request to generate some PDF files and
>> store them in database. So, I use FPDF to create files, and that's
>> working perfect. Then my system is collecting generated file(s) and
>> storing them in DB. On the other side (page) I have to show stored
>> files from database.
>>
>> So, when file (in this case PDF) is created and stored in some dir
>> (ex. tmp/file.pdf), by using function: fopen(filename, 'r'); $file =
>> fread(....); I put file(s) in array $tmpArray = array('file' =>
>> base64_encode($file).... ) and send it to model (db). There I have
>> table for files, (column type for file is BLOB). So, first I do the
>> $fileThatWillBeStored = base64_decode($file); and than store it. After
>> that I'm able to see that in DB there is one row with file, so that
>> part is also ok.
>> On the other side when I have to show that file, I just fetch it from
>> DB and again pack it in array, but first do the
>> base64_encode($fileFromDB) and send it to controller, where after
>> doing $file = base64_decode($fileFromDB); I just show it like this:
>> header("Content-length: ".$file['file_size']);
>> header("Content-type: ".$file['file_type']);
>> header("Content-Disposition: attachment; filename= ".$file['file_name']);
>> echo $file['file'];
>>
>> And final result is something like:
>>
>> %PDF-1.3
>> 3 0 obj
>> <</Type /Page
>> /Parent 1 0 R
>> /Resources 2 0 R
>> /Contents 4 0 R>>
>> endobj
>> 4 0 obj
>> <</Filter /FlateDecode /Length 1214>>
>> stream
>> x��W�v�F �� �L ��[�� N ��`'
>> �,{�� $�H�g� �/x�R?$� �Y� ��n=�U0t9"X ��h �O�)� ��5��� � � �Q:��2B!U��( I)0
>>
>> .....
>>
>>
>> So, I hope you get the picture :-) Of course, I've skiped lot of
>> steps, because the code is huge.
>>
>> Any suggestions? additional questions?
>>
>> P.S.
>> I can't read on the other side file from directory, so it has to be in
>> the way I just described ( Generate PDF with FPDF => pack in array,
>> but first base64_encode => send it to model => get from array and
>> unpack it with base64_decode on DB side => store in DB, and then
>> reverse: get from DB => pack in array, but first base64_encode => send
>> it to controller => get it from array and unpack with base 64_decode
>> => show in view with headers)
>>
>> Thnx,
>> Dusan
>>
>>
>> --
>> mob: + 46 70 044 9432
>> web: http://novakovicdusan.com
>>
>> Please consider the environment before printing this email.
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>
> As soon as you've got the data, create a hash of the file (sha1(),
> md5(), etc.) and store that in the database.
>
> When you restore the file, generate a new hash and compare it with the
> stored one to make sure you've got the right data.
>
> Assuming that the hashes match, then the next thing is to use a tool
> like FireBug to see EXACTLY what is being received by the client. This
> seems to be different to what you are sending.
>
> The headers I use for a PDF file download (as compared to a PDF online
> view) are ...
>
> header("{$_SERVER['SERVER_PROTOCOL']} 200 OK", True, 200);
> header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
> header('Content-Length: ' . filesize($a_FPN['PDF']));
> header('Content-Type: application/pdf');
> header('Expires: 0');
> header('Pragma: public');
>
> // Force a Save Dialogue if that is required.
> if ('True' === $b_Save)
> {
> header('Content-Description: File Transfer');
> header('Content-Disposition: attachment; filename="Jobsheet ' .
> $s_OrderNumber . '.pdf"');
> header('Content-Transfer-Encoding: binary');
> }
>
> readfile($a_FPN['PDF']);
>
--
mob: + 46 70 044 9432
web: http://novakovicdusan.com
Please consider the environment before printing this email.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
