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="sele ct 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><IN PUT Type=\"Button\" Name=\"Back\" Value=\"Back\" onclick=\"histo ry.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($tmpNa me));//error for big files
$content = addslashes($con tent);
/*fclose($fp);*/

if(!get_magic_q uotes_gpc())
{
$fileName = addslashes($fil eName);
}

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

$date_arr1=spli t('[/ :]',$_POST['Expires']);
$Expires=$date_ arr1[2]."-".$date_arr 1[1]."-".$date_arr 1[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,Po sted,Expires,Na me,Type,Doc) VALUES ('".$_POST['Tnumber']."','".$_POS T['Description']." ','".$Posted."' ,'".$Expires."' ,'".$fileName." ','".$_POST['Type']."','".$content ."')";


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

require_once('X XX.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="sele ct 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><IN PUT Type=\"Button\" Name=\"Back\" Value=\"Back\" onclick=\"histo ry.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($tmpNa me));//error for big files
30.
$content = addslashes($con tent);
31.
/*fclose($fp);*/
32.

33.
if(!get_magic_q uotes_gpc())
34.
{
35.
$fileName = addslashes($fil eName);
36.
}
37.

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

41.
$date_arr1=spli t('[/ :]',$_POST['Expires']);
42.
$Expires=$date_ arr1[2]."-".$date_arr 1[1]."-".$date_arr 1[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,Po sted,Expires,Na me,Ty pe,Doc) VALUES ('".$_POST['Tnumber']."','".$_POS T['Description']." ','".$Posted."' ,'".$Expires."' ,'".$fileName." ','".$_POST['Type']."','".$content ."')";
57.

58.

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

61.
require_once('X XX.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_file size 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_file size 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 "3000000000 00" .....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_file size?