Re: Problems inserting large blob

I also facing this problem yesterday. Do you want to know what i did ? I open the file with notepad then copy & paste it. And it's works --- Justin Buist <jbuist@tridenttechnology.com> > wrote: >You might want to check php.ini - if memory serves the maximum filesize >you can upload over HTTP by default is 2MB. Bump that number up and >restart Apache (or whatever webserver you use) and see if that fixes the >problem. > >Justin Buist >Trident Technology, Inc. >4700 60th St. SW, Suite 102 >Grand Rapids, MI 49512 >Ph. 616.554.2700 >Fx. 616.554.3331 >Mo. 616.291.2612 > >On Thu, 13 Sep 2001, Joao Barreto wrote: > >> >> Hello all ... >> >> I'm having a problem uploading large files (3MBytes for examples) >> and inserting it onto a MySQL database. No problem with smaller files. >> >> The code is basically this: >> >> <?php >> $data =3D addslashes(fread(fopen($form_data, "rb"), filesize($form_data))= >); >> $result=3DMYSQL_QUERY("INSERT INTO file2download >> (description,bin_data,filename,filesize,filetype, filecompany) ". >> "VALUES >> >> ('$form_description','$data','$form_data_name','$form_data_size','$form_d= >ata >> _type', '$empresa')"); >> if (mysql_errno() !=3D 0) echo mysql_error(); >> $id=3D mysql_insert_id(); >> ?> >> >> When the files are the mentioned size (I checked the whole file got there= > on >> /tmp/something) >> I get an error message along these lines: 'MySQL Server moved away' and t= >he >> fid is 0. >> >> Any ideas? >> Is there any limitation on the size of the 'insert into' string? If so, h= >ow >> can I store >> such a big data chunk on the database? >> >> And please, answer directly by email as well to me. Sometimes it is >> difficult to find >> a message among the ones that we get each day! >> >> Thanks for your support, >> Jo=E3o Barreto - Convex Portugal >> >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >> For additional commands, e-mail: php-db-help@lists.php.net >> To contact the list administrators, e-mail: php-list-admin@lists.php.net >> > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net _____________________________________________________________ www.kaskus.com - FREE EMAIL SERVICE