i have a table which i'm using to store binary data, so that someone
can buy a digital good, and after the payment process is completed
they can download the binary data out of the table, ie. MP3's.

the problem i'm having right now is when i'm trying to save any file
over 900K, i get the error 'max_allowed_packet' bytes.  my script that
i'm trying to save with just basically is:


$tempfile = fopen($uploadfile, 'rb');

$filedata = fread($tempfile, filesize($uploadfile));

$filedata = addslashes($filedata);

and then of course my insert sql statement.  i'm wondering what else
can be done either PHP or MySQL wise to accomdate this better.  It
should be able to handle up to 10 MB files for this project.
Mediumblob is capable of up to 16 but this should be sufficient.  I
get no issues with files under 900K.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to