RE: help with file downloads from MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux