If you load the data into the field with addslashes, have you tried
stripslashes on the way out?
Bastien
From: "Mickey Martin" <Mickey.Martin@xxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: help with file downloads from MySQL
Date: Tue, 21 Mar 2006 12:55:56 -0600
Every time I try to download a file from MySQL it cannot be opened. Using
HexEdit, I noticed that all of the files are getting 0a added to the
beginning of them (happens with all browsers).
I can look at the files with MySQL Query Browser and they don't have the
0a.
Using php 4.3.11, Solaris 8, Apache 2.0.54, MySQL 4.1.11.
Here's what I'm using:
mysql_select_db($database_ctnwww, $ctnwww);
$query_Attachment = sprintf("SELECT bin_data, filetype, filename, filesize
FROM IssueAttach WHERE id_files=%s", $_GET['id_files']);
$Attachment = mysql_query($query_Attachment, $ctnwww) or
die(mysql_error());
$row_Attachment = mysql_fetch_array($Attachment);
$data = $row_Attachment['bin_data'];
$name = $row_Attachment['filename'];
$size = $row_Attachment['filesize'];
$type = $row_Attachment['filetype'];
header("Content-type: $type");
header("Content-length: $size");
header("Content-Disposition: attachment; filename=$name");
header("Content-Description: PHP Generated Data");
echo $data;
Thanks in advance,
Mickey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
