Uploading a 13MB quicktime movie to mysql

padanaram

I have tried to upload a 13MB file to a mysql database. I have a max upload limit of 16MB. When I try to upload a small file it works fine, but hwne i try to upload the 13MB file it comes up with an error message saying that it tried to upload a 13MB file and taht the max memory limit of 16MB was exhausted. It says that there is an error on line 23. I have commented line 23 below. Should I increase my php memory limit? Why is it saying that the 13MB memory limit is exhausted when the file is 13MB?

if (($_FILES['file']['name'] != "") && ($_FILES['file']['size'] > 0)){
                $tmpName  = $_FILES['file']['tmp_name'];
                $fp = fopen($tmpName, 'r');
                $file = fread($fp, filesize($tmpName));  // line 23
                $file = addslashes($file);
                fclose($fp);

BlackRaven

You might have another problem when you insert it into your mysql db: blobs are typically 64k in size, so you will probably have to split your file into chunks after it is uploaded and insert it piece by piece. Then, you'll have to reassemble it when you get it out again.

hagen00

Please just upload the file onto the server and then reference the file path in the database. Why on earth would you want to store it as a blob? Yuck...The above solution sounds pretty horrible.

padanaram

I know. I don't want to put a file that large in the database either.

alpha_juno

Hi there,

Try setting higher values for both memory_limit and upload_max_filesize in the php.ini also possibly try post_max_size...

you can do this via a .htaccess file in the site folder aswell if your using apache......

in my experience you need significantly higher values than the file you are trying to upload...

I guess its due to additional memory the script needs to process the file.... please correct me if i'm wrong....

Good luck ;]

twilliamsen

one problem the connection isn't closed thus you limited out on your session.

Second, I would NEVER load a file into a DB. I would set a default directory for uplodaed files then reference the file using the location in the database

MarkR

This sounds like a generally bad idea, however, if you feel compelled to try to do it anyway, you must use mysqli or PDO and bind the parameter to a PHP stream (or some similar method) to send it in chunks. Read the MySQL C interface documentation and the mysqli / PDO docs for more info.

Otherwise you'll probably hit the mysql max packet size.

Also in MySQL it needs to be a LONGBLOB to store files > 64k (as others have noticed).

I am assuming here you are using MySQL 5. If you aren't, upgrade or forget it.

This is probably a really bad idea anyway.

Mark