error while uploading big files say 3.3mb

[pradeepjain]

[PHP]<?php
mysql_connect("localhost", "XXX", "xxx") OR DIE (mysql_error());
mysql_select_db ("XXX") OR DIE ("Unable to select db".mysql_error());
// our sql query
$str_sql1="select Tnumber from Tenders where Tnumber = '".$_POST['Tnumber']."'";
$res_id1=mysql_query($str_sql1);
$rec_row=mysql_fetch_row($res_id1);
$rows=mysql_num_rows($res_id1);
if($rows > 0){

$msg = "Name already exists!!<br><INPUT Type=\"Button\" Name=\"Back\" Value=\"Back\" onclick=\"history.back()\" class=\"button\">" ;
print $msg;
}else{

?>
<?php
if($_FILES['userfile']['size'] < 30000000 )
{
$fileName = $_FILES['userfile']['name'];
//echo $fileName;
$tmpName = $_FILES['userfile']['tmp_name'];
//echo $tmpName;
$fileSize = $_FILES['userfile']['size'];
//echo $fileSize;
$fileType = $_FILES['userfile']['type'];
//echo $fileType;

$fp= fopen($tmpName , "rb");
$content = fread($fp, filesize($tmpName));//error for big files
$content = addslashes($content);
/*fclose($fp);*/

if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
}

$date_arr=split('[/ :]',$_POST['Posted']);
$Posted=$date_arr[2]."-".$date_arr[1]."-".$date_arr[0];

$date_arr1=split('[/ :]',$_POST['Expires']);
$Expires=$date_arr1[2]."-".$date_arr1[1]."-".$date_arr1[0];
/*
echo $Posted;
echo $Expires;
echo $_POST['Description'];
echo $_POST['Type'];
echo $fileName;
*/


mysql_connect("localhost", "XXX", "XXX") OR DIE (mysql_error());

// select the db
mysql_select_db ("XXX") OR DIE ("Unable to select db".mysql_error());
$query = "insert into Tenders(Tnumber,Description,Posted,Expires,Name,Ty pe,Doc) VALUES ('".$_POST['Tnumber']."','".$_POST['Description']." ','".$Posted."','".$Expires."','".$fileName."','". $_POST['Type']."','".$content."')";


mysql_query($query) or die('Error, query failed');

require_once('XXX.tpl');

echo "<br>File $fileName uploaded<br>";

}
}
?>
[/PHP]

i am using this code it works very well for small files but as i upload big files it gives eror near the fopen line...can any one help on this

[pbmods]

Heya, Pradeep.

What error do you get?

[pradeepjain]

hai pbmods,

warning: fread(): supplied argument is not a valid stream resource in /var/www/html/drupal/includes/common.inc(1343) : eval()'d code on line 29.


This is the error i get ..only for large files....and bcos of this error the download of the upload file is also not proper

any solution for this

Thanks,
pradeep

[pbmods]

Heya, Pradeep.

Check $_FILES['userfile']['error'] and match it against this list.

[pradeepjain]

[PHP] 1.
<?php
2.
mysql_connect("localhost", "XXX", "xxx") OR DIE (mysql_error());
3.
mysql_select_db ("XXX") OR DIE ("Unable to select db".mysql_error());
4.
// our sql query
5.
$str_sql1="select Tnumber from Tenders where Tnumber = '".$_POST['Tnumber']."'";
6.
$res_id1=mysql_query($str_sql1);
7.
$rec_row=mysql_fetch_row($res_id1);
8.
$rows=mysql_num_rows($res_id1);
9.
if($rows > 0){
10.

11.
$msg = "Name already exists!!<br><INPUT Type=\"Button\" Name=\"Back\" Value=\"Back\" onclick=\"history.back()\" class=\"button\">" ;
12.
print $msg;
13.
}else{
14.

15.
?>
16.
<?php
17.
if($_FILES['userfile']['size'] < 30000000 )
18.
{
19.
$fileName = $_FILES['userfile']['name'];
20.
//echo $fileName;
21.
$tmpName = $_FILES['userfile']['tmp_name'];
22.
//echo $tmpName;
23.
$fileSize = $_FILES['userfile']['size'];
24.
//echo $fileSize;
25.
$fileType = $_FILES['userfile']['type'];
26.
//echo $fileType;
27.
$error = $_FILES['userfile']['error'];/* here*/
28.echo $error;
$fp= fopen($tmpName , "rb");
29.
$content = fread($fp, filesize($tmpName));//error for big files
30.
$content = addslashes($content);
31.
/*fclose($fp);*/
32.

33.
if(!get_magic_quotes_gpc())
34.
{
35.
$fileName = addslashes($fileName);
36.
}
37.

38.
$date_arr=split('[/ :]',$_POST['Posted']);
39.
$Posted=$date_arr[2]."-".$date_arr[1]."-".$date_arr[0];
40.

41.
$date_arr1=split('[/ :]',$_POST['Expires']);
42.
$Expires=$date_arr1[2]."-".$date_arr1[1]."-".$date_arr1[0];
43.
/*
44.
echo $Posted;
45.
echo $Expires;
46.
echo $_POST['Description'];
47.
echo $_POST['Type'];
48.
echo $fileName;
49.
*/
50.

51.

52.
mysql_connect("localhost", "XXX", "XXX") OR DIE (mysql_error());
53.

54.
// select the db
55.
mysql_select_db ("XXX") OR DIE ("Unable to select db".mysql_error());
56.
$query = "insert into Tenders(Tnumber,Description,Posted,Expires,Name,Ty pe,Doc) VALUES ('".$_POST['Tnumber']."','".$_POST['Description']." ','".$Posted."','".$Expires."','".$fileName."','". $_POST['Type']."','".$content."')";
57.

58.

59.
mysql_query($query) or die('Error, query failed');
60.

61.
require_once('XXX.tpl');
62.

63.
echo "<br>File $fileName uploaded<br>";
64.

65.
}
66.
}
67.
?>[/PHP]




as u said i added tht line of code and checked ..no error msg came ..

[pradeepjain]

wht exactly might be the prob...bcso it works well fro small files naa.

[pradeepjain]

Heya, Pradeep.

Check $_FILES['userfile']['error'] and match it against this list.

hey tht error tht i had posted is gone....but for large files its showing
"Error, query failed" ......so whts the problem with the large files

[pbmods]

Heya, Pradeep.

I'd bet that the problems is that either PHP's upload_max_filesize directive or else the MAX_FILE_SIZE value is too low.

[pradeepjain]

Heya, Pradeep.

I'd bet that the problems is that either PHP's upload_max_filesize directive or else the MAX_FILE_SIZE value is too low.

the file size tht i am trying to upload is 3426132 and the MAX_FILE_SIZE tht is being set is "300000000000" .....so id ont think ist an prob....can there be any php setting or an issue with the host

[pbmods]

Heya, Pradeep.

What about upload_max_filesize?

[pradeepjain]

Heya, Pradeep.

What about upload_max_filesize?

upload_max_filesize????.....hey i hve not used anything of such type...
where do we need to use it...


[HTML]<td valign="top" class="subheading">Doc<span class="mandatory">*</span>:</td>
<input type="hidden" name="ID" value="<?php $Colloquiums[$nr][ID] ?>">
<input type="hidden" name="MAX_FILE_SIZE" value="3000000000000" />
<td><input name="userfile" type="file" size="35" /></td>[/HTML]


this is wht i hve used...

[pradeepjain]

upload_max_filesize????.....hey i hve not used anything of such type...
where do we need to use it...


[HTML]<td valign="top" class="subheading">Doc<span class="mandatory">*</span>:</td>
<input type="hidden" name="ID" value="<?php $Colloquiums[$nr][ID] ?>">
<input type="hidden" name="MAX_FILE_SIZE" value="3000000000000" />
<td><input name="userfile" type="file" size="35" /></td>[/HTML]


this is wht i hve used...

hey pbmods,
wht happened y no replies

[pradeepjain]

hey pbmods,
wht happened y no replies

hey this is the new error

Got a packet bigger than 'max_allowed_packet' bytes

[pbmods]

Heya, Pradeep.

upload_max_filesize is defined in php.ini.

Check out this page.

[mwasif]

You are getting max_allowed_packet error due to MySQL configuration. I have answered your question related this problem in MySQL Forum.

[pradeepjain]

ok thanks for ur help pdmos.my problem is solved..wll seek help when eer its required.

Thanks,
Pradeep