Try looking at the data that's supposed to be outputing the pdf. Something may be failing somewhere and you might see an error message. If you don't see any error messages and are apparently seeing gthe pdf data, check for whitespace outside php tags and any extraneous echo's or print's, that would very likely cause the pdf to not be able to be read properly.
Chris -----Original Message----- From: Larry Brown [mailto:[EMAIL PROTECTED] Sent: Saturday, December 20, 2003 10:36 AM To: Chris; PHP List Subject: RE: [PHP] mysql load_file retreival Oops, my bad on the post. I am not sending echo header...just header(... I thought, based on reading from mysql that it did escape certain characters. I'll start looking at other possibilities... -----Original Message----- From: Chris [mailto:[EMAIL PROTECTED] Sent: Saturday, December 20, 2003 1:24 PM To: PHP List Subject: RE: [PHP] mysql load_file retreival LOAD_FILE() shouldn't be escaping the data. Are you actually calling : echo header()? the header function should not be echoed. header('Content-type: application/pdf'); echo result[0]; -----Original Message----- From: Larry Brown [mailto:[EMAIL PROTECTED] Sent: Saturday, December 20, 2003 9:29 AM To: PHP List Subject: [PHP] mysql load_file retreival I have set up a script to recieve a pdf file and store it in a mysql db using "update db set field=load_file('fileIncludingFile') where id=$id". Afterwards I can see the file has been uploaded into the blob field successfully and without errors. Now I want to get the file back out. I set up a script with "select field from db where id=$id" and used mysql_query followed by mysql_fetch_row and did echo header("Content-type: application/pdf"); and then echo result[0]; where result was the row fetched. I get the prompt to open with pdf but pdf fails. I have magicquotes on but I understand that the load_file() function within mysql does the escaping etc. How can I "un-escape" the data? The only thing I saw on the mysql manual is on how to use load_file_infile/load_file_outfile which does not apply to this. Can someone lend a hand here? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
