help with file downloads from MySQL
| From: | Mickey Martin | Date: | Tue, 21 Mar 2006 18:55:56 +0000 |
| Subject: | help with file downloads from MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-41559@lists.php.net to get a copy of this message | ||
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