RE: [PHP-DB] Problems inserting large blob

I forgot to say that php.ini file has 8Mb set as the maximum possible upload file size. Thanks for everything ... I really need some help on this! João B. ---------------------------------- Joao Barreto - E-Business and Security Manager Convex - Informática e Sistemas de Comunicações Portugal, Lda Tagus Park, Edf. Ciência II, 2º, 2780-920 Porto Salvo Portugal mailto:joao.barreto@convex.pt phone:+351 21 4229200 -----Original Message----- From: Justin Buist [mailto:jbuist@tridenttechnology.com] Sent: quinta-feira, 13 de Setembro de 2001 21:38 To: Joao Barreto Cc: php-db@lists. php. net Subject: Re: [PHP-DB] Problems inserting large blob 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 = addslashes(fread(fopen($form_data, "rb"), filesize($form_data))); > $result=MYSQL_QUERY("INSERT INTO file2download > (description,bin_data,filename,filesize,filetype, filecompany) ". > "VALUES > ('$form_description','$data','$form_data_name','$form_data_size','$form_data > _type', '$empresa')"); > if (mysql_errno() != 0) echo mysql_error(); > $id= 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 the > fid is 0. > > Any ideas? > Is there any limitation on the size of the 'insert into' string? If so, how > 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ão 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