ID: 43306
Comment by: marcell at equylybra dot com
Reported By: d dot tas40 at chello dot nl
Status: No Feedback
Bug Type: Scripting Engine problem
Operating System: Windows XP
PHP Version: 5.2.5
New Comment:
Also having issues using the same script. I get no errors when
downloading files with sizes below 20Mb.
>From 20Mb files are perfectly downloaded via FTP but are saved with a
corrupted file size (0Kb) when downloaded via PHP. Tryed the solution
proposed by "webmaster at anpera dot net" too but I had no success.
Tryed without Content-Lenght header with no effect. Also tryed with
different Content-Types (e.g.
'application/octet-stream','application/force-download','application/zip').
I am on PHP 5.2.8 with Apache 2.2.11 under Linux
Previous Comments:
------------------------------------------------------------------------
[2008-12-24 18:31:39] jon at jonraivala dot com
Using strlen of the blob instead of filesize in the header works for
me.
Example -
header("Content-Length: ".strlen($blob_data));
Hope this helps someone.
------------------------------------------------------------------------
[2008-10-23 09:54:32] arasan at mahiti dot org
I've used this code but the download rate is very slow compared to
ordinary download. whether there is any way to overcome this?
------------------------------------------------------------------------
[2008-09-25 04:51:26] lbarn...@php.net
Please try without any Content-Length header, your HTTP server is
probably using a chunked transfert encoding. Also try with a
Content-Type like 'application/octet-stream'.
Also check the character_set_* variables in your MySQL connection, the
server may try to convert the query or the results if some variables do
not match (blobs are binary but queries and results are not).
------------------------------------------------------------------------
[2008-09-25 02:54:18] alphajet1024 at hotmail dot com
I have the very same problem, but my host server is PHP Version 4.3.11
with Linux OS, i use the following code snippest to recieve the file
from form and upload it to a BLOB field in SQL, the code works fine with
all file extensions, except rar and zip files, they mostly are
corrupted.
upload.php
<?php
if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$fp = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);
if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
}
include('conf.php');
// open database connection
$connection = mysql_connect($host, $user, $pass)
or die ('Unable to connect!');
// select database
mysql_select_db($db)
or die ('Unable to select database!');
$query = "INSERT INTO upload (name, size, type, content ) ".
"VALUES ('$fileName', '$fileSize', '$fileType', '$content')";
mysql_query($query) or die('Error, query failed ' . mysql_error());
?>
////////////////////////////////////////////////////////////////////
download.php
<?php
if(isset($_GET['id']))
{
// if id is set then get the file with the id from database
include('conf.php');
// open database connection
$connection = mysql_connect($host, $user, $pass)
or die ('Unable to connect!');
// select database
mysql_select_db($db)
or die ('Unable to select database!');
$id = $_GET['id'];
$query = "SELECT name, type, size, content " .
"FROM upload WHERE id = '$id'";
$result = mysql_query($query) or die('Error, query failed');
list($name, $type, $size, $content) = mysql_fetch_array($result);
header("Content-length: $size");
header("Content-type: $type");
header("Content-Disposition: attachment; filename=$name");
}
php echo $content;
?>
------------------------------------------------------------------------
[2008-01-12 17:08:06] webmaster at anpera dot net
I have a similar problem with PHP 5.2.4 / 5.2.5 with Apache2.2 under
Windows 2003.
Downloaded files are missing exactly 15 bytes at the end. ZIP and RAR
files can't be opened correctly after download but definitely are okay
on the server's hard drive.
With
$filesize=filesize($filename)+15;
the downloads are working.
$size = @filesize($filename)+15;
header('Pragma: public');
[...]
header("Content-Length: $size");
$fp = @fopen($filename, 'rb');
[...]
while (!feof($fp)){
echo fread($fp, 8192);
}
fclose($fp);
[...]
flush();
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/43306
--
Edit this bug report at http://bugs.php.net/?id=43306&edit=1
