problem posting files over 1MB to MySQL

[agrarusa]

I am trying to post file over 1MB to MySQL LONGBLOB, it just doesnt do the query, if the file is under 1 MB no problem.

Any Ideas if there could be set limitations in PHP or MySQL?

to read the file i am using following:

$data = ""; 
$fp = fopen($filename, "rb"); 
while(!feof($fp)) 
{ 
    $data .= fread($fp, 1024); 
} 
fclose($fp); 

$data = addslashes($data); 
$data = addcslashes($data, "\0");

[Sxooter]

IS this always happening at exactly 1 Meg boundaries? Could be you're running out of memory in PHP, what's the max in php.ini? I think the default is / was 8 megs last I checked.

[Sxooter]

And there's no need to loop if you're using fread, just fread the whole thing:

$filename="testfile";
$fp=fopen($filename,"r");
$data = fread($fp,filesize($filename));

...

[agrarusa]

you're right about script i the loop is not neccessary it was just my desperation

about 1MB problem i thin it's described here